How to Do a Linear Scale on Excel

By Ryan Menezes

Logarithmic scales suit sharply curved chart trendlines.
i Jupiterimages/Comstock/Getty Images

Charts in Excel spreadsheets can use either of two types of scales. Linear scales, the default type, feature equally spaced increments. In logarithmic scales, each increment is a multiple of the previous one, such as double or ten times its size. Logarithmic scales track very fast growth. For example, if you track visitors to a new company landing site you might expect traffic to initially grow exponentially. If growth does not meet these high expectations, your chart will display growth more clearly if you revert to the conventional linear scale.

Click the Excel chart's y-axis to select it.

Right-click and click "Format Axis" to open the Format Axis dialog box.

Click "Axis Options" in the dialog box's sidebar.

Click the check box labeled "Logarithmic scale" to deselect it.

Click "Close" to apply a linear scale to the chart.


Information in this article applies to Excel 2010. It may differ slightly or significantly with other versions.