How can I save an excel chart in gif format?

Dom · May 30, 2005

I want to create charts in excel and the display them on a web site. How can
I save an excel chart in gif format?

Than ks, Dom

Debra Dalgleish · May 30, 2005

Andy Pope has a free add-in that you can use to export images or charts:

http://www.andypope.info/vba/gex.htm

Don Guillett · May 31, 2005

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