Class LeaderLines (Excel VBA)

The class LeaderLines represents leader lines on a chart. Leader lines connect data labels to data points.

Item

To use a LeaderLines class variable it first needs to be instantiated, for example

Dim lls as LeaderLines
Set lls = ActiveChart.FullSeriesCollection(1).LeaderLines

LeaderLines class variables can be set using the Series.LeaderLines procedure.

Border

Returns a Border object that represents the border of the object.

Dim brdBorder As Border
Set brdBorder = ActiveChart.FullSeriesCollection(1).LeaderLines.Border

Delete

Deletes the object.

ActiveChart.FullSeriesCollection(1).LeaderLines.Delete

Format

Returns the ChartFormat object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveChart.FullSeriesCollection(1).LeaderLines.Format

Select

Selects the object.

ActiveChart.FullSeriesCollection(1).LeaderLines.Select