Pivot Table Chart - Group Totals

D

Dave Eade

I have a pivot table which is translated into a chart.
I have 20 rows of data, each has a numeric value, which is in turn
translated into a Vertical Bar Chart.
I can get the chart to display the relevant values for each Bar.

Now I have "grouped" some of the rows in the pivot table, and the pivot
table displays the totals for each of the groups, the chart "groups" together
the bars under a relevant heading that I have given in the PT.

What I now want to do is display on the chart somewhere [ possibly at the
bottom where the group headings are displayed ] the totals for each of the
groups.

Can this be done, if so how can I achieve it?

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
Bar Chart with Data Elements 1
Pivot Table Charts - Help Required 1
Dealing with a Pivot Table (when I don't want to) 0
Creating a Chart on form from selected data in query. 0
Exporting Outlook 2007 contact list without losing groups 0
Move Chart with Text 0

Top