Help! Messy-looking "pie chart"!!!

  • Thread starter Thread starter AbbaFan
  • Start date Start date
A

AbbaFan

Because a few of my pie chart segments (or is that sectors?!) are very
small percentages, the literals are overwriting each other. I once saw
an example of a pie chart where lines miraculously appeared to
separate the literals out of the way, but I can't find what setting
does all this that. Any ideas? Thanks in advance!

Meriel
 
With the chart selected, choose Chart>Chart Options
On the Data Labels tab, add a check mark to 'Show leader lines'
Click OK
Click on one of the labels, to select all the labels
Click on one of the crowded labels, to select it
Drag that label slightly away from the chart.
 
With the chart selected, choose Chart>Chart Options
On the Data Labels tab, add a check mark to 'Show leader lines'
Click OK
Click on one of the labels, to select all the labels
Click on one of the crowded labels, to select it
Drag that label slightly away from the chart.
Click to expand...

Thanks. I did have "show leader lines" tiicked, to no avail, because I
didn't realise I had to do something else manually. I just assumed it
would sort it out automtically for me - oops! Anyway, thanks for the
help. It looks fine now I've dragged!
 
Back
Top