VBA to change size of data labels?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason Weiss - 23 Mar 2005 17:50 GMT

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

Reply to this Message

Andy Pope - 23 Mar 2005 21:41 GMT

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

> Hi,
>
[quoted text clipped - 8 lines]
>
> ...Jay

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Jason Weiss - 24 Mar 2005 21:24 GMT

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 to this Message