VBA to change size of data labels?

  • Thread starter Thread starter Jason Weiss
  • Start date Start date
J

Jason Weiss

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
 
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
 
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
 
Chart area size vs. plot area size

You can also fix this issue sometimes by making your chart very wide and then making the plot area smaller. This will prevent many text labels from wrapping since the wrap is controlled by the text length and the width of the chart area.
 
Back
Top