Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

10000+ Copies Already Downloaded

How To Add a Vertical Line in Excel Chart [Easiest Method]

how to add a vertical line in excel chartHave you ever tried to add a vertical line in excel chart?

If not yet.

Then it’s time to give it a try.

You can use this vertical line to highlight a specific point in your chart.

Here, in this post I’ll share with you the easiest way to add a vertical line in excel chart.

But, apart from this, I’ll also show you how you can make that line dynamic.

And, I’m sure you’ll love that.

So let’s get started.

Steps To Add a Vertical Line in Excel Chart

Here I have a data table of monthly quantity. And, I’ll use this table to create a chart with a vertical line.

insert data to add a vertical line in excel chart

Download this file to follow along.

Follow these steps.

  • Enter a new column beside your quantity column & name it “Ver Line”.
  • Now, enter a value “100” for Jan in “Ver Line” column.

insert column to add a vertical line in excel chart

insert line chart with markers to add a vertical line in excel chart

  • You’ll get a chart like this.

default line chart to add a vertical line in excel chart

  • Now, select your chart & open “Change Chart Type” option.

change chart type to add a vertical line excel chart

  • From change chart type window, you have to do two things with “Ver Line”.
    • Change it to the secondary axis.
    • Change chart type to “Column chart”.

change to secondary axis to add a vertical line excel chart

  • Now, next thing is to adjust axis values for your column bar.
  • Double click on your secondary axis to open formatting options.
  • Change the maximum value to 100, as we have entered the same value in Ver Line column.

change axis value to add a vertical line excel chart

  • In same axis options, move down to label position & select none (This will hide secondary axis, Yup we don’t need it.)

hide secondary axis to add a vertical line excel chart

  • Last but not least, we have to make our column bar little thin so that it will look like a line.
  • Click on the data bar, go to series option & increase your “Gap Width” to 500%.

change gap width to add a vertical line excel chart

Congratulations! You have successfully added a vertical line in your excel chart.

final step to add a vertical line in excel chart

 Quick Tip: Just enter 100 in a cell where you want to add a vertical line. If you want to add a vertical line in Feb instead of Jan, just enter the value in Feb.

Here is the sample file to learn more about it.

Add a Dynamic Vertical Line in Excel Chart

Now, it’s time to level up your chart & make it dynamic.

Follow these steps.

add scrollbar to add a vertical line excel chart

  • Right click on your scroll bar & select format control.
  • Link your scroll bar to cell C10 & enter 12 for maximum value. Click OK.

format control scrollbar to add a vertical line excel chart

  • Now, go to your data table & insert following formulas to the cell C2 & drag down up to the last cell of the table.
    • =IF(MATCH($A2,$A$2:$A$13,0)=$D$1,100,””)

enter formula to add a vertical line excel chart

  • Now you can use the scroll bar to navigate your vertical line in your chart.

use scrollbar to navigate to add a vertical line excel chart

Download this final sample file to learn more about this vertical line.

Last Words

Adding a vertical line in excel chart is useful when you want to highlight a specific data point in your chart.

There are also some other ways to add a vertical line in excel chart. But, I found this method quick & easy.

Over To You

I hope your like this tip

And, if you are using any other way, make sure to compare this method with yours.

Don’t forget to tell me your views in the comment box.

What is Next?

If you want to add a horizontal line in excel chart, I have a super easy method for that.



  • Asif Hafeez

    Thanks Puneet, nice sharing and I second your statement it is an easy method.

    • Puneet Gogia

      Hey Asif,
      Thanks for your words.

  • mma173

    Thanks’ I make use of this.

    • Puneet Gogia

      Welcome.
      I’m so glad you found this post helpful!