View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Eade Dave Eade is offline
external usenet poster
 
Posts: 53
Default Pivot Table Chart

Hi, I have got a pivot table with about 12 rows and 2 colums of data, which
are summed from elsewhere in the sreadsheet.

I've then got a Pivot Table chart which displays the data in nice pretty
columns, with the totals below in a grid.

However in my actual pivot table, the two colums are summed themselves into
"grand totals" - how do I get this data to display on the chart - I've tried
"grouping" which gives me the values I want, but of course that screws all
the individual row data - is there just an opion somewher which says "display
totals as text on chart" ??

Thanks