Transform a continuous scale to get a different view of your data. To transform a scale, double-click the scale and select the transformation on the Transform tab.
A logarithmic scale linearizes logarithmic relationships by changing the axis, so that the same distance represents different changes in value across the scale. For example, in the scatterplot with the untransformed x-scale, the function y = ln(x) is not linear. When you transform the x-scale to logarithm base e, the form of the data is linear.
You cannot use a logarithmic scale if the data include non-positive values.
For a power transformation, the data values are raised to the power that you specify and the scale remains linear. For example, in the scatterplot with the untransformed x-scale, the curvature in the data does not follow the linear fitted regression line. When you perform a power transformation on the x-scale, the data follow the linear fitted regression line.