Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text position in charts
Is there a way to set chart text to an absolute position on a chart? I have
text pointing to a cell (which is different length for each spreadsheet) and when I run a macro the text box that gets created is in a different position each time. Is it possible to left justify the text in VBA? I tried changing Increment to Absolute but that didn't work in this code: Selection.ShapeRange.IncrementLeft 255.34 Selection.ShapeRange.IncrementTop -206.95 Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
text position in charts
I thought this was answered in another thread:
selection.shaperange.top=10 selection.shaperange.left=15 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Chris" wrote in message ... Is there a way to set chart text to an absolute position on a chart? I have text pointing to a cell (which is different length for each spreadsheet) and when I run a macro the text box that gets created is in a different position each time. Is it possible to left justify the text in VBA? I tried changing Increment to Absolute but that didn't work in this code: Selection.ShapeRange.IncrementLeft 255.34 Selection.ShapeRange.IncrementTop -206.95 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to show multiple charts in one position, but determine by Lis | Charts and Charting in Excel | |||
2007: weird position of labels on 3D bar charts | Excel Programming | |||
How to apply / position labels for a collection of charts | Charts and Charting in Excel | |||
Bar charts with negative values and label position | Charts and Charting in Excel | |||
Size & Position charts on Sheet | Excel Programming |