![the vertical scroll bar missing in excel the vertical scroll bar missing in excel](https://user-images.githubusercontent.com/10732375/62584550-fe5b8b80-b869-11e9-91b8-5a796bc7f5a2.png)
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. All about options to Hide horizontal or vertical scroll bars in Excel. Have you ever tried to do this before with your chart? I hope this charting tip will help you to get better at Excel. There are also some other ways to add a vertical line but I found this method quick and easy.
The vertical scroll bar missing in excel download#
You can download this sample file from here to learn more about this.Īs I said, adding a vertical line in a chart is useful when you want to highlight a specific data point in your chart.
The vertical scroll bar missing in excel series#
Click on the data bar, go to series option and increase your “Gap Width” to 500%.Ĭongratulations! You have successfully added a vertical line to your chart.Last but not least, we have to make our column bar little thin so that it will look like a line.In same axis options, move down to label position and select none (This will hide secondary axis, yup we don’t need it).Change the maximum value to 100, as we have entered the same value in Ver Line column.Double click on your secondary axis to open formatting options.Now next thing is to adjust axis values for your column bar.
![the vertical scroll bar missing in excel the vertical scroll bar missing in excel](https://user-images.githubusercontent.com/10732375/62584581-14694c00-b86a-11e9-8965-880c2ed27f6a.png)
After that change chart type to secondary axis and chart type to “Column Chart”.Now select the chart and open the “Chnage Chart Type” options from Design Tab.Select the entire table and insert a line chart with markers.Now enter a value “100” for Jan in “Ver Line” column.Enter a new column beside your quantity column and name it “Ver Line”.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. Without any further ado here are the steps and please download this sample file from here to follow along. 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. Now, you know the benefit of inserting a vertical line in a chart.