One way
Sub ExportChartJPG()
ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
FilterName:="jpeg"
End Sub

--
Don Guillett
SalesAid Software

"Stevie D" wrote in message
...
Hi I have two related questions,

1) Is it possible to select an excel chart and save it as a separate
object
that is that independent of the workbook it was created in?

2) Assuming this can be done - can I use VBA to overwrite this file when
the
underlying data source changes?

Thanks,

Steve