DropLines object (Excel)

Represents the drop lines in a chart group.

Remarks

Drop lines connect the points in the chart with the x-axis. Only line and area chart groups can have drop lines. This object isn't a collection. There's no object that represents a single drop line; you either have drop lines turned on for all points in a chart group or you have them turned off.

If the HasDropLines property of the ChartGroup object is False, most properties of the DropLines object are disabled.

Example

Use the DropLines property of the ChartGroup object to return the DropLines object. The following example turns on drop lines for chart group one in embedded chart one, and then sets the drop line color to red.

Worksheets("sheet1").ChartObjects(1).Activate 
ActiveChart.ChartGroups(1).HasDropLines = True 
ActiveChart.ChartGroups(1).DropLines.Border.ColorIndex = 3

Methods

• Delete
• Select

Properties

• Application
• Border
• Creator
• Format
• Name
• Parent

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.