.gif Excel charts 1

[segmentationfault]

Is it possible to get Excel to create .gifs of charts without Saving as HTML, reading the HTML for the image source, and grabbing the referenced gif? I would simply like to indicate which chart, what filename, and what location, and end up with the gif.

I asked this question last week and got no response, but it would still be quite valuable to find an answer.

 

[Guest_imported]

I'm working on the same thing
So far I can't name it, but if you have a pre-existing chart, you can cut it, then insert it as an object (bmp).
After that, you can cut it again and paste as .gif, .jpg and so on.
It's a long way around I'm sure, but wateva it takes!

Let me know if you find a way to name it .

 

[acron]

The following routine should save the active chart as a Gif image.

Sub ActiveChartToGif()
ActiveChart.Export Filename:="ChartX.Gif", FilterName:="Gif"
End Sub


A.C.

 

[segmentationfault]

Ah, thanks acron. Exactly what I was looking for. I'm completely uninitiated with regards to chart objects. I haven't tested it yet, but will be sure to complain if it doesn't work.