Specify the top property of a text box added to a chart.
Posted on 2011-09-23
Below code adds a textbox to the active chart.
activechart.Shapes.AddTextbox(msoTextOrientationHorizontal, 20, 120, 100 ,20).TextFrame.Characters.Text = "Hello"
'1. Value = Left property of textbox = 20 points
'2. Value = Top property of textbox = 120 points
I wonder whether it is possible to specify the ...
Top property of the textbox relative to the Height property of the active chart.
For example: I do not want to specify the Top Property as 120 points but as being 90% percent of the Height property of the active chart.
Is this possible?
Help is much appreciated. Thank you very much in advance.