Transform a continuous scale to get a different view of your data.

To transform a scale, use the following steps:
  1. Double-click the graph.
  2. Double-click the scale to open the Edit Scale dialog box.
  3. On the Transform tab, select the appropriate transformation.
    Logarithm
    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.
    Untransformed x-scale
    Transformed x-scale (log base e transformation)
    Note

    You cannot use a logarithmic scale if the data include non-positive values.

    Power
    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.
    Untransformed x-scale
    Transformed x-scale (power transformation)
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy