Fabulous Excel Chart Vertical Grid Lines
By default Microsoft Office Excel determines the minimum and maximum scale values of the vertical value axis also known as the y axis when you create a chart.
Excel chart vertical grid lines. You can also display depth gridlines in 3-D charts. Now enter a value 100 for Jan in Ver Line column. Gridlines extend from any horizontal and vertical axes across the plot area of the chart.
Add the date with the current date to your data for example. To add a new data series to your chart do one of the following. Click Insert and then select a line column or bar graph that will have gridlines.
In some empty cells set up the data for the vertical line like shown below. Then just select the secondary axis on top and delete it. Click the chart to show Chart Tools in the Ribbon and click Layout Gridlines.
Under Chart Tools on the Design tab in the Data group choose Select. Excel 2010 Line Chart Gridlines Hi. In Excel 2010 if you click on the chart you will see the Chart Tools Tab.
Click the Gridlines tool in the Axes group. To create a vertical line in your Excel chart please follow these steps. That will add a graph to the spreadsheet as below.
First select a few numbers on an Excel spreadsheet. Select the entire table and insert a line chart with markers. I am trying to set up vertical grid lines that will appear on January each year.