Grand Total in Pivot Chart

[jaya_sinnathamby@yahoo.com]

I am doing a simple summary of survey data using Pivot Table. The Pivot Table contains all the data I need to make comparisons of say Eastern, Western, North, South and Grand Total.


When I create the Pivot Chart, the Grand Total column does not appear, but I want to able to compare Eastern vs Grand Total. Copying this to a normal table and creating a chart does not fulfill requirement as you cannot interact with a normal chart.


My understanding is that I need to use 'calculated field' to create the Total/Average so that it can be used in the Pivot Chart, but I have not been able to figure out how.


The sample worksheet contains survey data(subset) - the 2nd worksheet contains the pivot table and chart and you will see that Overall is not accessible. The 3rd worksheet has been manually created; it has the proper chart, but you cannot interact with it because it is not a pivot chart.


https://docs.google.com/open?id=0BxXeZvAvqG3ja1FITkxFd2RoRkk


Help!

 

[NARAYANK991]

Hi Jaya ,


Googling this topic says what you want is not possible ; have you checked this link ?


http://www.pcreview.co.uk/forums/do-show-grand-total-pivot-chart-t2205597.html


Narayan

 

[jaya_sinnathamby@yahoo.com]

I googled the topic first and I just refused to believe that this was not possible!


I assumed that there must be a workaround using 'calculated field' and I was hoping someone had already cracked this problem before.


I am still hoping that it can be done. The trouble with normal charts is that they are not intercative.


I guess my next question will be how to make normal charts interactive like Pivot Charts!

 

[NARAYANK991]

Hi Jaya ,


Do you think this can help ? It is based on Excel 2010.


http://www.mrexcel.com/forum/excel-questions/603519-possible-solution-people-looking-reference-grand-total-pivot-chart.html


Narayan

 

[jaya_sinnathamby@yahoo.com]

Narayan,


It seems like a very tedious solution and it won't scale for my requirement; at least I don't think so.


I may have to settle for a normal table.


Thanks.


Jaya