View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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