Pivot chart - how to change data source

CuriousPivot

New Member
Joined
Jul 21, 2011
Messages
3
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,
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
Right click in your Pivot Table and select 'PivotChart Wizard'

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

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,523
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?
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,523

ADVERTISEMENT

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

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,073
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

If you have a solution, please post it openly.
 

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
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

Well-known Member
Joined
Jul 8, 2002
Messages
11,523
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

New Member
Joined
Jul 21, 2011
Messages
3
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,632
Messages
5,597,287
Members
414,134
Latest member
Tiyas44

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top