Skip to content

Latest commit

 

History

History
46 lines (29 loc) · 1.14 KB

Excel.Series.LeaderLines.md

File metadata and controls

46 lines (29 loc) · 1.14 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Series.LeaderLines property (Excel)
vbaxl10.chm578121
vbaxl10.chm578121
Excel.Series.LeaderLines
d08a982c-8ac0-3f72-3f94-d72b3081f013
05/11/2019
medium

Series.LeaderLines property (Excel)

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

[!includeSupport and feedback]