Text Boxes in Excel Charts

[comcon]

Is there any way in VBA to insert text boxes at selected
points in a chart?

 

[jebry]

Hi!

If your use the text box from the drawing toolbar, you can put it where ever you want. If you put it on a chart, it will move and size with the chart.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[comcon]

Jeff,

Is there a way we can create the text box in a VBA macro and put it onto the chart using the program?
I would like to insert the text boxes automatically, instead of having to do them manually.

Thanks

 

[wowski]

If you haven't found out by now try using
ActiveChart.Shapes.AddLabel

This seems to use a different set of co-ordinate system than that used by the chart. Don't ask me why, it's a real pain.