Shows the drop lines in a chart group which helps identifying the gap between data. 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 removed.
If the HasDropLines property of the ChartGroup object is False, most properties of the DropLines object are disabled.
Lets take an example, following chart shows no drop line (figure 1.0) post code it shows drop lines (figure 1.1)
VBA Code Example
Sub DropLinesExample() Worksheets("Sheet5").ChartObjects(2).Activate ActiveChart.ChartGroups(1).HasDropLines = True ActiveChart.ChartGroups(1).DropLines.Border.ColorIndex = 3 End Sub
Please leave your comments or queries under comment section also please do subscribe to out blogs to keep your self upto date.