Excel Charts / Pivot Tables

[Bluebird]

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

[Grinder]

Without Excel in front of me, it sounds like you should try placing another pivot table below the chart with the group totals to achieve the effect you want.

You might even be able to put it behind the chart object, and make the background transparent.