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

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

Jason Krause wrote:
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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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/
_______


Andy Pope wrote:

Hi,

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

Cheers
Andy

Jason Krause wrote:

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?

I agree, but the webapp (not my fault) only accepts jpg. I'm working on
getting that silly limitation changed to.

"Jon Peltier" wrote:

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/
_______


Andy Pope wrote:

Hi,

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

Cheers
Andy

Jason Krause wrote:

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?