Tick Marks for Labels

G

Guest

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
 
J

Jon Peltier

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

- Jon
 
J

jlmccabes

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..

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
 
J

Jon Peltier

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
 
J

jlmccabes

YEP - Thank you - - moved two of them out further and tada leader
lines... Thought I had to click on some button to get it to work...Thank
You again.. Now I know how to show the little guys numbers easier..
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top