xy chart labeler, label length

[raoulreulen]

Hi,

I am using this wonderful tool called "xy chart labeler". However, I
would like to increase the length of the labels that I have defined. Is
this possible? Unfortunately, I cannot make the textbox larger that
contains the label.


Thanks.

Raoul

 

[Jon Peltier]

Those data labels are not true textboxes (nor are chart and axis
titles). You cannot resize them aside from changing the font size, and
only Excel decides where to wrap the lines.

The workaround is to use real textboxes instead of data labels.
Unfortunately these are not integrated into a chart as smoothly as a
data label, and a textbox may decide to take a stroll around the chart,
instead of staying where you put it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______