LeaderLines Object [Excel 2003 VBA Language Reference]

  • Article
Series
LeaderLines
Border

Represents leader lines on a 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.

Using the LeaderLines Object

Use the LeaderLines property to return the LeaderLines object. The following example adds data labels and blue leader lines to series one on chart one. 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

Remarks

This object applies only to pie charts.

Properties | Application Property | Border Property | Creator Property | Parent Property

Methods | Delete Method | Select Method

Parent Objects | Series Object

Child Objects | Border Object