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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inside Base Series Label Showing #N/A 0
Automate data labels 3
Can I realign all data labels in a chart at once 1
Interval Between Labels problem 1
Data Labels Disappearing 0
How do I resize a data label box in a pie chart to stop text wrapp 1
Auto positioning of labels outside pie slices 2
Change the size of the data labels 5

Back
Top