Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default Tick Marks for Labels

How can I create tick marks on my labels in my Doughnut Charts to distinguish
which labels belong to what category. IE: I need a line connecting my data
label to individual categories. Any suggestions?

Mary Ann
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Tick Marks for Labels

Double click on the pie, click on the Data Labels tab, and check the box for
Show leader lines.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"tt_Gyrl" wrote in message
...
How can I create tick marks on my labels in my Doughnut Charts to
distinguish
which labels belong to what category. IE: I need a line connecting my data
label to individual categories. Any suggestions?

Mary Ann



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Tick Marks for Labels

If Excel can place the label "close enough" to the data point, it decides
not to draw the leader line. If you drag the label away from the point, the
leader line should appear.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"jlmccabes" wrote in message
...
I also having trouble with "leader lines" Only 2 or 3 show up. Seems
random as to which ones it picks.. Any way to get all or most with leader
lines showing up..
Thank You in advance either yes or no..

"tt_Gyrl" wrote in message
...
How can I create tick marks on my labels in my Doughnut Charts to
distinguish
which labels belong to what category. IE: I need a line connecting my data
label to individual categories. Any suggestions?

Mary Ann




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
Placement of tick marks J. McAdams Charts and Charting in Excel 4 May 21st 23 07:44 PM
x axis tick marks Buckeye5 Charts and Charting in Excel 3 February 8th 07 11:27 PM
Tick marks ofey New Users to Excel 5 November 21st 05 06:32 PM
Green Tick Marks DNA Excel Discussion (Misc queries) 5 June 13th 05 08:22 PM
tick marks on all 4 sides of an x-y chart mickey Charts and Charting in Excel 1 May 2nd 05 11:09 AM


All times are GMT +1. The time now is 11:19 AM.

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"