ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Tick Marks for Labels (https://www.excelbanter.com/charts-charting-excel/158176-tick-marks-labels.html)

tt_Gyrl

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

Jon Peltier

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




Jon Peltier

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






All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com