Series.HasLeaderLines Property (Excel)
True if the series has leader lines. Read/write Boolean.
Syntax
expression .HasLeaderLines
expression A variable that represents a Series object.
Remarks
This property applies only to pie charts.
Example
This example adds data labels and blue leader lines to series one on the pie chart. If no leader lines are visible this example code will fail. In this situation, you can manually drag one of the data labels away from the pie chart to make a leader line show up.
With Worksheets(1).ChartObjects(1).Chart.SeriesCollection(1)
.HasDataLabels = True
.DataLabels.Position = xlLabelPositionBestFit
.HasLeaderLines = True
.LeaderLines.Border.ColorIndex = 5
End With