Saving Charts

[Diane S.]

We are currently saving charts as WMFs using an Excel add-in that was
developed for us. The pies are coming out pretty jagged, though, so we're
looking at other file type options, from both Excel 2003 and Excel 2007. Can
someone tell me what the options are? Can Excel charts be exported as jpeg,
png or gif?

 

[Andy Pope]

Hi,

Yes, assuming you have the graphics filters installed.

Activechart.Export <filename> <filtertype>

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

Cheers
Andy

 

[Jon Peltier]

And stick to the PNG format.

- Jon

 

[Diane S.]

Thanks. I'll check that out.

Wish Brian R. was still here to help with this.

 

[Jon Peltier]

Yeah, we all miss him.

- Jon