Alignment of data labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I change the size of data labels around a pie chart? I have plenty of
room to work with but Chart INSISTS on wrapping labels as in:

Saftey & Security - 80% gets formatted as
Safety
& Security
- 80%


Environment - 23% gets formatted as
Environ
ment - 23%


This looks like crap!!!! I have plenty of room and my boss asks me why I
can't fix it. WHY?????

Thanks,

joeb
 
Hi,

You can not override the default line wraps, only add additional ones.
If you reduce the font size it may remove the line wraps. Failing that
the best thing is to use textboxes, which will allow you better control
over the text alignment.

To add a textbox to the chart just select the chart and then type =
(equals sign). Now in the formula bar either enter the cell address of
the label or click it. This will create an automatic link between the
textbox and the cell.
You will of course have to position the textboxes around the pie chart.

Cheers
Andy
 
Back
Top