How to Make a Log Scale Graph in Excel

A standard graph is great until your data includes a few outlier values that are dramatically larger than everything else, squashing the rest of your chart into an unreadable flat line. This is where a logarithmic scale comes in. Instead of showing absolute numbers in evenly-spaced increments, a logarithmic (or log) scale shows magnitudes, making it perfect for visualizing data that spans a very wide range. This article will walk you through what a log scale is, when to use one, and exactly how to create one in Excel.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Is a Logarithmic Scale?

To understand a log scale, it helps to first think about a normal, or linear, scale. On a linear scale, the distance between tick marks is a constant, absolute value. The distance between 10 and 20 is the same as the distance between 90 and 100 - each represents an increase of 10 units.

A logarithmic scale, on the other hand, spaces its tick marks by factors of a certain number (called the "base"), which is almost always 10. So instead of increments like 10, 20, 30, 40, a log scale axis will show 1, 10, 100, 1000, 10,000. Each major gridline is 10 times larger than the previous one.

This simple change has a huge effect: it lets you visualize a massive range of values in a single, compact chart without letting huge values obscure the smaller ones. For example, on a linear chart showing a village (population 100) and Tokyo (population 37 million), the village's data point would be invisibly close to zero. On a log scale, both are clearly visible because the scale focuses on their order of magnitude.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

When Should You Use a Log Scale?

Log scales aren't for every situation, but they are incredibly useful in specific scenarios. You should consider using one when:

• Your data has a very wide range. This is the most common use case. If you have values that are 10x, 100x, or 1000x different from each other (e.g., website traffic, followers on social media accounts, national GDPs), a log scale helps you see everything clearly.
• You care about percentage change or growth rate. On a log scale, a straight, upward-sloping line represents a constant rate of growth (exponential growth). If the slope is steepening, the growth rate is accelerating. If it's flattening, it's decelerating. On a linear scale, exponential growth just looks like a curve that goes almost vertical, making it hard to see changes in the rate.
• You are visualizing data that grows exponentially. Things like compound interest, viral spread, or a startup's user base in its early days are often best shown on a log scale to make the underlying trend visible.

When a Log Scale Isn't the Right Choice

Log scales are powerful but can also be misleading if used improperly. Avoid them when:

• Your data includes zeros or negative values. The logarithm of zero or a negative number is undefined. Excel won't even let you create a log scale if your data set for that axis contains them (more on this in the troubleshooting section).
• The range of your data is narrow. If your data points are all within the same order of magnitude (e.g., values range from 200 to 900), a log scale will distort the visualization and make it harder to see the true differences. A linear scale is much better here.
• You need to emphasize absolute differences. A log scale highlights percentage changes. If the actual raw number difference is what's most important (e.g., departmental budgets where a $10,000 difference is significant), stick to a linear scale.

How to Make a Log Scale Graph in Excel: A Step-by-Step Guide

Creating a log scale chart in Excel is surprisingly simple. You just need to create a regular chart first and then flip a switch in the settings. Let's walk through it with an example looking at monthly website users, where a viral event caused a massive spike.

Here’s our sample data:

Step 1: Create a Standard Line or Column Chart

Before you can apply a log scale, you first need a regular chart. Excel commonly uses Line, Column, or Bar charts for this kind of time-series data.

1. Highlight the entire data range, including the headers (in our case, cell A1 to B13).
2. Go to the Insert tab on the ribbon.
3. In the Charts group, click on the icon for 'Insert Line or Area Chart' and choose a simple 2-D line chart.

You'll immediately get a chart. But looking at it, there’s a problem. The huge user numbers in August and September create a massive spike that makes the trend for the rest of the year look like a flat, meaningless line near the bottom. You can’t tell what was happening from January to July at all.

This is the exact type of problem a logarithmic scale is designed to solve.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Change the Axis to a Logarithmic Scale

Now, let’s convert the vertical (Y) axis to a log scale. This axis represents the number of users, which has a wide range of values.

1. Right-click on the numbers on the vertical axis (the Y-axis). This is the key step - don’t right-click the gridlines or the plot area, but the axis labels themselves.
2. From the context menu that appears, select Format Axis....
3. This will open up the Format Axis pane on the right side of your Excel window.
4. Underneath Axis Options (make sure the bar chart icon is selected at the top), you'll see a series of settings. Simply check the box next to Logarithmic scale.

Instantly, your chart transforms! The Y-axis values will change from 0, 5000, 10000, to 100, 1000, 10000, 100000. Now you can clearly see the steady growth happening in the first half of the year, as well as the major spike toward the end. You haven't lost the big picture, but you've regained the details of the smaller values.

Step 3: Customize and Clean Up Your Log Scale Chart

After switching to a log scale, you might want to make a few tweaks to make it even cleaner and easier to read.

• Setting the base: In the Format Axis pane, the Base for the logarithmic scale defaults to 10. Stick with this unless you have a very specific technical reason to change it. Base 10 is standard and easiest for most people to understand.
• Adjusting the bounds: The chart might start its axis at 1 or 100. Our lowest data point is 980. To make the chart look cleaner, we could set the minimum bound. Find the Minimum box under Bounds and type in 1000. This will make the chart start at 1000 and zoom in on your data.
• Add labels: Always label your chart! Give it a clear title like "Monthly Website Users (Logarithmic Scale)" to prevent confusion. Add a title for the Y-axis as well, such as "Number of Users". Good labeling is critical when using a non-standard scale.

How to Interpret a Log Scale Correctly

Making the chart is one thing, reading it is another. Because the scale is distorted, you have to read it differently from a linear chart.

• Focus on proportional, not absolute, changes. Remember, the visual distance between 1,000 and 10,000 on the graph is the same as the distance between 100 and 1,000. Both represent a 10-fold increase. Don’t fall into the trap of thinking a move from 1,000 to 2,000 is a "smaller" jump than one from 20,000 to 30,000 - in real numbers, the latter is much bigger, but as a percentage, the former is huge (100% vs 50%).
• A straight line means exponential growth. This is the most important concept. If your data points form a relatively straight upward line on a log scale chart, the quantity is not growing by a fixed amount each period, but rather by a fixed percentage. For a business, this is a sign of healthy, compounding growth.
• Changes in slope indicate changes in growth rate. If the line gets steeper, your growth rate is accelerating. If the line starts to level off and becomes less steep, your growth rate is slowing down.

Common Problems and Troubleshooting

"The Logarithmic scale checkbox is grayed out!"

This is the most common issue. Excel grays out the option if your data for that axis contains zero (0) or any negative numbers. You can't take the logarithm of these values, so Excel disables the feature.

Solution: You have two options.

1. Filter out the data: If the zeros or negative values are errors or aren't important, simply remove them from your source data.
2. Replace the value: If a zero value represents something meaningful but just needs to be displayed (e.g., zero sales on a holiday), you can replace it with a non-zero value, such as 0.1 or #N/A. The data point won't be plotted, but the rest of your log scale will work.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

"Viewers are confused by my chart."

Log scales are not as intuitive as linear scales for everyone. A steeply rising line can look alarming even if it just represents steady percentage growth.

Solution: Over-communicate. Add a prominent note in your chart title or in a text box on the chart itself that says, “Vertical axis uses a logarithmic scale to show rate of change.” When presenting the data, take a moment to explain what the scale means and what the audience should be looking for.

Final Thoughts

Making a log scale graph in Excel is a straightforward process that can completely change how you see your data. It's the perfect tool for taming wide-ranging numbers and shifting your focus from absolute growth to the rate of growth, allowing you to see the underlying trends that spikes and outliers would otherwise hide.

Manually creating charts like this in Excel, especially when pulling data from different marketing or sales platforms, is exactly the kind of repetitive work that eats into your day. We built Graphed to automate these tedious tasks. Instead of exporting CSVs and navigating Excel's formatting menus, you connect your data sources directly and ask for what you need in plain English - like "create a line chart showing our monthly users from Google Analytics on a logarithmic scale." We handle the rest, delivering real-time dashboards in seconds so you can spend less time wrangling data and more time acting on it.