Saving a chart as a gif

How can I save a chart in a worksheet as a gif which I can later use in a
web page?

Thanks, CMA

Hi,

You can export the chart via vba code.
Activechart.export "C:\mychart.gif"

Cheers
Andy

cmar wrote:
> How can I save a chart in a worksheet as a gif which I can later use in a
> web page?
>
> Thanks, CMA
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

John Walkenbach's Chart Tools add-in (free at http://j-walk.com) has
this utility built in, so someone needn't dive into VBA to get this
functionality.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Andy Pope wrote:
> Hi,
>
> You can export the chart via vba code.
> Activechart.export "C:\mychart.gif"
>
> Cheers
> Andy
>
> cmar wrote:
>
>> How can I save a chart in a worksheet as a gif which I can later use
>> in a web page?
>>
>> Thanks, CMA
>>
>