How to include the Grand Total Column in a pivot table chart?

[Guest]

Hi, I have a simple pivot table with two columns A and B against several rows
of responses. The pivot table also shows the Grand Total Column.

I can graph the pivot table quickly and simply with the chart wizard (a bar
chart in this instance) and it will display a bar for column A and a bar for
B grouped per row response. Great.

I want to add what is effectively the third column in the pivot - Grand
total column, so I would have 3 bars per row response; A, B and Grand Total.
I can then compare A and B to the total bar.

How do I add/show the grand total in the pivot chart?

Thanks!

 

[Debra Dalgleish]

You could created a stacked column chart, that would show A and B in one
column. The top of the each column is the grand total.

Or, in the pivot table, create a calculated item =A+B, or a calculated
field, if A and B are separate fields.