Copy Charts

[archsmooth]

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.

 

[Jon Peltier]

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

 

[archsmooth]

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.

 

[archsmooth]

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
chart as an object onto another Excel sheet with cells, but take the whole
worksheet as is.

 

[Jon Peltier]

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

 

[Martin Ko]

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.