how to draw a vertical line in excel

Home ➜ Excel Charts ➜ How to Add a Vertical Line in a Chart in Excel

Sometimes while presenting data with an Excel chart nosotros need to highlight a specific betoken to get the user'south attention in that location. And the best way for this is to add a vertical line to a chart.

Yeah, y'all heard it right. You can highlight a specific betoken on a nautical chart with a vertical line. Just await at the below line chart with 12-months of data.

how to add a vertical line in a chart in excel

Now, you lot know the benefit of inserting a vertical line in a chart. But the indicate is, which is the best method? Well, out of all the methods, I've found this method (which I accept mentioned here) simple and easy.

Without any farther ado hither are the steps and please download this sample file from here to follow forth.

Steps to Insert a [Static] Vertical Line a Chart

Hither you accept a information table with monthly sales quantity and you demand to create a line nautical chart and insert a vertical line in it. Please follow these steps.

Enter a new cavalcade beside your quantity column and name it "Ver Line".
Now enter a value "100" for January in "Ver Line" column.
Select the entire table and insert a line chart with markers.
You'll get a nautical chart like this.
Now select the chart and open the "Chnage Chart Type" options from Pattern Tab.
After that change chart type to secondary axis and chart type to "Column Chart"
Now next thing is to conform axis values for your column bar.
Double click on your secondary axis to open formatting options.
Alter the maximum value to 100, equally we have entered the same value in Ver Line column.
In same axis options, motility down to label position and select none (This volition hibernate secondary centrality, yup we don't need it).
Last merely not to the lowest degree, we have to make our column bar picayune thin so that information technology will expect similar a line.
Click on the information bar, go to series option and increase your "Gap Width" to 500%.

Congratulations! You have successfully added a vertical line to your chart. You tin download this sample file from here to larn more about this.

Quick Tip: Merely enter 100 in the jail cell where yous want to add a vertical line. If you want to add a vertical line in Feb instead of May, but enter the value in February.

Steps to Add a [Dynamic] Vertical Line in a Nautical chart

Now information technology's fourth dimension to level upward your chart and brand a dynamic vertical name. Delight follow these simple steps for this.

First of all, you need to insert a scroll bar. Get to developer tab ➜ Insert ➜ Scroll bar.
Right-click on your scroll bar and select format control.
Link your scroll bar to prison cell C10 and enter 12 for maximum value.
In the end, click OK.
After that become to your data table and insert this formula [=IF(Friction match($A2,$A$ii:$A$13,0)=$D$i,100,"")] to cell C2 (Formula Bar) and drag downwardly upward to the last cell of the table.
Now y'all can utilise the scroll bar to navigate your vertical line in your chart. You can download this sample file from hither to larn more about this.

Conclusion

Equally I said, adding a vertical line in a chart is useful when you desire to highlight a specific data betoken in your chart. There are too some other ways to add a vertical line only I establish this method quick and like shooting fish in a barrel. I hope this charting tip volition help you to get better at Excel.

Have yous ever tried to do this earlier with your chart?

Delight share your views in the comment section I would love to hear from you and please don't forget to share this tip with your friends.