Changing the Axis Scale to Logarithmic
Modify a graph to make use of a logarithmic scale when the data is spread over large range. A logarithmic (log) scale allows you to view the data on a non-linear scale.
A log scale can be applied to a Cartesian graph for both the horizontal and vertical axes. For a polar graph, a log scale can only be applied to the radial axis.
- Select the Cartesian graph where you want to enable the log scaling for the horizontal axis.
- On the Display tab, in the Axes group, click the Log (horizontal) icon.