Pivot chart - how to change data source

[CuriousPivot]

Hi,
after I created a Pivot Chart from a Pivot table, I like to keep the format of the Pivot Chart but want to change to a different Pivot table, how do I do that? this is what I tried: PivotChartTools - Design - Select Data, in the Select Data Source dialog box, Chart data range is gray out such that I can enter a different table name. Please advice,

thx,

 

[sijpie]

Right click in your Pivot Table and select 'PivotChart Wizard'

Click the '<Back' button, and here you can change the siource data.

 

[GlennUK]

Hi,
after I created a Pivot Chart from a Pivot table, I like to keep the format of the Pivot Chart but want to change to a different Pivot table, how do I do that? this is what I tried: PivotChartTools - Design - Select Data, in the Select Data Source dialog box, Chart data range is gray out such that I can enter a different table name. Please advice,

thx,

Just for info can you tell us what version of Excel you are using?

 

[CuriousPivot]

I'm on Excel 2007, thx,
CuriousPivot

 

[GlennUK]

I think what you need to do is copy the pivottable and pivotchart elsewhere, and then point the copied pivottable to the new data.

 

[sijpie]

see my mail. That works.

 

[RoryA]

If you have a solution, please post it openly.

 

[sijpie]

Rory, I meant my previous post above. But now I see that the forum has deleted half the text, so here we go again:

Solution:
Right click in the pivot table and select 'Chart Wizard'
Press the 'Back' button and enter the required source range.
Press 'Finish'

 

[GlennUK]

Surely that just changes what the current pivottable points at. The original posting said

I like to keep the format of the Pivot Chart but want to change to a different Pivot table

 

[CuriousPivot]

thanks everyone for your reply, but I still don't have a solution yet. I just realized that I had a typo on my original post, i've corrected it and added my Excel version below:

after I created a Pivot Chart from a Pivot table, I like to keep the format of the Pivot Chart but want to change to a different Pivot table, how do I do that? I'm on Excel 2007 and this is what I tried: PivotChartTools - Design - Select Data, in the Select Data Source dialog box, Chart data range is gray out such that I can't enter a different Pivot table name.

thanks again!