Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.charting
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

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
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.


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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Messy tab characters Gargoyl Excel Discussion (Misc queries) 2 April 19th 06 11:09 PM
Transforming messy database into clean database SteveC Excel Discussion (Misc queries) 4 January 24th 06 11:34 PM
Messy Text to Columns sweeneysmsm Excel Discussion (Misc queries) 3 November 8th 05 01:08 AM


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"