Thread: How to add colum totals to a pivot chart data table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Infinitogool Infinitogool is offline
external usenet poster
  
Posts: 52
Default How to add colum totals to a pivot chart data table
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.
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?
Reply With QuoteReply With Quote