View Single Post
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

Mark -

You could copy the original chart as a picture, and paste this into the
worksheet, then continue making changes in the original.

To copy a chart as a pictu Hold Shift while selecting the Edit menu,
then select Copy Picture. I prefer the On Screen (twice) and As Picture
options.

I also prefer working with regular charts. Pivot charts cause more work
for me with their strange behavior than they save me by pivoting.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Mark Allen wrote:

Can links between Excel 2003 Pivot Charts and their pivot table be turned off
or on? I am trying to show pivot charts for each page variable and if any
formating is changed in one of the charts they all revert back to the default
chart formatting.