Actually, you could try this little utility to change the sheet names in a
chart's series formulas. I haven't used it much for sheet names, but in
principle it should work.

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

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


"Jon Peltier" wrote in message news:...
No. If there were an easier way, I would have shared it.

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


"Rick J" wrote in message
...
I am also trying to do the same thing. I have about 50 worksheets -
making
a copy of the one sheet that has the graph then copying and pasting the
entire contents of each of the other 49 sheets, then renaming the sheet
after it is pasted is a lot of work. Is there not some other simple way
to
make the graph series definitions "relative" such that pasting the plot
on
each sheet references the same cells but on the new sheet?

Thanks,
Rick


"Jon Peltier" wrote in message
...
| Here's an easy way to get what you want.
|
| 1. Copy the whole worksheet that the chart is embedded in.
| 2. Copy the new data you want in the copied chart.
| 3. Select the data range of the copied sheet.
| 4. Use Paste Special - Formulas or Values to put the desired data in
the
| chart's source data range.
|
| - Jon
| -------
| Jon Peltier, Microsoft Excel MVP
| Tutorials and Custom Solutions
| http://PeltierTech.com
| _______
|
|
| "Excelfool" wrote in message
| ...
| I want to paste an Excel chart from worksheet 1 to worksheet 2 and for
the
| newly pasted chart in sheet 2 to reference the sourse data as
worksheet
2
| not
| its original data from sheet 1.
|
|