| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Label Widths
Can data label widths be changed using VBA
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data Label Widths
Hi,
No, the width and height properties are not available to chart text items, such as chart title, axis titles and data labels. The only way to increase the dimensions is with padding characters, even then the text may automatically decide to wrap. If you need full control over chart text items then use need to use textboxes. Of course this will not be as dynamic as the built-in text items so may require code to update their positions. Cheers Andy On 17/02/2010 06:22, Adrian wrote: Can data label widths be changed using VBA -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide the data label for a data table in a chart | Charts and Charting in Excel | |||
| Shortcut to change view so that column widths are all wide enough to show all data? | Excel Discussion (Misc queries) | |||
| Locking column widths & importing data in Excel 2003 | Excel Discussion (Misc queries) | |||
| Possible to change chart title and label box widths? | Charts and Charting in Excel | |||
| How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
Linear Mode
