ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I re-route the leader lines in a Pie chart? (https://www.excelbanter.com/charts-charting-excel/125431-how-can-i-re-route-leader-lines-pie-chart.html)

John Casper

How can I re-route the leader lines in a Pie chart?
 
How can I re-route the leader lines in a Pie chart? Is this even possible?
When the category name is moved above the section of the pie chart, the lines
can get in each others way. By being able to move the line to another section
of the box, the interference can be eliminated.

Tushar Mehta

How can I re-route the leader lines in a Pie chart?
 
In article , ?B?
Sm9obiBDYXNwZXI=?= <John says...
How can I re-route the leader lines in a Pie chart? Is this even possible?
When the category name is moved above the section of the pie chart, the lines
can get in each others way. By being able to move the line to another section
of the box, the interference can be eliminated.

You can click the label and drag it wherever you want. The leader lines
will automatically adjust.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

John Casper

How can I re-route the leader lines in a Pie chart?
 
I am aware that the leader lines move when you drag the label. However, there
are 6 points on the label box and sometimes when you move the box, the line
goes through another label box. If one were able to attach the leader line to
one of the other points on the box, the line would not be crossing through
other labels. Can anyone help?

"Tushar Mehta" wrote:

In article , ?B?
Sm9obiBDYXNwZXI=?= <John says...
How can I re-route the leader lines in a Pie chart? Is this even possible?
When the category name is moved above the section of the pie chart, the lines
can get in each others way. By being able to move the line to another section
of the box, the interference can be eliminated.

You can click the label and drag it wherever you want. The leader lines
will automatically adjust.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions



All times are GMT +1. The time now is 05:10 AM.

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