for gif just change reference to .jpg to .gif
Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\a\MyChart.gif",FilterName:="GIF"
End Sub

"David McRitchie" wrote in message
...
ActiveChart.Export FileName:="D:\MyChart.jpg", FilterName:="JPEG"

also see Harold Staff's write up in
XL2GIF routine
ttp://www.mvps.org/dmcritchie/excel/xl2gif.htm
which places picture of a group of cells onto a graph so it can create
a .jpeg file.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"haisat" wrote
I am trying to plot a graph using Macro and could do that. But I have
to store that graph as a .jpg or .gif file. Is there any way i could do
that automatically(like macro)? Could anybody help me in doing this.