DropLines Excel Chart Solution VBA (Visual basic for Applications)

DropLines Excel Chart Solution VBA (Visual basic for Applications)

DropLines

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)

figure 1.0
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.

Leave a Reply

Your email address will not be published.