Hi,

I want to paste a Chart embedded in a worksheet in to powerpoint but I want
to have the ability to edit the chart in powerpoint. (Code will reside in
Excel)
Without any hesitation I stole from Jon P's site on how to effect the
transfer.
Just one problem. His link --
http://peltiertech.com/Excel/XL_PPT.html#chartppt -- prefers pasting the
chart as a picture while I want to be able to edit it within Powerpoint

So I replaced the following line in his code
ActiveChart.CopyPicture Appearance:=xlScreen, Size:=xlScreen, _
Format:=xlPicture

with this one
ActiveChart.ChartArea.Copy

Then I ran the code and wow I was able to get what I wanted...

Is there any other way to do it.? (why I want to know is that I got the
above after a lot of hit and trial, hence wanted to know other ways of
achieving the same result. That way, in case the starting conditions are
different I would be able to use a different method)

Thanks a lot,
Hari
India