I am having difficulty exporting charts to .gif files using the export method. The charts look great in Excel, but the resulting .gif files are often missing lines or axes or have other strange problems. Has anyone experienced this and know how to improve things? I am using Excel 2002.

Malone

Are you using this? You can also try changing gif to jpg and try that.

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

--
Don Guillett
SalesAid Software

"Malone" wrote in message
...
I am having difficulty exporting charts to .gif files using the export
method. The charts look great in Excel, but the resulting .gif files are
often missing lines or axes or have other strange problems. Has anyone
experienced this and know how to improve things? I am using Excel 2002.

Malone

Yes, that is exactly what I am using. And I don't want to use jpg as the image isn't as good as gif for the sort of charts I am using.

"Don Guillett" wrote in message ...
Are you using this? You can also try changing gif to jpg and try that.

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

--
Don Guillett
SalesAid Software

"Malone" wrote in message
...
I am having difficulty exporting charts to .gif files using the export
method. The charts look great in Excel, but the resulting .gif files are
often missing lines or axes or have other strange problems. Has anyone
experienced this and know how to improve things? I am using Excel 2002.

Malone