#Draw scatter chart in excel how to#
#Draw scatter chart in excel series#

Depending on your needs, set Direction to one of the following:

On the Format Error Bars pane, switch to the Error Bar Options tab (the last one) and set Percentage to 100.

Right-click on the vertical error bar and choose Format Error BarsвЂ¦ from the context menu.

Select the new data point in your chart (orange in our case) and add the Percentage error bars to it ( Chart Elements button > Error Bars > Percentage).

Otherwise, the selected x and/or y cell will be added to the existing array, which will lead to an error.

#Draw scatter chart in excel series#

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.

#Draw scatter chart in excel 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.