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.

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

#3 Select Lines, then click Drop Lines.

4# let’s see the last result.