Paste charts to reference new worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Copy the sheet with the data and the chart, then change the data on the
copied sheet.

- Jon
 
Copy the sheet with the data and the chart, then change the data on the
copied sheet.
Click to expand...

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.
 
Back
Top