Ballooning Excel charts

[RobBroekhuis]

I apologize for the crosspost - I know some of you are more active in here than in the Office forum, where I haven't gotten a reply. My excuse is that the charts got generated using VBA

I frequently compose email messages with embedded charts from Excel. My modus operandi has always been to create the chart in Excel (on a chart sheet), selecting and copying the chart, and then in Outlook doing a "Paste Special" into a message, choosing Windows Metafile as the format. The resulting message would take up perhaps 30kb.
My company recently switched to Office 2007. Now when I do the same thing, the message balloons to 1MB. Trying all the other options in the Paste Special menu results in the same or even larger sizes. I can't find a way to reduce the size of the embedded object. Any ideas?

Rob

 

[electricpete]

Maybe try exporting chart as png file. See Peltier's advice:

http://peltiertech.com/WordPress/2008/06/05/export-chart-as-image-file/

 

[RobBroekhuis]

Well wouldn't you know, the fix was easy, if non-intuitive (arrived at entirely by trial and error): composing the message in Outlook in HTML format instead of in rich text format preserves the small size of the image. It appears that regardless of the native format, when pasting into a rich text message Outlook transforms the image into its own bloated format.

Rob