How to Add a Logarithmic Trendline on Excel

Adding a logarithmic trendline to a chart in Excel is a powerful way to visualize data that climbs or falls sharply before slowing down. This simple tool helps you understand patterns, from viral marketing campaigns to user learning curves, right within your spreadsheet. This article will walk you through exactly how to create, customize, and interpret a logarithmic trendline in Excel.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly is a Logarithmic Trendline?

Think of a logarithmic trendline as a special type of "best-fit" line for your data. Instead of being a straight line, it's a curve that’s particularly good at describing phenomena that experience rapid change initially and then start to level off. This pattern is common in many business and natural scenarios.

For example, imagine you launch a new mobile app:

• Week 1: Your user base explodes thanks to an early-adopter rush. The growth curve is very steep.
• Week 4: Growth continues, but slows as the initial excitement fades and you penetrate more of your target market.
• Week 8: New sign-ups continue at a much steadier, more predictable pace. The growth curve has flattened out considerably.

A logarithmic trendline is perfectly suited to model this type of growth. Other common examples include:

• Learning a new skill: You make rapid progress in the beginning, but the journey from "good" to "expert" takes much longer.
• Website traffic after a major press feature: A surge of visitors floods your site, followed by a gradual decay to a new, higher baseline of traffic.
• Population growth in a constrained environment: A species' population expands quickly with abundant resources, then slows as resources become scarcer.

The mathematical formula Excel uses is y = c ln(x) + b, where 'ln' stands for the natural logarithm. You don't need to be a math whiz to use it, but knowing the basic concept helps you recognize when it’s the right tool for the job.

When Should You Use a Logarithmic Trendline?

Before adding one to your chart, it's helpful to know if it's the right choice for your data. A logarithmic trendline works best when your data follows a few simple rules.

Signs That a Logarithmic Trendline Is a Good Fit:

• The rate of change in your data is decreasing. Look for a pattern of steep initial gains (or losses) that gradually become smaller over time.
• All the values on your x-axis (your independent variable) are positive. Because the logarithm of a non-positive number is undefined, Excel won't be able to calculate the trendline if your x-values include zero or negative numbers.
• You have a theoretical reason to believe the relationship follows this curve. For instance, concepts like the "law of diminishing returns" often follow logarithmic patterns.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Logarithmic vs. Other Common Trendlines

How does it compare to other options in Excel?

• Linear: Use this for data that shows a steady, constant rate of increase or decrease. Think of it as a straight line. Example: Total sales that increase by roughly $1,000 every month.
• Exponential: This is the opposite of logarithmic. It models data that starts slow and then grows at an increasingly rapid rate. Think "hockey stick" growth. Example: The spread of a viral video.
• Polynomial: This is a more complex curve that can have multiple “humps” or “valleys.” It's useful for datasets that fluctuate, like analyzing the relationship between temperature and energy consumption throughout a day.

If your data curves and then flattens, logarithmic is likely your best bet.

Preparing Your Data for the Chart

Clean, organized data is the foundation of any good analysis. Before creating your chart, make sure your data is set up in a simple, two-column format. Your independent variable (the x-axis) should be in the first column, and your dependent variable (the y-axis) should be in the second.

For our example, let's track the monthly active users (MAUs) for a new software product in the first 12 months after launch.

Sample Data: Monthly Active Users vs. Month

In this classic example, growth is huge in the early months (2500 to 4800) but much smaller in the later months (11200 to 11350). This is a perfect candidate for a logarithmic trendline.

Step-by-Step Guide: How to Add a Logarithmic Trendline

With your data prepped, adding the trendline only takes a few clicks. We'll use our MAU data from above.

Step 1: Create a Scatter Plot or Line Chart

A scatter plot is the most common choice for visualizing relationships between two variables.

1. Highlight your entire data range, including the headers (e.g., A1:B13).
2. Go to the Insert tab on Excel's ribbon.
3. In the Charts section, click on the icon for Insert Scatter (X, Y) or Bubble Chart.
4. Select the first option, Scatter.

Excel will instantly generate a chart that visually represents your data points.

Step 2: Add a Trendline to Your Chart

Once your chart is created, you can add the trendline element.

1. Click anywhere on your new chart to select it. You will see a green “+” icon appear at the top-right corner. This is the Chart Elements shortcut.
2. Click the “+” icon.
3. From the menu that appears, check the box next to Trendline. Excel will add a default linear trendline by default.

Step 3: Change Trendline Type to Logarithmic

Now we’ll specify that you want a logarithmic trendline, not the default linear one.

1. In that same Chart Elements menu, hover over Trendline and click the small black arrow that appears on the right.
2. Click More Options…. This will open the Format Trendline pane on the right side of your screen.
3. In the Trendline Options section (represented by a green bar chart icon), select Logarithmic.

Your chart will immediately update, replacing the straight line with a curve that fits your data much better.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Making Sense of Your Trendline: Customization and Interpretation

Creating the line is half the battle, the other half is using it to gain insights. The Format Trendline pane gives you some powerful tools to help with this.

Display the Trendline Equation

In the Format Trendline pane, scroll down and check the box that says Display Equation on chart. An equation in the format of y = [c]ln(x) + [b] will appear on your chart. In our example, it will be something like y = 2496.2ln(x) + 2642.5.

• y: Represents the predicted MAUs.
• x: Represents the Month.
• So, if you wanted to predict users in month 7, you could calculate: 2496.2 * ln(7) + 2642.5. This equation is the engine behind your forecast.

Display the R-squared Value

This is arguably the most important metric for evaluating your trendline. Directly below the equation option, check the box for Display R-squared value on chart.

R-squared, or the "coefficient of determination," is a number between 0 and 1 that measures how well the trendline fits your actual data points.

• An R-squared of 1 means the trendline is a perfect fit.
• An R-squared of 0.98 (like in our example) is an extremely strong fit.
• An R-squared of 0.6 suggests the model is a poor fit, and a logarithmic curve may not be the right way to describe your data.

This single value tells you how much confidence you can place in your trendline's predictions.

Extend the Trendline to Forecast the Future

What if you want to predict your MAUs for a few more months? Excel can do this easily.

1. Back in the Format Trendline pane, look for the Forecast section.
2. In the Forward box, type the number of periods you want to predict. For our example, if we enter 3, the trendline will extend out to Month 15.

This is a quick way to create projections based on the observed pattern. Just remember, the further out you forecast, the less reliable the prediction becomes. It's a guide, not a guarantee.

Common Problems and How to Fix Them

Sometimes things don't go as planned. Here are a couple of common issues and their solutions.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Problem: The "Logarithmic" Option is Grayed Out

If you can't select the logarithmic option, the cause is almost always your x-axis data. The logarithmic function is undefined for values that are zero or negative.

The Fix: Check your x-axis column. If you have "Month 0" or any negative entries, change them to be positive values (e.g., start with Month 1). As soon as you remove any non-positive x-values, the option will become available.

Problem: The Trendline is a Poor Fit (Low R-Squared)

If you add the trendline and get a low R-squared value (e.g., less than 0.8), it doesn't mean you did anything wrong. It just means the relationship in your data isn't logarithmic.

The Fix: Go back to the Format Trendline pane and experiment with other trendline types. Try Linear, Exponential, or Polynomial (degree 2 is a good start). Check the R-squared value for each one to find the model that best describes the true pattern in your data.

Final Thoughts

Creating a logarithmic trendline in Excel is an effective way to model and forecast data that displays rapid early growth or decline before leveling out. By moving beyond a simple linear trendline, you can gain a much more accurate understanding of the patterns in your business, from user growth to marketing effectiveness.

While mastering an analysis technique in Excel is valuable, we know it can be time-consuming to prepare data and format charts just right. We created Graphed to remove that friction. It lets you connect directly to your data sources - like Google Analytics or Shopify - and get insights using plain English. Instead of building a chart and trendline step-by-step, you could simply ask, "show daily user growth for the past 60 days with a logarithmic trendline" and get an interactive, real-time chart instantly.