Add Vertical Line To Excel Chart. Right click on newly added series and click change series chart type. Now the average vertical line has added into bar chart.
In one cell E1 type. We are almost done. How To Add A Line In Excel Graph Average Line Benchmark Etc Ablebits Com.
You will notice a small bit added to the chart in front of second task as new series.
You can format the line by right clicking the line and selecting Format Data Series in the context menu then you can change the line as you need in the Format Data Series dialogpane. Choose where you want the vertical reference line to cross the x-axis and enter those values below X. We will go to Chart Design and select Add Chart Element. Click Add Chart Element Gridlines.