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 Logarithmic Graph in Excel (with Easy Steps)

In this article, you will learn how to find the slope of a logarithmic graph in Excel. When linear graphs are unable to provide meaningful insight into skewed and clustered datasets, log-log or natural log-log graphs are typically employed. It’s simple to make a logarithmic graph with Excel. However, if you’re having trouble making a log-log or natural log-log graph or a semi-logarithmic and finding the slope of that graph in Excel, this article might be a useful session for you to solve these kinds of problems.


Download Practice Workbook

You can download the practice workbook from the following download button.


Steps to Find Slope of Logarithmic Graph in Excel

By adjusting a few axis format variables in Excel, we can simply plot a log-log graph. Both axes in the log-log or natural log-log graph are really on a logarithmic scale. Similar to the equation y = c. xa, this graph illustrates whether the variables are in a constant power relationship. In this case, the X and Y are related by a power of ‘a’ as in the image below.

X and Y are related by a power of 'a'

  • However, the line should be nearly straight if a dataset derived from this equation is shown using a logarithmic scale.

dataset derived from this equation is shown using a logarithmic scale


⦿ Step 1: Create a Logarithmic Graph by Using the Charts Tool of Excel

  • We select the Scatter Chart from the Charts group under the Insert tab.

Create a Logarithmic Graph by Using Charts Tool of Excel

  • A fresh, blank chart will appear after that.
  • Next, you must do right-click on the chart and choose the command Select data from the context menu.

right-click on the chart and choose the command Select data

  • A new window titled Select Data Source will appear. Click the Add command icon in that window.

Click the Add command icon

  • We must choose the range of cells that we will use as data for the X-axis and the Y-axis in the following window.
  • Choose the cell address that currently has the cells and cell name in it to insert the title there.

Choose the cell address

  • Now click Ok like the image below.

click Ok

  • Right-click the mouse after clicking on the labels for the Horizontal Axis to generate the logarithmic graph.
  • Select Format Axis from the context menu.

Select Format Axis from the context menu

  • It will reveal a new side panel. Select the Logarithmic scale checkbox and enter Base 2.7 under the Axis Options in the Format Axis side panel.
  • Set Vertical Axis Crosses to Automatic as well.

Select the Logarithmic scale checkbox

  • Similar to the y-axis, check the Logarithmic scale checkbox for the x-axis under the Axis Options in the Format Axis side panel.

check the Logarithmic scale checkbox for the x-axis

Read More: How to Find the Slope of a Line in Excel (5 Easy Ways)


⦿ Step 2: Find the Slope of the Logarithmic Graph

  • Let’s say we have data that could fit the theoretical y = c. xa curve. The slope of a natural log-log plot is equal to the exponent a‘s value, which is calculated as
a=ln(y2)-ln(y1)/ln(x2)-ln(x1)
  • Now we will select Add Trendline to find the equation of our data like the image below.

Find the Slope of the Logarithmic Graph

  • Now we will select Exponential as our trendline like in the following image.

select Exponential as our trendline

  • After selecting Display Equation on Chart in the Trendline Options, we will get the equation shown below.
y = 12.484e0.7387x

Find the Slope of the Logarithmic Graph

  • After differentiating the equation, we will get the following equation to find the slope in each point of our x-value for this example the x-values are Day.
dy/dx=12.484 x 0.7387 x e0.7387x
  • Using the differential equation, we will get the slope in Excel like the following image.

Using the differential equation, we will get the slope in excel

The formula is as follows:

=12.484*0.7387*EXP(0.7387*B5)
  • Lastly, drag the fill handle down to complete the series.

Find the Slope of the Logarithmic Graph

Read More: How to Calculate Slope of Exponential Graph in Excel (Easy Steps)


Conclusion

Follow these steps and stages to find the slope of a logarithmic graph in excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section of our blog ExcelDemy.


Related Articles

Al Ikram Amit

Al Ikram Amit

Hi there. I am Amit, completed my study from BUET. Currently, I am working as an Excel & VBA Content Developer at ExcelDemy. Now you can see my articles in ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo