Pivot Table Chart - Group Totals
 

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

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