| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart text position
Is there a way to add text to a chart that is left justified in a certain
position? I'm running a macro that creates charts and adds text that is referenced to a cell in a worksheet. The cell is different length for different worksheets so each time the text is added to the chart its position changes. I would to have the text start at a certain position that is left justified. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Chart text position
How are you adding the text? If it's a textbox you can set its.Left property
to a particular value. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Chris" wrote in message ... Is there a way to add text to a chart that is left justified in a certain position? I'm running a macro that creates charts and adds text that is referenced to a cell in a worksheet. The cell is different length for different worksheets so each time the text is added to the chart its position changes. I would to have the text start at a certain position that is left justified. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing text formats on a chart linked to a spreadsheet | Charts and Charting in Excel | |||
| text label in x-axis (scatter chart) | Charts and Charting in Excel | |||
| Scatter chart with text labels as Y axis? | Charts and Charting in Excel | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel | |||
Linear Mode
