Showing Pivot Table total on Associated Pivot Chart

K

KenY

Hi

I have a pivot chart created from a pivot table, showing individual values
for each of the items. The pivot table also shows a 'total' for the items.
I would like to display the 'total' on the pivot chart as a line running
across the chart (ie plot it as a point associated with each of the items).
Is there a way to do this? I have tried creating a new column on the
worksheet and trying a copy/paste onto the chart area, but this does not work.

Appreciate any help available on this one

Thanks
 
K

KenY

Thanks for the suggestion. I had hoped there was an easier way using regular
Excel functions as I am using a macro to generate a series of graphs from the
same pivot table. The technique I use (found on the Microsoft site) is to
create a copy of the main pivot table, create the view required, create
PivotChart, deleted the tab containing the copy of the main pivot table.
This works well as the resultant chart can still be interogated or
reformatted to find/show the actual values. It does not contain enough
information to return a 'total'
 
Top