Pivot Table Chart - Group Totals
bump
"Dave Eade" wrote:
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
|