Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VBA to change size of data labels?
Hi,
I have a chart with text that is too long for the data labels. Looking around online, I see that the data labels cannot be resized manually, and a common recommendation is to replace them with text boxes. I understand this, but isn't there any way to directly control the width of the data labels in VBA? I am reasonably proficient at VBA both on its own and within Excel, and I won't mind if the solution includes some heavy-duty coding. Thanks to anyone who can help... ....Jay |
#2
|
|||
|
|||
Hi,
The data labels have no width or height properties, so VBA code will not do it either. The dimensions of the data label are based on text content and font size. You can changes these but not control the consequences. The only realistic approach to fully controlled data labels is to use textboxes. Cheers Andy Jason Weiss wrote: Hi, I have a chart with text that is too long for the data labels. Looking around online, I see that the data labels cannot be resized manually, and a common recommendation is to replace them with text boxes. I understand this, but isn't there any way to directly control the width of the data labels in VBA? I am reasonably proficient at VBA both on its own and within Excel, and I won't mind if the solution includes some heavy-duty coding. Thanks to anyone who can help... ...Jay -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Andy,
Wow, I had no idea... I thought it would just be a heavy-duty romp through the object model. Well... This changes my approach. Thanks for your quick and authoritative response! ....Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data File to Word Labels | Excel Discussion (Misc queries) | |||
how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
How to change cell data from all upper to title case | Excel Discussion (Misc queries) |