How to Make a Semi Log Graph in Google Sheets

When you're trying to visualize data that spans a huge range of values, a standard line chart can quickly become useless. If one data point is 1,000,000 and the next is only 1,000, the smaller value gets squished down to the x-axis, making trends completely unreadable. This is where a semi-log graph comes to the rescue. This article will show you exactly what a semi-log graph is, when to use one, and how to create it step-by-step in Google Sheets.

First, What is a Semi-Log Graph?

A semi-log graph (or semi-logarithmic plot) is a chart where one axis uses a logarithmic scale and the other uses a standard, linear scale. In most business cases, the vertical (Y) axis is logarithmic, while the horizontal (X) axis remains linear.

So, what does that actually mean?

• A linear scale is what you’re used to seeing. Each tick mark represents an equal increment. The distance between 10 and 20 is the same as the distance between 90 and 100. It's a scale based on addition.
• A logarithmic scale is a scale based on multiplication. Instead of equal increments, each major tick mark is a multiple of the one before it, typically by a factor of 10. The scale goes from 1, to 10, to 100, to 1,000, and so on. The distance between 1 and 10 is the same as the distance between 10 and 100.

By using a logarithmic scale for our values, we can easily display an enormous range of data without the smaller values becoming invisible.

When to Use a Semi-Log Graph (And When Not To)

Making a semi-log graph is easy, but knowing why you're making one is what generates powerful insights. Here are the two most common and effective scenarios for using one.

1. Visualizing Data with a Massive Range

This is the most straightforward use case. Imagine you're tracking monthly website traffic. For eleven months, you get between 10,000 and 20,000 users. But in the final month, one of your articles goes viral and you get 500,000 users.

On a normal linear line chart, it would look like this:

Eleven months would be a flat, unreadable line crushed against the bottom of the chart, followed by a giant, vertical spike for the viral month. You wouldn't be able to see any of the smaller, but still important, variations in traffic from month to month before the spike. Everything is distorted by the one major outlier.

A semi-log graph solves this perfectly. By plotting traffic on the logarithmic Y-axis, the difference between 10,000 and 20,000 is still clearly visible, even when the chart also contains a point at 500,000.

2. Highlighting Rates of Change (Not Just Absolute Values)

This is the secret superpower of semi-log graphs. Because the scale is based on multiplication, a straight line on a semi-log chart indicates a constant rate of change (or percentage growth).

Let's say you're comparing the growth of two products:

• Product A grows from 100 users to 200 users (+100 users).
• Product B grows from 1,000 users to 1,100 users (+100 users).

On a linear chart, these would both appear as lines with the same slope because the absolute increase is identical (+100 users). But that misses the story! Product A doubled its user base (100% growth), while Product B only grew by 10%. A semi-log graph shows this difference in growth rate. The line for Product A would be much steeper than the line for Product B, instantly telling you which one is growing faster proportionally.

When to Stick with a Linear Scale

A semi-log graph isn't always the right tool. Avoid it when:

• Your data contains zeros or negative numbers. Logarithmic scales can't display these values, and your chart will either break or simply omit them.
• You need to show absolute differences. If the real story is that both Product A and Product B added exactly 100 users, a linear chart tells that story best.
• Your data doesn’t have a wide range. If all your values are relatively close, a log scale will just make them harder to read and compare.

Step-by-Step: How to Make a Semi-Log Graph in Google Sheets

Ready to build one? The process is surprisingly straightforward. We’ll use a common business example: tracking the exponential user growth of a new startup.

Step 1: Get Your Data Ready

First, make sure your data is organized in two columns. For our example, we'll have a Month column (our X-axis) and a Total Users column (our Y-axis).

Notice how the user numbers grow slowly at first, and then accelerate - a perfect candidate for a semi-log plot.

Here’s our sample data:

Month | Total Users 1 | 100 2 | 160 3 | 250 4 | 410 5 | 650 6 | 1,000 7 | 1,500 8 | 2,700 9 | 7,100 10 | 12,000 11 | 35,000 12 | 80,000

Step 2: Insert a Standard Chart

Click and drag to select all of your data, including the headers.

Next, go to the top menu and click Insert > Chart. Google Sheets will probably default to a line or column chart, which is what we want. On this initial linear chart, you'll see the early growth looks tiny and the later growth shoots up in a classic "hockey stick" curve.

Step 3: Open the Chart Editor and Activate Log Scale

This is where the magic happens. Double-click anywhere on your chart to open the Chart editor on the right side of your screen.

1. Make sure you’re on the Customize tab.
2. Click to expand the Vertical axis section. Don't click Horizontal axis - we want our Y-axis to be logarithmic.
3. Scroll down a bit until you see a checkbox labeled Log scale.
4. Click that checkbox.

Instantly, your chart will transform. The Y-axis values will change to powers of 10 (100, 1,000, 10,000, 100,000), and your J-shaped curve will straighten out significantly.

Step 4: Customize Your Chart a Bit More

Your chart is now officially a semi-log graph. To make it more professional, consider these last few tweaks in the Chart editor:

• Titles and Labels: Under Chart & axis titles, give your chart a clear title like "Monthly User Growth (Semi-Log Scale)" and make sure your horizontal and vertical axis titles are labeled correctly ("Month" and "Users").
• Gridlines: Log scales can get a little tricky to read. Under Gridlines and ticks, you can add minor gridlines to help the eye pinpoint values between the major lines (like 200, 300, 400...). This can add a lot of clarity.

How to Read Your New Semi-Log Graph

Creating the graph is just half the battle. Interpreting it correctly is what provides real value. Here’s what to look for:

• A Straight Line: Remember our superpower? A straight line (or something close to it) means you have a steady rate of proportional growth. In our example, the line is nearly straight, which tells us that the monthly percentage growth rate was remarkably consistent, even as the absolute number of new users per month was soaring.
• An Upward Curving Line: If the line bends upward and gets steeper, your growth rate is accelerating. This means your percentage growth is increasing month-over-month. You're not just growing, you're growing faster.
• A Flattening Line: If the line starts to level off (becomes less steep), your growth rate is decelerating. You might still be adding users, but the percentage increase is shrinking over time.

Suddenly, what was a simple hockey-stick curve is now a story about the consistency of our growth engine. We can see the period where growth was strongest and spot if things start to slow down, allowing us to ask better questions and take action sooner.

Final Thoughts

You've now learned that a semi-log graph is an invaluable tool for visualizing exponential growth, comparing data with a massive range, and understanding rates of change. By simply checking the "Log scale" box in Google Sheets, you can unlock a much deeper and more accurate view of your data's true story.

The manual process of wrangling data in spreadsheets is a necessary skill, but as your data gets more complex and scattered across platforms like Google Analytics, HubSpot, or Shopify, it becomes exhausting. The frustration of exporting CSV files and fiddling with chart settings is exactly why we created Graphed. Here, we automate all that. You just connect your sources, ask your questions using plain English, and Graphed instantly builds the live, interactive dashboards you need, giving you back hours of your day.