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 .