Paste a chart and get the source data to be from the new worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Excelfool - 26 Jul 2006 13:31 GMT

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.

Reply to this Message

Jon Peltier - 26 Jul 2006 19:43 GMT

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.

Reply to this Message

Rick J - 03 Aug 2006 18:05 GMT

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.
|
[quoted text clipped - 15 lines]
| > not
| > its original data from sheet 1.

Reply to this Message

Jon Peltier - 04 Aug 2006 16:24 GMT

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
[quoted text clipped - 29 lines]
> | > not
> | > its original data from sheet 1.

Reply to this Message

Rick J - 11 Aug 2006 04:08 GMT

Thanks John - Rick

| No. If there were an easier way, I would have shared it.
|
[quoted text clipped - 38 lines]
| > | > not
| > | > its original data from sheet 1.

Reply to this Message

Jon Peltier - 04 Aug 2006 16:36 GMT

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" <jonxlmvpNO@SPAMpeltiertech.com> wrote in message news:...

> No. If there were an easier way, I would have shared it.
>
[quoted text clipped - 41 lines]
>> | > not
>> | > its original data from sheet 1.

Reply to this Message

Rothman - 25 Aug 2006 17:06 GMT

This thread depresses me.

I have a file which has 100+ sheets in it, with each sheet named after a
date and filled with all sorts of data. A new chart per sheet has been
requested and it would be great to be able to remove the sheet name and have
the source data be relative and just copy and paste the chart 100+ times
across the sheets.

It seems I'm going to have to actually create a chart 100+ times, which
stinks.

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

Reply to this Message