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.

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
_______


"archsmooth" <(E-Mail Removed)> wrote in message
news:63931170-CF34-4DAD-B603-(E-Mail Removed)...
>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.

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" wrote:

> 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
> _______
>
>
> "archsmooth" <(E-Mail Removed)> wrote in message
> news:63931170-CF34-4DAD-B603-(E-Mail Removed)...
> >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.
>
>
>

Got it. Found the 'Break Links' function.

"archsmooth" wrote:

> 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" wrote:
>
> > 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
> > _______
> >
> >
> > "archsmooth" <(E-Mail Removed)> wrote in message
> > news:63931170-CF34-4DAD-B603-(E-Mail Removed)...
> > >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.
> >
> >
> >

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
_______


"archsmooth" <(E-Mail Removed)> wrote in message
news:9BE88668-BBF3-49C3-8CA0-(E-Mail Removed)...
> 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" wrote:
>
>> 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
>> _______
>>
>>
>> "archsmooth" <(E-Mail Removed)> wrote in message
>> news:63931170-CF34-4DAD-B603-(E-Mail Removed)...
>> >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.
>>
>>
>>

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.

"archsmooth" wrote:

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