Pivot chart and Total row

[rexmann]

Hi All

I have a Pivot table and attached Pivot chart (all good so far). However,
there are three columns (drop column details here) which are the two columns
of data and a grand total column (showing the average of my two data columns)

When I turn it into a pivot chart it does not display the grand total column
as well (is there a way to do this). I have tried to go into the chart
options but these are locked.

I can copy and paste the results but this is a bit clumsy.

Any suggestions - any help greatly appreciated

Kind regards

Rexmann

PS using excel 2003