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.
Worth $20, Absolutely Free
Sometimes while presenting data with an Excel chart we need to highlight a specific point to get user’s attention there.
And, the best way for this is to add a vertical line to a chart.
Yes, you heard it right.
You can highlight a specific point on a chart with a vertical line. Just look at the below line chart with 12-months of data.
Now, you know the benefit of inserting a vertical line in a chart. But the point is, which is the best method?
Well, out of all the methods, I’ve found this method (which I have mentioned here) simple and easy.
Without any further ado here are the steps. Please download this sample file from here to follow along.
Here you have a data table with monthly sales quantity and you need to create a line chart and insert a vertical line in it.
Please follow these steps.
Download this sample file from here to learn more about this.
Quick Tip: Just enter 100 in the cell where you want to add a vertical line. If you want to add a vertical line in Feb instead of May, just enter the value in Feb.
Check this out ➜ Add Horizontal Line in a Chart
Now, it’s time to level up your chart and make dynamic vertical name.
Follow these simple steps.
Now you can use the scroll bar to navigate your vertical line in your chart.
Download this sample file from here to learn more about this
Check this out ➜ Advanced Excel Charts
As I said, adding a vertical line in a 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 but I found this method quick and easy.
I hope this charting tip will help you to get better at Excel.
Now tell me one thing. Have ever tried to do this before with your chart? Please 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.