Data Labels Widths

[Mike Bishop]

Can the width of a data label for a MS Chart (in my case a
pie graph) be widened. There appears to be no property
for this. I have downloaded some utilities but these are
for simply creating label with bespoke text and do not
allow me to adjust the width... help!!!

Many thanks...

 

[Jon Peltier]

Mike -

The maximum width of a data label seems to be proportional to the width
of the chart object. You can make the chart wider to fit a longer label.
Most of a chart's text elements do not allow you to control their
dimensions. You can add textboxes, however, that allow you to adjust
their size. The drawback is that textboxes do not always stay where you
place them, and they do not stay linked to a data point.

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

 

[Mike Bishop]

Jon

Thanks for the response, this is as I had assumed having
failed to adjust them by any other means.

I still feel there must be a way to adjust the widths
while still retaining a dynamic link to the chart and
source data but will probably die looking...

Mike

 

[Jon Peltier]

Mike -

You can create a textbox that is linked to a cell. Select a chart, type
an equals sign, then select the cell with your mouse. Excel creates a
textbox with the formula =Sheet1!$A$1 (or whatever the sheet and cell
address).

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