How can I export an excel 2003 chart to a .jpg?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find a way to export an excel chart directly to a .jpg image
for upload. I know many work arounds, but seek a simple answer for an
end-user.

The closest solutions I have found are "Save As Webpage", which results in a
..gif, and "Send to Mail recipient" which results in a .bmp

Any suggestions?
 
Hi,

You can use the export method of a chart. Change the folder location to
suit.
Activechart.export "c:\temp\mychart.jpg"

Cheers
Andy
 
I suggest you export as GIF or PNG rather than JPG. JPG is designed for
photographic images, with gradual changes in color, while GIF and PNG
are good for bitmapped representations of drawn objects, with discrete
constant colors and sharp transitions between adjacent colored regions.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
I agree, but the webapp (not my fault) only accepts jpg. I'm working on
getting that silly limitation changed to.
 
Back
Top