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" <[email protected]> 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" <[email protected]> wrote in message
> news:[email protected]...
>>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" <[email protected]> wrote in message
>> news:%[email protected]...
>> | 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" <[email protected]> wrote in message
>> | news:[email protected]...
>> | >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.
>> |
>> |
>>
>>

>
>