Exporting graphs from Excel

J

Jon Peltier

Dave -

This line of VBA does it:
ActiveChart.Export "C:\TEMP\TestChart.tif", "TIFF"

On my system I can also export using "GIF" and "PNG" formats, but it
choked on "BMP". "JPG" is also supported, but I advise anyone not to
use this, because it's only good for pictures with continuously shaded
regions, like photos and paintings. "GIF" is good for line drawings and
pictures with sharp color transitions.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top