VBA paste charts to Powerpoint

This website has a lot of info about this:

http://peltiertech.com/Excel/XL_PPT.html

Post back if you have any trouble implementing the info there.

I didn't even know Jon had put together such a comprehensive tutorial on the subject. Nifty.

Rick, in my experience I've had better luck pasting pictures of charts rather than actual charts. Pity, because it makes more sense to link them so that your chart is always up to date with any changes in the data. The correct sizing takes a bit of tweaking. I only skimmed Jon's examples but I saw one where you can input scaling factors. You might want to do that at first and check how different factors look. And once you get it about right, then hardcode in the scaling factors you found optimal.

I've been looking for this answer as well. So thanks for the post.

Thanks everyone. I've visited Peltier's site many times, never noticed this section either, looks very comprehensive. It'll take me a bit to decipher and try it out. I may be back with more quesions.

Rick