Duplicating PivotChart / Changing PivotChart data range
 

I have a worksheet with a pivottable and an associated pivotchart, all
nicely formatted. I want to make a duplicate of this so I can
configure the data selection differently, but still retain the
formatting. In Excel 2003, I just duplicated the worksheet and the new
pivotchart would be associated with the new pivottable. In Excel
2007, I find the new pivotchart is *still* tied back to the original
pivottable. Is there a way around this?

If I select the PivotChart Tools, I see 'Select Data', but the section
for "Chart data range" is grayed out and will not allow edits. I
thought I was good at this stuff, but I guess not! Any help is
greatly appreciated!

Thank you .