How to Make a Logarithmic Graph in Google Sheets
Sometimes your data just doesn't fit neatly on a standard graph. When some values are massive and others are tiny, a regular line or bar chart can flatten all the important details at the low end, making them impossible to see. This is where a logarithmic scale comes in. This tutorial will walk you through exactly what a logarithmic graph is, when to use one, and how to create one in Google Sheets step-by-step.
What is a Logarithmic Scale, Anyway?
In most charts you create - what's known as a linear scale - the distance between gridlines is equal. The space between 10 and 20 is the same as the space between 90 and 100. It's consistent and easy to read for most datasets.
A logarithmic scale, however, works differently. Instead of equal increments, the scale is based on orders of magnitude - typically powers of 10. So, the distance between 1 and 10 is the same as the distance between 10 and 100, which is the same as the distance between 100 and 1000, and so on. Each major gridline represents a 10x increase from the one before it.
Why is this useful? It has two major benefits:
- It helps visualize datasets with a huge range. Imagine you're tracking website traffic. One month you had 500 visitors, but the next month a blog post went viral and you had 500,000 visitors. On a linear chart, the 500-visitor mark would be so close to zero it would be invisible. A log scale compresses the high end of the scale, allowing you to see both the small and the enormous values clearly on the same chart.
- It highlights percentage change. On a log scale, a straight line represents a constant rate of exponential growth. A movement from 10 to 20 (a 100% increase) looks just as big as a movement from 1,000 to 2,000 (also a 100% increase). This makes it incredibly effective for seeing the rate of change, rather than just the absolute change in numbers.
When Should You Use a Logarithmic Graph?
Log scales aren't for every situation. They can be confusing if your audience isn't familiar with them. But in the right context, they provide insights that a linear scale would completely hide. Here are the best times to use one:
- When your data covers several orders of magnitude. This is the classic use case. Think of topics like stock prices over decades, Moore's Law, earthquake magnitudes (the Richter scale is logarithmic!), or population growth.
- When you have exponential growth. If something is doubling every period (like user growth for a new app), a linear chart will show a dramatic, curving "hockey stick" line. A semi-log chart (where only the Y-axis is logarithmic) will turn that curve into a straight line, making it much easier to see if the growth rate is consistent, accelerating, or slowing down.
- When you are comparing relative change, not absolute. If you're comparing the growth of a small startup to a massive corporation, a log scale is ideal. A $10,000 increase in revenue is huge for the startup but a rounding error for the corporation. A log scale puts their growth in perspective by focusing on percentage changes.
- When looking for relationships in scientific or financial data. Many natural phenomena and market behaviors follow logarithmic patterns. Plotting them this way can reveal underlying trends that wouldn't be obvious otherwise.
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
How to Make a Logarithmic Graph in Google Sheets: A Step-by-Step Guide
Creating a logarithmic graph in Google Sheets is surprisingly simple. You'll start by making a regular chart and then just flip a switch in the settings. Let's walk through it with an example.
Imagine we're tracking the monthly active users for a new mobile game over its first year. The growth was slow at first, then exploded.
Step 1: Set Up Your Data
First, enter your data into two columns in Google Sheets. Column A will be our X-axis (the time period), and column B will be our Y-axis (the corresponding value). Don't leave any blanks in the value column.
Here's our sample data for monthly users:
Month | Users
-------------------
Jan | 120
Feb | 150
Mar | 210
Apr | 350
May | 800
Jun | 2,500
Jul | 8,000
Aug | 22,000
Sep | 65,000
Oct | 110,000
Nov | 250,000
Dec | 520,000Step 2: Insert a Standard Chart
Click and drag your mouse to highlight all the data you just entered, including the headers ("Month" and "Users").
Next, go to the menu and click Insert > Chart. Google Sheets will automatically analyze your data and create a default chart - in this case, probably a line chart.
At this point, you'll have a standard linear chart. If you look at our example data, you'll see a classic "hockey stick" curve. The first few months are totally flat near the bottom, while the end of the year shoots up dramatically. You can't see any of the nuance from January to May.
Step 3: Open the Chart Editor and Customize the Axis
Now for the key step. Double-click anywhere on the chart. This will open the Chart editor sidebar on the right side of your screen. If it doesn't appear, you can also left-click on the chart, then click the three vertical dots in the top-right corner of the chart and select "Edit chart."
In the Chart editor sidebar, click on the Customize tab. This gives you access to all the styling and formatting options for your graph.
Find and click on the Vertical axis section to expand it. This is where you control everything about how the Y-axis (in our case, the "Users" axis) is displayed.
Step 4: Check the "Log scale" Box
Scroll down a bit within the Vertical axis options. You'll see a checkbox labeled Log scale.
Click it.
Instantly, your chart will transform. The Y-axis values will change from 0, 100,000, 200,000, etc., to 10, 100, 1,000, 10,000, and so on. The "hockey stick" curve will mellow into a more detailed, readable line, allowing you to actually see and compare the growth in the early months. That's it! You've created a logarithmic graph.
Customizing and Reading Your Log Chart
Just creating the chart isn't the final step. Now you need to make sure it's easy to understand.
Interpreting the Scale
Remember, a straight diagonal line on your log plot doesn't mean steady growth in numbers - it means a steady percentage growth. If the line gets steeper, the percentage growth is accelerating. If it gets flatter, the growth rate is slowing down, even if the absolute number of new users is still increasing.
Add Gridlines for Clarity
Because the scale is now non-linear, gridlines are more important than ever. In the Chart editor, go to the Gridlines and ticks section.
- Select "Vertical axis" from the dropdown.
- You can add a Major gridline count to help define the major powers of 10. A setting of 'Auto' often works well.
- Even more helpful is setting a Minor gridline count. Setting this to 9 will place nine minor lines between each major power of 10 (e.g., between 1,000 and 10,000, you'll get lines for 2000, 3000,... 9000). This can make it much easier to estimate values between the major lines. Note that these minor lines won't be evenly spaced - they'll get closer together as they approach the next power of 10.
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
Always Label Your Chart Clearly
Since a log scale can be easily misinterpreted, you should always label your chart explicitly. Use the Chart & axis titles section in the editor to make sure your audience knows what they're looking at. For example, you might change the Vertical axis title from "Users" to "Users (Log Scale)" to remove all doubt.
Common Mistakes to Avoid
Logarithmic scales are powerful, but they come with a couple of critical limitations.
- Zero Values: The logarithm of zero is undefined. If your dataset contains any '0' values, Google Sheets won't be able to plot them on a log scale. It will simply skip them, which can create misleading gaps or straight lines in your chart. If you must show zero values, a log scale is not the right choice.
- Negative Values: Similarly, you cannot take the logarithm of a negative number. If your data includes negative values (like profit/loss), the log scale will fail to plot them. Your axes can only be populated by positive numbers when using a log scale.
If your data spans from negative to positive with a wide range, you might consider a different type of visualization, such as a bar chart for comparison or simply keeping the linear scale and calling out specific trends with annotations.
Final Thoughts
Converting a standard chart to a logarithmic scale in Google Sheets is as simple as clicking a checkbox. This simple action can transform a confusing, skewed graph into an insightful visualization, especially when dealing with data that grows exponentially or spans a very wide range. By compressing large values and expanding small ones, it lets you see proportional relationships and growth rates you would otherwise miss.
Building charts, tinkering with axes, and formatting labels in spreadsheets can feel like a chore that slows down your analysis. We've found that the best insights come when you can ask questions and see the results instantly, which is why we built Graphed. Instead of hunting through menus, you can just ask in plain English, "Create a line chart of my monthly website traffic from Google Analytics on a log scale," and instantly get a live-updating dashboard that answers your question. It simplifies the reporting process so you can focus on the data itself, not the tool.
Related Articles
AI Agents for SEO and Marketing: The Complete 2026 Guide
The complete 2026 guide to AI agents for SEO and marketing — what they are, top use cases, the best platforms, real-world examples, and how to get started.
AI Agents for Marketing Analytics: The Complete 2026 Guide
The complete 2026 guide to AI agents for marketing analytics — what they are, how they differ from automation, 10 use cases, pitfalls, and how to start.
How to Build AI Agents for Marketing: A Practitioner's Guide From Someone Who Actually Ships Them
How to build AI agents for marketing in 2026 — a practitioner guide from someone who has shipped a dozen, with the lessons that actually cost time.