chart text position

[Guest]

Is there a way to set a text's position on a chart so that if the text is
referring to a cell the position of the text will always be aligned? I'm
running a macro thats linking text on a chart to a cell, and if the cell has
more or less characters the position of the text always changes. I would
like to left justify the text or something. I tried playing around with the
VBA code for this but it hasn't worked. Thanks.

 

[Guest]

aligned to what specifically? What can be used as an anchor point/reference
for the textbox?

 

[Guest]

Well I would like to allign a text box left justified with the top of the
y-axis.

 

[Guest]

OKAY I found the culprit

..AutoSize = True

This line needs to be .AutoSize = False

Now my boxes are alligned