Duplicating Pivot Chart / Changing Pivot Chart data range

[BillG]

I have a worksheet with a pivot table and an associated pivot chart,
all
nicely formatted. I want to make a duplicate of this so I can
configure the data selection differently (this goes out to a group of
users who aren't so good at doing more than basic manipulation of the
pivot table), but still retain the
formatting and structure. In Excel 2003, I just duplicated the
worksheet and the new
pivot chart would be associated with the new pivot table. In Excel
2007, I find the new pivot chart is *still* tied back to the original
pivot table. Is there a way around this?

If I select the Pivot Chart Tools, I see 'Select Data', but the
section
for "Chart data range" is grayed out and will not allow edits. Any
help is
greatly appreciated.

Thank you .

 

[Shane Devenshire]

Hi,

Select the chart and press Alt D P you will find yourself in the 2003 pivot
table wizard, click the Back button and specify a new range.

 

[Herbert Seidenberg]

Excel 2007
If you are using a Table, the renaming sequence is critical:
http://www.mediafire.com/file/jz5znjznluz/02_09_09.xlsm

 

[BillG]

Hi,

Select the chart and press Alt D P you will find yourself in the 2003 pivot
table wizard, click the Back button and specify a new range.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

Thanks! I think I can make this work. It is a bit round about as it
creates a new pivot table to which the chart is now linked, but that
is fine. Thank you!!

 

[sarah hylton]

I found the same problem - that I could not just copy the entire Excel sheet and rename the data source. But all you have to do is create a new chart, select your old chart and COPY, then select your new chart and PASTE (I use control C and control V). This pastes all the formatting from one chart to another! (wish I'd found this 2 months ago!)



BillG wrote:

Re: Duplicating Pivot Chart / Changing Pivot Chart data range
10-Feb-09

o

Thanks! I think I can make this work. It is a bit round about as i
creates a new pivot table to which the chart is now linked, but tha
is fine. Thank you!!

Previous Posts In This Thread:

Hi,Select the chart and press Alt D P you will find yourself in the 2003 pivot
Hi

Select the chart and press Alt D P you will find yourself in the 2003 pivot
table wizard, click the Back button and specify a new range

--
If this helps, please click the Yes butto

Cheers
Shane Devenshir

:

Duplicating Pivot Chart / Changing Pivot Chart data range
I have a worksheet with a pivot table and an associated pivot chart
al
nicely formatted. I want to make a duplicate of this so I ca
configure the data selection differently (this goes out to a group o
users who aren't so good at doing more than basic manipulation of th
pivot table), but still retain th
formatting and structure. In Excel 2003, I just duplicated th
worksheet and the ne
pivot chart would be associated with the new pivot table. In Exce
2007, I find the new pivot chart is *still* tied back to the origina
pivot table. Is there a way around this

If I select the Pivot Chart Tools, I see 'Select Data', but th
sectio
for "Chart data range" is grayed out and will not allow edits. An
help i
greatly appreciated

Thank you .

Excel 2007If you are using a Table, the renaming sequence is
Excel 200
If you are using a Table, the renaming sequence is critical
http://www.mediafire.com/file/jz5znjznluz/02_09_09.xlsm

Re: Duplicating Pivot Chart / Changing Pivot Chart data range
o

Thanks! I think I can make this work. It is a bit round about as i
creates a new pivot table to which the chart is now linked, but tha
is fine. Thank you!!


Submitted via EggHeadCafe - Software Developer Portal of Choice
EggHeadCafe Chat Chaos in Silverlight Released Today
http://www.eggheadcafe.com/tutorial...6-54f31bdede5d/eggheadcafe-chat-chaos-in.aspx