How to add colum totals to a pivot chart data table

[Tmarsh]

I have a chart for pivot table and would like to so totals for the data. The
data table on the chart displays the pivot table data but not the totals for
each column. How can the totals be displayed on the chart?

 

[Infinitogool]

Hi Tmarsh
You can't include the Grand Total in a pivot chart. You could create a
normal chart, based on the pivot table, and include the totals in that.

On Jon Peltier's site, there are instructions for creating a normal
chart from pivot data:
http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm

Regards,
Pedro J.