How to Add Line to Scatter Plot in Excel (3 Practical Examples)

In this tutorial, I am going to share with you 3 practical examples to show how to add line to an Excel scatter plot. Lines may be needed to show any threshold or limit within your data. They are also very useful in statistical analysis. Using lines properly can be very helpful to represent data.


Download Practice Workbook

You can download the practice workbook from here.


3 Practical Examples to Add Line to Scatter Plot in Excel

To begin with, generate a scatter plot with the data set I have provided you. You can easily create a scatter plot following this tutorial. Once you have your scatter plot ready, you can now follow along.


1. Add Vertical Line to Scatter Plot in Excel

We will add a vertical line to the following data set. This data set has an X column and a Y column.

Add Vertical Line to Scatter Plot in Excel

Steps:

  • First of all, right-click on the scatter chart and click on Select Data.

Add Vertical Line to Scatter Plot in Excel

  • Next, in the Select Data Source window, click on Add.

Add Vertical Line to Scatter Plot in Excel

  • Then, in the Edit Series window, set Vertical Line as the Series name.
  • Furthermore, select cell B8 as Series X values and cell C8 as Series Y values.

Add Vertical Line to Scatter Plot in Excel

  • Press OK and this will generate a new data called Vertical Line.

Add Vertical Line to Scatter Plot in Excel

  • Now, keeping the orange data point selected, go to Chart Design > Add Chart Element > Error Bars > Percentage.
  • Here, you will get a horizontal and a vertical line around the selected data point.

Add Vertical Line to Scatter Plot in Excel

  • Moreover, right-click on the horizontal line and select Format Error Bars.

  • After that, in the new window on the right side, set the horizontal line Percentage value to 0.

  • As shown previously, right-click on the vertical line of the orange point.
  • In the Format Error Bars window, set the direction to Minus.

  • Then, in the error amount option, set the Percentage value to 100%.

  • Finally, you have your vertical line through your desired data point.

Read More: How to Make a Scatter Plot in Excel with Two Sets of Data (in Easy Steps)


Similar Readings


2. Insert Horizontal Line to Scatter Plot

The first few steps of this method are exactly the same as the previous method. This time we will add a horizontal line to the scatter plot, again using the error bars option. I will also show you how to format your line to make it more visible.

Steps:

  • Just as we did previously, this time right-click on the vertical line and select Format Error Bars.

Insert Horizontal Line to Scatter Plot

  • Again, set the Percentage value to 0 and press Enter.

Insert Horizontal Line to Scatter Plot

  • Now, right-click on the horizontal line and go to Format Error Bars.
  • Then, set the direction to Minus.

Insert Horizontal Line to Scatter Plot

  • After that, set the Percentage value to 100%.
  • Now, go to the Fill and Line options.

  • Then, set the color to Red and the width to 1 pt.
  • Finally, you will have a formatted horizontal line.

Read More: How to Add Average Line to Scatter Plot in Excel (3 Ways)


3. Adding Slope Line to Scatter Plot in Excel

In the previous two methods, we used only one point from our dataset to add a line to the scatter plot. In our third method, we are going to use two points to add a sloping line. The slope lines are very important for regression analysis. Let us see how we can add a slope line.

Steps:

  • In the beginning, right-click on the scatter plot and choose Select Data.

Adding Slope Line to Scatter Plot in Excel

  • Now, in the new Select Data Source window, click on Add.

Adding Slope Line to Scatter Plot in Excel

  • In the Edit Series window, enter the series name Slope Line.
  • Then, for the series X values, hold Ctrl and select cells B5 and B8.
  • After that, for series Y values, hold Ctrl and select cells C5 and C8.
  • Now, simply press OK.

Adding Slope Line to Scatter Plot in Excel

  • Now, we have a new data named Slope Line.

Adding Slope Line to Scatter Plot in Excel

  • Now, select the two data points and right-click.
  • Here, select Change Series Chart Type.

  • After that, a new window opens, go to the Combo option.
  • Click the dropdown arrow beside the Slope Line option.
  • From the dropdown options, select the icon with the name Scatter with Straight Lines.
  • Now, press OK.

  • Finally, a slope line through the selected data points will be added.

Read More: How to Add Data Labels to Scatter Plot in Excel (2 Easy Ways)


Conclusion

I hope that you followed all the above steps with me and were able to add different types of lines to the scatter plot in Excel. You can take these examples that I showed you and modify them to suit your own dataset. Try changing the orientation of the lines and adding more data points. To learn more Excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.


Related Articles

Nazmul Hossain Shovon

Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo