G
Guest
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
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