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.

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.

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.

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.