Edit

Share via

Series.LeaderLines property (Excel)

  • Article

Returns a LeaderLines object that represents the leader lines for the series. Read-only.

Syntax

expression.LeaderLines

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.