Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

# How to Find Slope of Tangent Line in Excel (2 Suitable Ways)

Sometimes, users have to find the slope of a tangent line in Excel. By applying a certain Excel function or utilizing some Excel features, they can perform this job easily. In this article, I will show you how to find the slope of a tangent line in Excel.

## 2 Suitable Ways to Find Slope of Tangent Line in Excel

In this article, you will see two easy methods to find the slope of a tangent line in Excel. The first method will discuss the use of the SLOPE function of Excel. In the second method, I will insert the available data into an Excel chart and then find the slope from the equation.

To illustrate my article further, I will use the following sample data set. ### 1. Apply SLOPE Function to Find Slope of Tangent Line

In the first method, I will apply the SLOPE function of Excel for determining the slope of a tangent line. By using the function, you can calculate the slope in Excel. The function will take the y-axis and x-axis values of an equation as the inputs and then show the slope as a numerical value. Go through the following steps for a better understanding.

Steps:

• First of all, I will assume some values for the X variable of the equation in cell C4.
• Then, to calculate the values of the Y variable, insert the following formula in cell C7.
`=B7^2+1` • Secondly, press Enter and use AutoFill to get the desired result for the lower cells as well. • Thirdly, to find the slope, make an extra field in cell C13 and type the following formula.
`=SLOPE(C7:C11,B7:B11)` • Finally, press Enter to get the slope that is 6. ### 2. Insert Data into Excel Chart to Find Slope of Tangent Line

In the second method, instead of using any function, I will insert the available data set for making an Excel chart. After making the chart, I will find the slope from the trendline. Let’s follow the instruction below to find the slope of the tangent line!

Steps:

• Firstly, calculate the values of the y-axis for the equation of cell C4 just like the previous method.
• Then, select the data range B6:C11 and go to the Insert tab of the ribbon.
• Afterward, from the Charts group, select Insert Scatter (X,Y) or Bubble Chart. • Secondly, from the dropdown, choose Scatter with Smooth Lines. • Thirdly, you will see the chart with the required data in your Excel sheet.
• After that, select your Excel chart and choose the Chart Elements icon which is on the top right corner of the chart. • Fourthly, from the Chart Elements command select the Trendline dropdown and from there choose More Options. • Consequently, you will see the Format Trendline window pane after the previous step and then mark the option Display Equation on chart. • Finally, you will see the consequent equation for this tangent line is y = 6x – 6, and by comparing the equation with y = mx + c, you can see the slope of this line is 6. Notes
• While inserting the data range in the SLOPE function formula, remember to insert the values of the y-axis in the first place.
• Insert the proper data range while making the Excel chart.
•  The SLOPE function returns #DIV/0! error when any cell of X-coordinates or Y-coordinates is empty.

## Conclusion

That’s the end of this article. I hope you find this article helpful. After reading the above description, you will be able to find the slope of a tangent line in Excel. Please share any further queries or recommendations with us in the comments section below.  