Excel.Series.HasLeaderLines.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Series.HasLeaderLines property (Excel)	vbaxl10.chm578120	vbaxl10.chm578120	Excel.Series.HasLeaderLines	9401e5a6-5acc-7503-02e6-b6dc42f381bb	05/11/2019	medium

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

[!includeSupport and feedback]