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

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

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

With the chart selected, choose ChartChart 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.

AbbaFan wrote:
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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

With the chart selected, choose ChartChart 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.

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!