ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   xy chart labeler, label length (https://www.excelbanter.com/charts-charting-excel/45115-xy-chart-labeler-label-length.html)

[email protected]

xy chart labeler, label length
 
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/
_______


wrote:

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



All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com