Otherwise, the selected x and/or y cell will be added to the existing array, which will lead to an error. 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: Enter the data for the vertical line in separate cells.Select your source data and create a scatter plot in the usual way ( Inset tab > Chats group > Scatter).To add a vertical line to Excel scatter chart, this is what you need to do: Our line will be dynamic and will react to any data changes automatically. Naturally, we are not going to "tie" a line to the x-axis because we don't want to reposition it every time the source data changes. To highlight an important data point in a scatter chart and clearly define its position on the x-axis (or both x and y axes), you can create a vertical line for that specific data point like shown below: Insert vertical line in Excel bar chart.
Add vertical line to Excel scatter chart.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.
#INSERT HORIZONTAL LINE WORD 2013 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.