Description
Represents the drop lines in a chart group. Drop lines connect the points in the chart with the x-axis. Only line and area chart groups can have drop lines. There is no singular DropLine object; you must turn drop lines on or off for all points in a chart group at once.
Accessors
The DropLines property returns the drop lines for a chart group. The following example turns on drop lines for chart group one in embedded chart one on the worksheet named "Sheet1" and then sets the drop line color.
Worksheets("sheet1").ChartObjects(1).Activate
ActiveChart.ChartGroups(1).HasDropLines = True
ActiveChart.ChartGroups(1).DropLines.Border.ColorIndex = 3
Remarks
If the HasDropLines property is False, most properties of the DropLines object are disabled.
Properties
Application Property, Border Property, Creator Property, Name Property, Parent Property.
Methods
Delete Method, Select Method.