Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
chart text position
Those pesky recorded macros only do what you did, not what you wanted to do.
Try Selection.ShapeRange.Left = 36 Selection.ShapeRange.Top = 24 or ActiveChart.Shapes("TextBox 1").Left = 36 etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Chris" wrote in message ... Is there a way to set a text box to an absolute position on a chart? I'm using a macro to create charts for me and I assigned text boxes to certain locations on the chart. The only thing is, the text boxes don't stay on the same spot if I use the following code because each text box is of different length. Selection.ShapeRange.IncrementLeft -275.52 Selection.ShapeRange.IncrementTop -188.95 If I run the macro on one worksheet, the text lines up perfectly. It doesn't line up perfectly on a different worksheet since the text inside the text box refers to a cell that is of different character length for each sheet. |
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) | |||
???How to set chart position | Excel Programming | |||
Changing chart title changes position of chart | Excel Programming |