Paste charts to reference new worksheet

[hmm]

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?

 

[Jon Peltier]

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

- Jon

 

[Alice]

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.