Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Messy tab characters | Excel Discussion (Misc queries) | |||
Transforming messy database into clean database | Excel Discussion (Misc queries) | |||
Messy Text to Columns | Excel Discussion (Misc queries) |