If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data Label Widths
Can data label widths be changed using VBA
|
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|