Copying Sheet with Pivot charts

[RobN]

I have created a sheet with 2 pivot charts. The pivot table for each chart
is also on the same sheet.
I now want to copy that sheet (about 6 times), and change the Pivot Table
filters slightly ie I select a different State of Australia.
When I do that, the pivot tables reflect the correct data. However, the
Pivot Chart is still refering to the data source from the sheet it was
copied from, and the Chart data range: box shows this is the case, but that
field is greyed and I can't change it.

I'm using Vs2007

Rob

 

[RobN]

Not having had a reply makes me think no-one knows an answer to this?

One further matter I've just noticed is that I cannot add a Trendline. That
option is greyed out.
Does that give a clue to anyone. Please help!

The basic question, How do I copy a Pivot Chart and associate it with
another Pivot Table?

Rob

 

[Debra Dalgleish]

You can't change the source data for a pivot chart. You'll have to
create a new pivot chart, based on the new pivot table.

 

[RobN]

Thanks Debra,

I finally gave up trying to copy the sheet and basing the Pivot chart on
another Pivot report. But thanks for confirming it couldn't be done.

Rob