Paste chart as jpeg/png into powerpoint

**rishadjb** · 06-30-2011, 10:50 AM

I am trying to paste a chart from my excel file to a ppt as a jpeg or png. I have the code to paste it as an object:

to copy

Please Login or Register  to view this content.

to paste

Please Login or Register  to view this content.

How can I modify this to paste it as jpeg? I have tried recording a macro but it stops recording once I shift to the ppt window. Couldn't find anything on google.

Thanks for your help.

**Andy Pope** · 07-01-2011, 04:04 AM

Please Login or Register  to view this content.

**rishadjb** · 07-01-2011, 11:57 AM

Yeah I tried that but kept giving me the same error. I found the solution however for whoever is interested. The problem is not in the paste command but in the copy command. When I copy it as a picture using "ActiveChart.CopyPicture" it can only be pasted as a metafile.

To paste it as a jpeg or oleobject etc, it needs to copied as:

ActiveChart.ChartArea.Copy

Then the jpeg command you provided can be used without error.

**ffa** · 10-18-2013, 08:43 AM

This maybe quick and dirty but it works in Powerpoint 2013:

'Sub to convert chart in Excel and paste into powerpoint:

Please Login or Register  to view this content.

Best Fredrik

**arlu1201** · 10-18-2013, 09:09 AM

ffa,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.