Copy the entire sheet, with the data and chart, so you have a duplicate
sheet with a chart that refers to the data on this duplicate sheet. Now
copy the new data, and paste it on top of the original data.

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

phnar wrote:

Hello, I have a graph on sheet1 that instances several sheet1 series. I want
to copy and paste that graph onto sheet 2, and have it instance the same
cells, except in sheet 2. I need to do this for quite a few sheets. Is there
a way I can have Excel automatically pick the corresponding sheet and fill in
the appropriate graph arguement?

Cheers