Is there a way of converting a lone excel graph into a JPEG

[Guest]

Is there a way to convert an excel graph into into a JPEG file

 

[Andy Pope]

Hi,

The chart has an export method you can use from VBA

ActiveChart.Export "C:\temp\mychart.jpg", "jpg"


Cheers
Andy

 

[Don Guillett]

Essentially the same thing. Change to suit

Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\a\MyChart.gif", _
FilterName:="GIF"
End Sub
Sub ExportChartJPG()
ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
FilterName:="jpeg"
End Sub

 

[Bernard Liengme]

Also, if you have a graphics program like PaintShopPro, you can copy chart
to it and use Save As

best wishes

 

[Jon Peltier]

Matthew -

Using Andy's or Don's suggestions, export the chart as a GIF, not a JPEG. GIFs are
better suited to drawing object like charts, while JPEGs are better suited to
photographic images. PNGs are also good for charts, if that filter is available on
your computer.

Using Bernard's suggestion, save the final image as GIF or PNG.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______