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,

 

[flipside3420]

Were you ever able to get a solution to this? I've had a hard time sifting through answers on pivot tables as I merely want to avoid having to waste a lot of time reformatting another pivot chart to match the first. Sorry to post a question but haven't really found answers anywhere and this thread doesn't seem to have reached a resolution either (so why duplicate).

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!

 

[sijpie]

Have you then also got the problem that your option to change the source data is greyed out?
See these links, may be one of them is of use:
Select different source data for a PivotTable report - Support - Office.com (Excel 2007)
Change the source data for a PivotTable - Excel - Office.com (Excel 2010, 2013)
http://www.mrexcel.com/forum/excel-questions/16333-pivot-table-source-data-question.html (Macros)

 

[rcoutant]

You have to copy the chart to a new workbook, which converts it to a regular chart. Then if you paste it back into the original workbook you can change the data source.

Details here:
Excel Pivot Chart Change Source

 

[wtasha]

Here is my solution. Works for me most of the times. See if it can be any help.
1. Save a chart that you want to replicate as a chart template - PivotChart Tools -> Design -> 'Save As Template'.
2. Select 'PivotChart' in PivotTable Tools - > from Insert Chart window open 'Templates' folder -> select the template that you've just saved in step 1.
3. If you have headers that you need to update - take care of them by formula. All you'll need to do is to update a cell reference.

 

[impresxy]

You have to copy the chart to a new workbook, which converts it to a regular chart. Then if you paste it back into the original workbook you can change the data source.

Details here:
Excel Pivot Chart Change Source

Work great!!! Thanks

 

[Thakkarpranav]

Thanks. This works like a charm!

Here is my solution. Works for me most of the times. See if it can be any help.
1. Save a chart that you want to replicate as a chart template - PivotChart Tools -> Design -> 'Save As Template'.
2. Select 'PivotChart' in PivotTable Tools - > from Insert Chart window open 'Templates' folder -> select the template that you've just saved in step 1.
3. If you have headers that you need to update - take care of them by formula. All you'll need to do is to update a cell reference.