| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to change position of chart labels on line chart | Charts and Charting in Excel | |||
| text position on a chart | Excel Discussion (Misc queries) | |||
| Chart text position | Excel Discussion (Misc queries) | |||
| chart text position | Excel Programming | |||
| Changing chart title changes position of chart | Excel Programming | |||
Linear Mode
