Excel Chart Logarithmic Scale: Setup and Troubleshooting

To add a logarithmic scale to an Excel chart in Microsoft 365 for Windows, select the chart’s numeric axis, right-click it, choose Format Axis, then under Axis Options select Logarithmic scale. Excel requires positive values on that axis; the option works on value axes, not ordinary category axes.

What a logarithmic scale means

A logarithmic axis spaces values according to their ratios rather than their differences. On a base-10 axis, the distance from 1 to 10 is the same as the distance from 10 to 100: each step represents a tenfold increase. On a linear axis, those distances would be 9 and 90 units respectively, so the second interval would take up ten times as much space.

The plotted values are still the original values. Excel does not replace your source data with logarithms when you select the option; it changes where values appear along the chart axis. Labels generally continue to show values such as 1, 10, and 100, rather than their logarithms, such as 0, 1, and 2. The axis base determines the ratio represented by each main step. Base 10 is a common choice, but another base can be entered in the axis settings.

This distinction matters when reading a chart. A movement from 10 to 20 and a movement from 100 to 200 are both a doubling, so they occupy equal distances on a logarithmic axis. They are not equal absolute increases: one adds 10 and the other adds 100.

When a log scale is useful

A logarithmic scale can make a chart easier to read when values span several orders of magnitude, or when relative change matters more than absolute change. Without it, a few large observations may compress smaller values against the bottom of a linear chart.

For example, imagine measurements of 0.5, 5, 50, and 500. A linear axis extending to 500 gives the first three values little vertical space. On a base-10 scale, each value is one step from the next, making the progression easier to see. The same approach is often useful for population sizes, concentrations, signal strength, and other positive measurements that grow multiplicatively.

It can also help compare growth rates. If two series increase by similar percentages but start at very different levels, a logarithmic vertical axis can make their proportional patterns easier to compare. It does not make every chart clearer, however. If the audience needs to compare absolute differences, a linear scale is often more intuitive.

Consider a log scale when data cover a wide range of positive values.
Consider it when equal percentage changes should have equal visual distances.
Prefer a linear scale when the key question is how many units separate observations.
Label the scale clearly so readers do not mistake equal spacing for equal numerical differences.

Choose a chart with a value axis

Excel applies logarithmic scaling to a value axis. An XY (scatter) chart is especially suitable when both the horizontal and vertical measurements are numeric. Scatter charts have value axes on both sides, so you can apply the scale to the horizontal axis, the vertical axis, or both, provided the values on each selected axis are positive.

A line chart typically uses a category axis horizontally and a value axis vertically. You can usually make its vertical value axis logarithmic, but the category axis is not a numeric value axis and cannot be set to a log scale. If the horizontal positions represent actual numerical intervals—for example, elapsed time with irregular gaps—use a scatter chart so Excel treats x-values as numbers rather than equally spaced categories.

Bar and column charts need extra care. Their bars normally imply a baseline of zero, but zero cannot appear on a logarithmic axis. Even if a particular chart setup exposes a logarithmic option for its value axis, the result may be confusing or unsuitable for comparing bar lengths. A scatter or line chart is often a better choice for positive data on a log scale.

How to turn it on in Excel for Windows

Select the chart, then click the numeric axis whose scale you want to change. Check that you selected the axis labels, not the chart area or a data series.
Right-click the selected axis and choose Format Axis. The Format Axis pane opens.
In the pane, select Axis Options, then select the Logarithmic scale checkbox.
Review the Base box. Excel commonly starts with base 10; change it only if another base suits the data and the intended interpretation.
If needed, set the axis minimum and maximum to positive values that make the important part of the data readable. Close the pane when finished.

For an XY scatter chart, repeat the process on the other axis if you want both axes logarithmic. Excel treats the two choices independently. If the checkbox is unavailable, confirm that the selected axis is a value axis and that the chart type supports the scale. A line chart’s horizontal category axis, for instance, is not eligible.

On Excel for Mac, select or Control-click the axis and open Format Axis; the chart-formatting pane provides the corresponding logarithmic option. Names and pane layout can vary slightly by release. Excel for the web has fewer chart-formatting controls than desktop Excel, so if the option is missing, open the workbook in the desktop app.

Set the base, bounds, and labels

The base controls how values are grouped into equal steps. Base 10 is familiar when the data change by factors of ten. A different base may be useful when the underlying process or audience naturally thinks in another ratio, but changing the base does not change the data or make an invalid value valid.

Axis bounds control the visible range. On a log axis, the minimum must be greater than zero. Setting a useful minimum can keep a large blank region from dominating the plot, while a suitable maximum can leave room above the highest observation. Avoid choosing bounds solely to make a trend look more dramatic; use a range that preserves the context needed to interpret the chart.

Also inspect the tick marks, gridlines, and number format. The chart should make the scale apparent, particularly if readers may assume it is linear. A short note such as logarithmic scale, base 10 can prevent confusion. If the axis labels are crowded, adjust their number format or chart size rather than assuming the chart has changed the underlying values.

How to interpret the chart correctly

On a logarithmic vertical axis with a linear horizontal axis, a straight-looking trend often indicates a roughly constant percentage or multiplicative rate of change per horizontal step. It does not mean the quantity adds the same number of units each time. For example, steady doubling over equal time intervals can form a straight line on a log-y chart even though the absolute increase gets larger at each step.

If both axes are logarithmic, equal distances horizontally and vertically correspond to equal ratios on their respective variables. A straight trend can indicate a power-law relationship, but the visual pattern alone does not establish a cause or prove a statistical model. The axis is a way to display data, not a substitute for analysis.

Always tell readers when an axis is logarithmic. A chart with equally spaced marks at 1, 10, and 100 can be misread if someone expects equal numerical gaps. When comparing two charts, also check that their bases and bounds match; different settings can make the same data look more or less steep.

Common problems and fixes

Zero or negative values: A logarithm is not defined for zero or negative numbers, so those values cannot be plotted on the selected log axis. Check the source data, filters, and calculated results. Do not replace zero with a small positive number unless that value has a defensible meaning and is clearly documented.
The checkbox is missing or unavailable: You may have selected the chart area, a series, or a category axis rather than a value axis. Select the numeric axis itself. If necessary, change the chart to an XY scatter chart when both coordinates should be numerical.
Some points disappear: Look for zero, negative, blank, or text entries in the series. Also confirm that axis bounds do not exclude the data you expect to see.
The chart looks dramatically different: That is an expected consequence of changing from equal differences to equal ratios. Check the scale labels and compare actual values before drawing conclusions.
Bars do not start at zero: A log axis cannot include zero. Use a chart type and explanation that suit positive values, rather than presenting a truncated bar as though it were a conventional zero-based comparison.

Logarithmic scale compared with transforming data

Applying a logarithmic axis is different from creating a new column of logarithm-transformed values. With an axis setting, the chart uses the original measurements and displays them at log-spaced positions. With a data transformation, you calculate new values and plot those values on a regular linear axis. Both approaches can produce similar visual spacing in some situations, but the labels, calculations, and interpretation differ.

An axis setting is convenient when you want readers to see original units such as concentration or population. A transformed column can be appropriate for a statistical method or analysis that specifically requires transformed inputs, but it changes what the plotted numbers represent. Explain which approach you used, and avoid applying a log transformation to data that include zero or negative values without a suitable, justified method.

Frequently Asked Questions

Can Excel make the horizontal axis logarithmic?
Yes, when the horizontal axis is a value axis, such as the x-axis of an XY scatter chart. A standard line chart usually has a category axis horizontally, so it cannot be given a logarithmic scale there.

Can a logarithmic axis include zero?
No. Zero and negative numbers cannot be represented on a logarithmic scale. Choose a linear scale or use a carefully justified alternative for those observations.

Does Excel change my data when I select logarithmic scale?
No. It changes the axis spacing, not the source cells. The chart continues to represent the original values, although their visual positions follow the selected logarithmic base.

Why does my log-scale chart show a straight line?
A straight trend may reflect a roughly constant multiplicative rate when one axis is logarithmic, or a power-law pattern when both axes are logarithmic. It is a visual clue, not proof of a particular mechanism.

Should I use base 10?
Base 10 is a common and readable default, especially for data spanning powers of ten. Use another base only when it makes the scale more meaningful for the data or audience, and state the choice clearly.

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.