export method not working properly

  • Thread starter Thread starter Malone
  • Start date Start date
M

Malone

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
(e-mail address removed)
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Chart as TIFF or JPG 8
Best format to export Excel Range to picture?? WMF?? 5
Export Pie Graph Chart as Image 7
Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; 5
Programatically Export Excel Chart to Graphic in SharePoint 5
exporting image from sheet 1
Chart Export Issues 2
[Excel 2003] Exporting Diagram as Bitmap with VBA 2

Back
Top