Series![]() ![]() ![]() |
Represents leader lines in the specified chart. Leader lines connect data labels to data points. This object isn't a collection; there's no object that represents a single leader line.
Use the LeaderLines property to return the LeaderLines object. The following example adds data labels and blue leader lines to series one in the chart.
With myChart.SeriesCollection(1)
.HasDataLabels = True
.DataLabels.Position = xlLabelPositionBestFit
.HasLeaderLines = True
.LeaderLines.Border.ColorIndex = 5
End With