grant total in pivot chart

[lyntan]

hello. can anyone tell me how to add the grand total in pivot chart?!

 

[Steve=True]

Hi Lyntan,

They are typically there by default. If you need to add them, do the following:

1) Right click on the pivot table and select Pivot Table Options
2) Click on the Totals and Filters Tab
3) Check the boxes for "Show Grand Totals for Rows" & "Show Grand Totals for Columns"

Hope this helps.

Steve=True

 

[lyntan]

Hi Lyntan,

They are typically there by default. If you need to add them, do the following:

1) Right click on the pivot table and select Pivot Table Options
2) Click on the Totals and Filters Tab
3) Check the boxes for "Show Grand Totals for Rows" & "Show Grand Totals for Columns"

Hope this helps.

Steve=True

hello. i think you're talking about pivot table?
im asking for pivot chart
thanks for your help!

 

[LikeButtah]

I don't know of a way to do a "Grand Total" in a Pivot Chart, which is why I guess I would usually just create a regular chart from the Pivot Table which of course has the Grand Total's available. Or...(sarcastically) add data labels and have them take out a calculator to add up all the columns

 

[humdingaling]

not directly

see a couple of workarounds here
How to show Grand Totals on Pivot Chart - Microsoft Community

essentially
use data of pivot to do a normal chart
use a calculated field to replicate grand total in fields