Export (0) Print
Expand All

LeaderLines Property [Excel 2003 VBA Language Reference]

Office 2003

Returns a LeaderLines object that represents the leader lines for the series. Read-only.

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
		

Remarks

This property applies only to pie charts.



Applies to | Series Object


Show:
© 2014 Microsoft