onlinesmall.blogg.se - Excel 2008 for mac connect data points with line

Excel 2008 for mac connect data points with line how to#

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.

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.