Include Totals in Pivot Chart

D

dcronje

I am compiling a report on our customer feedback using Pivot Tables an
Pivot Charts.

What I am doing is taking the feedback per region and averaging eac
indicator.

So for arguments sake using "Overall Satisfaction" I get an averag
score of say 8.67 in the midlands and 8.23 in the north and anothe
indicator of say "Value for Money" with an average score of 7.9 and 8.
in the midlands and north respectively. I have no problem show this i
"Clustered Coloumn" Chart where it shows "Overall Satisfaction" for th
Midlands and the North next to each other and the same for "Value fo
Money" but what I am trying to do is show "Overall Satisfaction" fo
the Midlands,North and then the average for the Group next each other
It is basically including the "Total Fields" in the chart.

Hopefully you will understand what I am trying to do.

Thanks
Davi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top