Click Gridlines from the drop-down list then select the following Gridline types Primary Major Horizontal Primary Major Vertical Primary Minor. To convert the chart into a vertical line chart lets make the following changes Click on Select Data appears in the right click menu. Below are the steps to add a secondary axis to a chart. Select the data that will be used to create a chart. Change the Vertical Axis maximum value to match the value from column C. In the popup menu. Please follow the steps below to add the Gridlines to a Chart. To add a vertical line to your line or scatter chart do the following. To add a new data series to your chart do one of the following. Click OK to close dialog and you see the chart is inserted with two y axes.

Eg this will be useful to show data and highlight a current date. Right click on the new series Today and select Chart Type from the pop up menu. Go to Insert Line Charts Line with Markers. About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy Safety How YouTube works Test new features Press Copyright Contact us Creators. To convert the chart into a vertical line chart lets make the following changes Click on Select Data appears in the right click menu. Then right click the red column in the chart select Change Series Chart Type. Ad Get More Results from Your Graphs for Less Effort. To add a new data series to your chart do one of the following. Select the New Series Categories in First Column and Series Names in First Row options. Change the Vertical Axis maximum value to match the value from column C.

To convert the chart into a vertical line chart lets make the following changes Click on Select Data appears in the right click menu. To add a vertical line to your line or scatter chart do the following. Eg this will be useful to show data and highlight a current date. Click Gridlines from the drop-down list then select the following Gridline types Primary Major Horizontal Primary Major Vertical Primary Minor. Insert a column in the table. This will open the Insert Chart dialog box. This will select the line and open the Format Data Series pane on the right side of your Excel window. Select the New Series Categories in First Column and Series Names in First Row options. Add the date with the current date to your data for example. Please follow the steps below to add the Gridlines to a Chart.

Ad Get More Results from Your Graphs for Less Effort. In the Design tab click Add Chart ElementStep 3. In Change Chart Type dialog click Line in left pane and select the line chart type you like. Click OK to close dialog and you see the chart is inserted with two y axes. About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy Safety How YouTube works Test new features Press Copyright Contact us Creators. Follow the steps on how to add a vertical line in Excel graph below. In Excel 2013 you need to change the chart type by. On the Chart Design tab in the Data group choose Select Data. In the popup menu. Add the date with the current date to your data for example.

The new series has the same style Column or Line as the first series. In Excel 2013 you just need to directly type 1 into Maximum text box in the Format Axis pane. Then right click the red column in the chart select Change Series Chart Type. Go to Insert Illustrations Line. Right-click in the chart area and choose Select Data. To add a vertical line to your line or scatter chart do the following. This will select the line and open the Format Data Series pane on the right side of your Excel window. Right click on the new series Today and select Chart Type from the pop up menu. Follow the steps on how to add a vertical line in Excel graph below. Scan the charts in the left pane and select the one that has a secondary axis.