| title | ChartGroup.HasDropLines property (Excel) | |
|---|---|---|
| keywords | vbaxl10.chm568079 | |
| f1_keywords |
|
|
| api_name |
|
|
| ms.assetid | cc0d188d-51ba-951d-7063-10820e5e4a42 | |
| ms.date | 04/20/2019 | |
| ms.localizationpriority | medium |
True if the line chart or area chart has drop lines. Applies only to line and area charts. Read/write Boolean.
expression.HasDropLines
expression A variable that represents a ChartGroup object.
This example turns on drop lines for chart group one on Chart1, and then sets their line style, weight, and color. The example should be run on a 2D 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[!includeSupport and feedback]