onlinesmall.blogg.se

Excel 2008 for mac connect data points with line
Excel 2008 for mac connect data points with line






excel 2008 for mac connect data points with line

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:

excel 2008 for mac connect data points with line

  • 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.
  • excel 2008 for mac connect data points with line

    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.








    Excel 2008 for mac connect data points with line