Hi

Is there a way to copy a chart, and then paste (special) it as a
picture back into Excel. It always pastes it back as a chart.

Currently I can copy an excel chart and paste it into Word as a
picture, then I copy it back out of Word and into Excel again. I want
to do it as a single step.

Perfectly acceptable alternate option would be knowing how to export a
chart to file as a picture, and then my code could read that pic back
in.

Thanks in advance
Andy C

Try this

Tim

'**************
ActiveSheet.ChartObjects("Chart 1").Chart.CopyPicture _
Appearance:=xlPrinter, Size:=xlScreen, Format:=xlPicture

ActiveSheet.Range("E27").Select
ActiveSheet.Paste




"AC" <(E-Mail Removed)> wrote in message
news:f0f6f378-d109-423e-ac4b-(E-Mail Removed)...
> Hi
>
> Is there a way to copy a chart, and then paste (special) it as a
> picture back into Excel. It always pastes it back as a chart.
>
> Currently I can copy an excel chart and paste it into Word as a
> picture, then I copy it back out of Word and into Excel again. I want
> to do it as a single step.
>
> Perfectly acceptable alternate option would be knowing how to export a
> chart to file as a picture, and then my code could read that pic back
> in.
>
> Thanks in advance
> Andy C

Hi,

Select the chart
Hold down the Shift key and choose Edit, Copy Picture...
A simple paste will do the trick at that point.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"AC" wrote:

> Hi
>
> Is there a way to copy a chart, and then paste (special) it as a
> picture back into Excel. It always pastes it back as a chart.
>
> Currently I can copy an excel chart and paste it into Word as a
> picture, then I copy it back out of Word and into Excel again. I want
> to do it as a single step.
>
> Perfectly acceptable alternate option would be knowing how to export a
> chart to file as a picture, and then my code could read that pic back
> in.
>
> Thanks in advance
> Andy C
>

You could try using the camera tool.

http://www.processtrends.com/pg_charts_camera_tool.htm


"AC" wrote:

> Hi
>
> Is there a way to copy a chart, and then paste (special) it as a
> picture back into Excel. It always pastes it back as a chart.
>
> Currently I can copy an excel chart and paste it into Word as a
> picture, then I copy it back out of Word and into Excel again. I want
> to do it as a single step.
>
> Perfectly acceptable alternate option would be knowing how to export a
> chart to file as a picture, and then my code could read that pic back
> in.
>
> Thanks in advance
> Andy C
>