Google Sheets Log Scale Charts: Setup and Troubleshooting

Charts & pivot tables · Updated November 21, 2026

To make a log scale chart in Google Sheets, select your data, choose Insert > Chart, then open Customize in the Chart editor and turn on Log scale under Vertical axis. For a scatter chart, check the Horizontal axis settings as well if you need the x-axis to be logarithmic. The option changes the axis spacing, not the values in your sheet, and the values plotted on a logarithmic axis must be positive.

What a logarithmic chart shows

A linear axis spaces marks by equal differences: 0, 10, 20, 30, for example. A logarithmic, or log, axis spaces marks by equal ratios instead. On a base-10 scale, marks might represent 1, 10, 100, and 1,000. The distance from 1 to 10 is therefore the same as the distance from 100 to 1,000, even though those intervals differ greatly in their numerical size.

This makes a log scale useful when data spans several orders of magnitude, meaning that some values are many times larger than others. A linear chart of values ranging from 2 to 2,000 may compress the small values close to the bottom of the plot. A logarithmic axis can spread the low and high ranges across the chart so their patterns are easier to compare.

The chart still represents the original values. A point positioned at 100 is labeled as 100, not as 2, even though 100 is 10 to the power of 2. In other words, enabling the axis setting is different from calculating logarithms in a helper column and charting those transformed results.

How to set up the chart

In Google Sheets in a web browser, prepare a data range with clear headers and numeric values, select it, and choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually at the right of the sheet. Under Setup, choose an appropriate chart type if Sheets has not selected one for you. Then use Customize to find the axis controls.

  1. Click the chart, then open the Chart editor if it is not already visible.
  2. Select Customize and expand Vertical axis.
  3. Turn on Log scale. If the chart type offers the setting for a horizontal numeric axis and that axis also needs logarithmic spacing, expand Horizontal axis and turn it on there.
  4. Review the chart’s axis limits, labels, and plotted data. Adjust the minimum or maximum only when doing so helps the comparison and does not hide relevant values.

For a scatter chart, the first column commonly supplies x-values and the next column supplies y-values. A table such as x-values of 1, 10, 100, and 1,000 with corresponding y-values of 3, 8, 20, and 60 makes it possible to see how y changes as x increases by repeated factors of ten. It is not the same as a chart where the x-axis is simply a list of category labels. For a line or column chart, the numeric value axis is usually the vertical axis, so that is the axis to inspect first.

The chart editor’s available controls depend on the chart type and which axis is numeric. If you cannot find Log scale, try a chart type with a numeric axis, such as a scatter chart for two numeric variables, and inspect the relevant axis section again. Sheets may not expose the same axis options for every chart configuration.

When a log scale is a good choice

Consider a log axis when comparing growth patterns or measurements that vary by large factors rather than by small, consistent amounts. Examples include a time series that grows from tens to thousands, measurements across microscopic and macroscopic ranges, or a scatter plot where x-values span several powers of ten. In those cases, a linear scale may make the smaller values difficult to distinguish.

A log scale can also help compare proportional change. Moving from 10 to 20 is a doubling, as is moving from 100 to 200. Those equal ratios occupy equal distances on a logarithmic axis. That can make multiplicative patterns, such as repeated doubling, more visually apparent than they are on a linear axis.

It is not automatically better for data with a wide range. If readers need to compare absolute differences, a linear axis may be more direct. A change from 10 to 20 is 10 units, while a change from 100 to 110 is also 10 units; those equal differences are not shown as equal distances on a log axis. Choose the scale according to the question the chart should answer, and label the axis or caption clearly so readers know what they are seeing.

Values a logarithmic axis cannot display

Zero and negative numbers are not defined on an ordinary logarithmic scale. If a plotted series includes either, the chart may omit those points, fail to display the desired axis, or behave differently from what you expect. Check the source range for blanks, zeros, negative values, and numbers stored as text if points disappear or the scale option is unavailable.

Do not replace zero with a small positive number without a sound reason. That changes the data and can make a chart imply a value that was never measured. If zero is meaningful, consider keeping a linear axis, separating zero-valued observations from the positive range, or making a second chart for the positive values. If a measurement is below a detection limit, represent that fact honestly rather than treating it as an exact positive observation.

Negative data also needs a different treatment if both signs matter. A standard log axis cannot show a continuous range that includes negative values and zero. A linear chart or separate views may communicate the information more faithfully than trying to force all values onto a conventional logarithmic axis.

Choose the chart type and axis carefully

Use a scatter chart when both variables are numeric and the spacing between x-values matters. This is often the clearest way to show a relationship across a log-scaled x-axis. A line chart can be suitable for ordered observations, such as dates, when the vertical values need logarithmic spacing. A column chart may work for positive quantities with a broad range, but its bars and baseline can be less intuitive on a log axis than on a linear one.

Check which axis is being scaled. In a column chart, the vertical axis generally measures values, while the horizontal axis names categories. In a bar chart, the orientation is reversed: the numerical values are typically horizontal. A setting applied to the wrong axis will not solve the problem you are trying to show. With a scatter chart, both axes represent numbers, so either axis may be relevant if Sheets provides the control for it.

Before settling on a chart, ask what the reader should compare:

  • Use a linear axis when equal absolute differences should have equal visual distances.
  • Use a logarithmic axis when multiplicative changes or values spanning several orders of magnitude are central.
  • Use a scatter chart when the relationship between two numeric variables matters.
  • Use a table alongside the chart when exact values are important and the scale may be unfamiliar.

Common problems and fixes

The Log scale option is missing. Confirm that you are in the Chart editor’s Customize tab and have expanded the axis section. Then check whether the selected chart has a numeric axis that supports the setting. Switching to a scatter chart can help when the horizontal variable is numeric. Also check that the chart is using the intended data range rather than a text column in place of numeric values.

Some points or bars vanish. Inspect the source values for zeros and negatives, which cannot be placed on an ordinary log axis. Check for blanks or numbers stored as text as well. If the data includes legitimate zero values, do not quietly convert them into tiny positive values just to make them appear.

The chart looks dramatically different after changing the scale. That is expected: equal visual steps now represent equal ratios, not equal differences. Read the tick labels rather than estimating values from the apparent height alone. If the scale makes the result harder to explain to the intended audience, return to a linear axis or add a note explaining the logarithmic spacing.

The smallest values are still hard to see. Review the chart’s minimum and maximum axis bounds, if available, and make sure they include the data you want to compare. A very large upper value can still affect the visual distribution. You can also use a separate chart for a narrower range, provided the change in scope is made clear and does not conceal important context.

The axis labels do not show every power of ten. A chart may limit tick labels to keep them legible. That does not necessarily mean the scale is linear or incorrect. Use the labeled values and the positions of the points to interpret the graph; avoid adding manual labels that could be mistaken for the chart’s actual axis ticks.

How to explain the scale to readers

Label the axis with the measured quantity and its units, then state that it uses a logarithmic scale in a subtitle, chart note, or nearby text. For example, a vertical label could identify concentration in milligrams per liter, while a note says the vertical axis is logarithmic. This helps prevent the common misreading that equal vertical distances represent equal additions of the measured quantity.

When sharing a chart, include enough context to interpret the range. A reader should be able to tell whether the values are raw measurements, whether any zero or negative observations were excluded, and why a log scale helps answer the question. If the chart is used to compare groups, use the same axis limits and scale across the charts where possible; otherwise, visual comparisons between panels can be misleading.

Frequently Asked Questions

Can Google Sheets make a log scale chart?
Yes. Insert a chart, open Customize in the Chart editor, and enable Log scale in the relevant axis section when the chart type supports it. The setting changes the chart axis, not the values stored in the cells.

Can a Google Sheets log scale include zero?
No. A conventional logarithmic axis cannot represent zero or negative values. Keep a linear scale or choose another honest way to present those observations rather than substituting an invented positive value.

Can I make the x-axis logarithmic in Google Sheets?
For a chart with a numeric horizontal axis, such as a scatter chart, inspect Customize > Horizontal axis for a Log scale control. Whether the control appears depends on the chart configuration and available axis options.

Does a log scale change my spreadsheet data?
No. It changes how the chart positions values along an axis. The cells continue to contain the original numbers, and their displayed values are not converted into logarithms.

Should I use a logarithmic or linear chart?
Use a logarithmic scale when ratios, multiplicative growth, or a very broad range are important. Use a linear scale when readers should compare equal absolute differences. If the choice could surprise readers, label the scale and consider showing exact values in a table too.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.