Copying Sheet with Pivot charts
 

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

Copying Sheet with Pivot charts
 

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

"RobN" <none wrote in message
...
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

Copying Sheet with Pivot charts
 

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 wrote:
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

"RobN" <none wrote in message
...

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






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Copying Sheet with Pivot charts
 

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

"Debra Dalgleish" wrote in message
...
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 wrote:
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

"RobN" <none wrote in message
...

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






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html