Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

LeaderLines Object

Office 2007
Represents leader lines on a chart. Leader lines connect data labels to data points.

Remarks

This object isn’t a collection; there’s no object that represents a single leader line.

This object applies only to pie charts.

Example

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.

Visual Basic for Applications
With Worksheets(1).ChartObjects(1).Chart.SeriesCollection(1)
    .HasDataLabels = True
    .DataLabels.Position = xlLabelPositionBestFit
    .HasLeaderLines = True
    .LeaderLines.Border.ColorIndex = 5
End With



Community Additions

Show:
© 2015 Microsoft