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.
Steps to Insert a [Static] Vertical Line a Chart
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.
- Enter a new column beside your quantity column and name it “Ver Line”.
- Now enter a value “100” for Jan in “Ver Line” column.
- Select the entire table and insert a line chart with markers.
- You’ll get a chart like this.
- 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.
- In same axis options, move down to label position and select none (This will hide secondary axis, yup we don’t need it).
- 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 and increase your “Gap Width” to 500%.
Steps to Add a [Dynamic] Vertical Line in a Chart
Now it’s time to level up your chart and make dynamic vertical name. Please follow these simple steps for this.
- First of all, you need to insert a scroll bar.
- Go to developer tab ➜ Insert ➜ Scroll bar.
- Right click on your scroll bar and select format control.
- Link your scroll bar to cell C10 and enter 12 for maximum value.
- In the end, click OK.
- After that go to your data table and insert following formulas to the cell C2 (Formula Bar) and drag down up to the last cell of the table.
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.
Have you 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.
- How to Add a Horizontal Line in a Chart in Excel
- How to Create a Bullet Chart in Excel
- How to Create a Dynamic Chart Range in Excel
- How to Create a Dynamic Chart Title in Excel
- How to Create Interactive Charts In Excel
- How to Create a Sales Funnel Chart in Excel
- How to Create a HEAT MAP in Excel
- How to Create a HISTOGRAM in Excel
- How to Create a Pictograph in Excel
- How to Create a Milestone Chart in Excel
- How to Insert a People Graph in Excel
- How to Create PIVOT CHART in Excel
- How to Create a Population Pyramid Chart in Excel
- How to Create a SPEEDOMETER Chart [Gauge] in Excel
- How to Create a Step Chart in Excel
- How to Create a Thermometer Chart in Excel
- How to Create a Tornado Chart in Excel
- How to Create Waffle Chart in Excel
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.