Thanks John - Rick
| 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
| _______
|
|
| | >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
| >
| >
| > | > | 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
| > | _______
| > |
| > |
| > | | > | >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.
| > |
| > |
| >
| >
|
|
