chart text position
 

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.

chart text position
 

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

--
Regards,
Tom Ogilvy


"Chris" wrote:

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.

chart text position
 

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


"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"Chris" wrote:

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.

chart text position
 

OKAY I found the culprit

..AutoSize = True

This line needs to be .AutoSize = False

Now my boxes are alligned

"Chris" wrote:

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.