ChartGroup.HasDropLines Property (Excel)
True if the line chart or area chart has drop lines. Applies only to line and area charts. Read/write Boolean.
expression A variable that represents a ChartGroup object.
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