Adding Drop Lines in Excel Line Chart

This post will guide you how to add drop lines to a line chart or graph in Excel. You can add drop lines to a line chart to connect the data point on the axis. It can make it easier to determine the X value where each data point occurs.

Adding Drop Lines in Excel Line Chart

To add drop lines to an Existing Excel Line chart, just do the following steps:

#1 Select the existing Line Chart.

add drop line1
#2 go to the Design Tab, click Add Chart Element button under the Chart Layouts group.

add drop line2

#3 Select Lines, then click Drop Lines.

add drop line3

4# let’s see the last result.

add drop line4

Leave a Reply