Excel: Axis Plots Begin at One on Log Chart

ID: Q87794

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0

SUMMARY

When using a logarithmic scale in a Microsoft Excel chart, the X and Y axis will cross at one. This can be confusing because non-logarithmic scales usually cross at zero by default. Zero is not used within a log chart because it is not a proper power of ten. The value of 10^0 (ten raised to a power of zero, or 1) is used instead.

MORE INFORMATION

Logarithmic scaling adjusts the chart's scale to base 10, based upon the data being charted. The value at which the X and Y axis cross may be changed, but the value must be a power of ten. If the cross value is not a power of ten, Microsoft Excel rounds the value down to the nearest power of ten.

To change the point at which an axis cross another in a logarithmic chart, do the following:

Select the appropriate axis.

From the Format menu, choose Scale.

Click the X/Y Axis Crosses at: field.

Type in the appropriate value.

Any axis that uses a log scale can only be modified in increment of powers of ten (.01, .1, 1, 10, 100, and so on). Negative or zero values cannot be used.

Additional query words: 2.1 2.10 2.1c 2.10c 2.1d 2.10d 2.2 2.2a 2.20a 3.0

Keywords :
Version :
Platform :
Issue type :