

Be sure to delete the existing contents of the Series values boxes first - usually a one element array like =. In this example, we are going to add a vertical average line to Excel chart, so we use the AVERAGE function to find the average of x and y values like shown in the screenshot:


We will just have to do a little lateral thinking! However, "no easy way" does not mean no way at all. But there is still no easy way to draw a vertical line in Excel graph. In the modern versions of Excel 2013, Excel 2016 and Excel 2019, you can add a horizontal line to a chart with a few clicks, whether it's an average line, target line, benchmark, baseline or whatever.
Excel 2008 for mac connect data points with line how to#
You will also learn how to make a vertical line interactive with a scroll bar. The tutorial shows how to insert vertical line in Excel chart including a scatter plot, bar chart and line graph.
