Paste charts to reference new worksheet
 

When I copy and paste a chart between worksheets, the new chart plots the
data series from the old sheet. I want it to plot the values from the new
sheet (of cells with the same references). How do I do it?

Paste charts to reference new worksheet
 

Copy the sheet with the data and the chart, then change the data on the
copied sheet.

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


"hmm" wrote in message
...
When I copy and paste a chart between worksheets, the new chart plots the
data series from the old sheet. I want it to plot the values from the new
sheet (of cells with the same references). How do I do it?

Paste charts to reference new worksheet
 

Copy the sheet with the data and the chart, then change the data on the
copied sheet.

No, that does not work in Excel 2007! It did in 2003... It's probably a bug.
Very frustrating, since I need to manually update hundreds of data series now.