Pivot Table Chart - Group Totals


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

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



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