DropLines Property

Applies To

ChartGroup Object.

Description

Accessor. Returns a DropLines object that represents the drop lines for a series on a line or area chart. Applies only to line or area charts. Read-write.

See Also

HasDropLines Property.

Example

This example turns on drop lines for chart group one in Chart1 and then sets their line style, weight, and color. The example should be run on a 2-D line chart that has one series.

With Charts("Chart1").ChartGroups(1)
    .HasDropLines = True
    With .DropLines.Border
        .LineStyle = xlThin
        .Weight = xlMedium
        .ColorIndex = 3
    End With
End With