# How to Calculate Slope of Exponential Graph in Excel

There is only one slope for a linear graph. But in the case of an exponential graph, there are many slopes that we can detect. This article is about how you can calculate the slope of an exponential graph in Excel.

## Basics of Slope and Exponential Graph

Exponential Graph:

Exponential graphs increase or decrease rapidly. The basic equation for the exponential graph is:

`y=a.b``x`

In this formula, a, and b are constants.

Slope:Â

The slope indicates whether there is an upward trend or a downward trend. It defines the steepness.

For this exponential equation, let’s find out its slope.

lny = lna + x(lnb)

Slope:Â dy/dx=a.bx(lnb)

## How to Calculate Slope of Exponential Graph in Excel: 3 Simple Steps

We have taken a dataset of X values and Y values where the Y values increase exponentially with the X values.

We will convert this dataset into an exponential function. With the help of the LOGEST function we will find the constant values a and b. Then, we will find slopes for every X value.

### Step 1: Finding Constant a and b of Exponential Graph with LOGEST

First, we have to find the value of constants a and b.

âž¤ For that, add two columns beside the dataset.

âž¤ Select both cells D5 and E5.

âž¤ Then, write the following formula and press ENTER.

`=LOGEST(C5:C10,B5:B10,1,1)`

Here,

• C5:C10:- Y values
• B5:B10:- X values
• 1 :- const value
• 1:- Stats value

Thus, we get the constant values a and b.

Read More: How to Calculate Slope and Intercept in Excel

### Step 2: Calculating Slope of Exponential Graph in Excel

As we have shown previously, the slope for the exponential equation is:

`dy/dx=a.b``x``(lnb)`

We have already got a and b. Now, we will find bx and lnb and calculate corresponding slopes for X values.

âž¤ Apply the LN function in cell G6 and press ENTER.

`=LN(G5)`

This function gives a Logarithm for a value.

So, we get the value of lnb.

âž¤ Now, apply the POWER function in C5 and press ENTER.

`=POWER(\$G\$5,B5)`

Here,

• \$G\$5:- absolute value
• B5:- X values

Thereby, we get value for bx.

âž¤ Now, Hold and Drag the C5 cell downward.

So, we get bx values for all the cells.

âž¤ Now, write the following slope formula D5 and press ENTER.

`=\$G\$4*C5*\$G\$6`

Here,

• \$G\$4:- absolute value
• C5:- bx
• \$G\$6:- absolute value

Doing so, we get the first slope value.

âž¤ Now, Hold and Drag the D5 cell Downward.

Thus, we have all the slope values.

Read More: How to Find the Slope of a Line in Excel

### Step 3: Plotting Graph of Slope Value vs X Values

Now let’s plot slope values vs x values graph.

âž¤ First, copy and paste the X Value and Slope Columns in a new sheet.

âž¤ Now, select all the data from these two cells.

âž¤ Then go to the Insert ribbon and select any format from the Charts section.

So, a graph will appear in the sheet containing slope values and x values.

Read More: How to Find Instantaneous Slope on Excel

## Conclusion

So, we have shown you how to calculate the slope of the exponential function in Excel. We hope you found the content of this article useful. If you have further queries or suggestions regarding this procedure please leave them in the comment section.

## Related Articles

<< Go Back toÂ Excel SLOPE Function | Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sourav Kundu

Sourav Kundu, BSc, Naval Architecture & Marine Engineering, Bangladesh University of Engineering and Technology, is a dedicated technical content creator of the ExcelDemy project. He has a keen interest in Excel and he leverages his problem-solving skills to provide solutions on user interface with Excel. In his position as an Excel & VBA Content Developer at ExcelDemy, Sourav Kundu not only adeptly addresses challenging issues but also demonstrates enthusiasm and expertise in navigating complex situations. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF