You can use code similar to the following:
ActiveChart.Export Filename:="C:\Data\Chartpic.jpg", _
FilterName:="jpeg"
hke wrote:
With the j-walk charting tool I can for example export a chart in jpg
format - but can this operation be done by a macro? if so how?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html