export excel chart to gif

[jaol]

Hi,

I have an excel-chart with a textbox on. When I export this chart to a gif-file using
ActiveSheet.ChartObjects("Chart 1").Chart.Export filename:="XX.gif", Filtername:="Gif"
the textbox is missing on the gif-file.

Grouping chart and textbox is not the sollution. Can anyone helt me?

 

[AndyPope]

Hi jaol,

This should work IF the textbox is actually an object within the chart.
To check this try dragging the textbox away from the chart.
If it is not bound within the chart then it will not be exported with it.
To make the textbox part of the chartobject, select the textbox and press CTRL+X. Now select the chart and press CTRL+V. reposition the textbox to suit.
Hopefully the export should now include the textbox.

Cheers
Andy

 

[jaol]

Hi Andy,

Thanks a lot for your help, now it is working fine.

Cheers
Janne