If you save the file as a web page, the graph will automatically be
saved as a .gif.

For instance, if you save the one-sheet workbook foo.xls as a web
page, the graph will be saved in the foo_files directory (which is
at the same level as foo.htm) as image001.gif.


In article ,
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.