Copy Charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

archsmooth - 18 Sep 2007 17:24 GMT

I know this is simple, but I cannot remember how. I want to copy a chart into
another worksheet, but do not want to keep the links, just the picture and
data as it is.

Reply to this Message

Jon Peltier - 18 Sep 2007 17:39 GMT

Select the chart, hold Shift while clicking on the Edit menu, choose Copy
Picture, and use the On Screen and Picture options. Go to the place you want
the chart image to appear, and use plain old Paste (Ctrl+V).

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

>I know this is simple, but I cannot remember how. I want to copy a chart
>into
> another worksheet, but do not want to keep the links, just the picture and
> data as it is.

Reply to this Message

archsmooth - 18 Sep 2007 18:00 GMT

Useful, but not what I am trying to do. The chart is its own worksheet. I
need to keep it that way, just without formulas. I do not want to copy the
chart as an object onto another Excel sheet with cells, but take the whole
worksheet as is.

> Select the chart, hold Shift while clicking on the Edit menu, choose Copy
> Picture, and use the On Screen and Picture options. Go to the place you want
[quoted text clipped - 11 lines]
> > another worksheet, but do not want to keep the links, just the picture and
> > data as it is.

Reply to this Message

archsmooth - 18 Sep 2007 19:12 GMT

Got it. Found the 'Break Links' function.

> Useful, but not what I am trying to do. The chart is its own worksheet. I
> need to keep it that way, just without formulas. I do not want to copy the
[quoted text clipped - 16 lines]
> > > another worksheet, but do not want to keep the links, just the picture and
> > > data as it is.

Reply to this Message

Jon Peltier - 18 Sep 2007 19:27 GMT

A point of terminology. A worksheet is an Excel sheet that has cells, rows,
columns, data. It may contain embedded objects, including charts. When an
excel chart on its own tab, and the tab is not a worksheet, it is called a
chart sheet.

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

> Useful, but not what I am trying to do. The chart is its own worksheet. I
> need to keep it that way, just without formulas. I do not want to copy the
[quoted text clipped - 18 lines]
>> > and
>> > data as it is.

Reply to this Message

Martin Ko - 04 Dec 2007 15:07 GMT

I have the same problem as well when I tried to copy a single worksheet which
contains a chart or copy a worksheet and a chart as a group using the Ctrl
key.

I came up with this error when I use Scatter Chart, I haven't actually tried
others yet. But here are some findings.

1) This error occurs always occurs if the chart is a separate sheet.
2) This error occurs if there are more than one series.
3) This error does Not occurs when there is only one series and the chart is
an object of the referenced worksheet

I hope this error can be solved as I urgently need to process quite a lot of
data with it.

> I know this is simple, but I cannot remember how. I want to copy a chart into
> another worksheet, but do not want to keep the links, just the picture and
> data as it is.

Reply to this Message