how to plot a graph in excel with different slope lines

In the previous two methods, we used only one point from our dataset to add a line to the scatter plot. Adding Slope Line to Scatter Plot in Excel Read More: How to Add Average Line to Scatter Plot in Excel (3 Ways)ģ. Finally, you will have a formatted horizontal line.Then, set the color to Red and the width to 1 pt.After that, set the Percentage value to 100%.Now, right-click on the horizontal line and go to Format Error Bars.Again, set the Percentage value to 0 and press Enter.Just as we did previously, this time right-click on the vertical line and select Format Error Bars.I will also show you how to format your line to make it more visible. This time we will add a horizontal line to the scatter plot, again using the error bars option. The first few steps of this method are exactly the same as the previous method. How to Connect Dots in Scatter Plot in Excel (with Easy Steps)Ģ.How to Add Text to Scatter Plot in Excel (2 Easy Ways).Read More: How to Make a Scatter Plot in Excel with Two Sets of Data (in Easy Steps) Finally, you have your vertical line through your desired data point.Then, in the error amount option, set the Percentage value to 100%.In the Format Error Bars window, set the direction to Minus.As shown previously, right-click on the vertical line of the orange point.After that, in the new window on the right side, set the horizontal line Percentage value to 0.Moreover, right-click on the horizontal line and select Format Error Bars.Here, you will get a horizontal and a vertical line around the selected data point.Now, keeping the orange data point selected, go to Chart Design > Add Chart Element > Error Bars > Percentage.Press OK and this will generate a new data called Vertical Line.Furthermore, select cell B8 as Series X values and cell C8 as Series Y values.

Then, in the Edit Series window, set Vertical Line as the Series name.

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

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

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

Add Vertical Line to Scatter Plot in Excel Once you have your scatter plot ready, you can now follow along.ġ. You can easily create a scatter plot following this tutorial. To begin with, generate a scatter plot with the data set I have provided you. 3 Practical Examples to Add Line to Scatter Plot in Excel

How to plot a graph in excel with different slope lines