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?
> >
> >
>