PDA

View Full Version : Solved: How to add textbox to a chart on a worksheet?



agarwaldvk
02-20-2009, 12:32 AM
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
02-20-2009, 02:42 AM
activechart.Shapes.AddTextbox(msoTextOrientationHorizontal,1,1,100,20).Text Frame.Characters.Text = "Hello World"

agarwaldvk
02-20-2009, 03:06 PM
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