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