Thaks for the help
Luca
The easiest would be to add an empty chart-object in your worksheet (press
finish to the chart wizard without any range selection); format the chart
area to transparent or whatever; copy-paste the shape in to the
chart object; export the chart object.
Excel has some built in filters to do that, like:
-------------------------------------------------
Sub expchart()
ActiveChart.Export FileName:="D:\MyChart.gif", FilterName:="GIF"
ActiveChart.Export FileName:="D:\MyChart.jpg", FilterName:="JPEG"
ActiveChart.Export FileName:="D:\MyChart.png", FilterName:="PNG"
End Sub
--------------------------------------------------
HTH
Stratos