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