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!