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.
- Click the chart, then open the Chart editor if it is not already visible.
- Select Customize and expand Vertical axis.
- 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.
- 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
- Why Can’t I Find an Excel File I Just Saved?
- Where Is the Ungroup Button in Excel?
- Unmerge Cells in Excel: Find the Command and Use It
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Waterfall Chart: Show a Total at the EndTo show a final total in an Excel waterfall chart, select the last bar, right-click it, and choose…
- Economics Charts and Graphs: How to Read ThemEconomics charts and graphs show relationships between economic variables, changes over time, and comparisons across people, places, or…
- Excel Pivot Table Divide by Zero Error: Causes and FixesAn Excel PivotTable’s #DIV/0! usually comes from a division formula in its source data or a calculated field…
- Excel Pivot Table: Show Only Filtered Data in Your Report?Yes. In Excel for Microsoft 365 on Windows, filter a PivotTable field using its dropdown, or add a…
- Creating a Power Pivot in Excel: Steps and TipsTo create a Power Pivot in Excel for Microsoft 365 on Windows, enable the Power Pivot add-in if…
- Excel Sparklines: Purpose, Types, and How to Use ThemExcel sparklines are tiny charts displayed inside worksheet cells. Their purpose is to show the shape or direction…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.