Solved: How to add textbox to a chart on a worksheet?

[agarwaldvk]

Hi Everybody

How do I add a textbox to a chart on a worksheet?

Not sure whether it is supposed to be a shape/shaperange etc. Can't get my head around adding a textbox on a chart. I can add a text anywhere on the worksheet but how would I do it on a chart - I am lost!!!!!!!!!

Any help would be highly appreciated.


Best regards


Deepak Agarwal

[Andy Pope]

activechart.Shapes.AddTextbox(msoTextOrientationHorizontal,1,1,100,20).TextFrame.Characters.Text = "Hello World"

[agarwaldvk]

Andy

Thanks a lot!

I didn't know it was this simple! Sometimes, it is the easier of the things that stumble you!.

Gee, I wish I had asked before - I tried practically all that I thought could work and wasted so much of time but obviously I was doing the wrong thing! Greatly appreciated.


Best regards


Deepak