Pivot Table Chart

D

Dave Eade

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Dealing with a Pivot Table (when I don't want to) 0
Referencing a pivot tables Grand Totals Column 1
Creating a Chart on form from selected data in query. 0
Pivot Tables and Filter Criteria Display 0
Pivot Table Charts - Help Required 1
Chart filtered pivot 0

Top