Selecting boundaries for the scale

You can define upper and lower boundaries for the scale.

To define boundaries for the scale:

  1. On the Chart tab, in the Axes group, click Bounds More to expand the list.
  2. Select one of these options:
    Option Description
    Automatic The lower bound of the scale is zero for positive data, or below the smallest datapoint for negative data. The upper bound is above the largest datapoint for positive data, or zero for negative data. Supported for all chart types.
    Min/Max The lower bound of the scale is below the smallest datapoint. The upper bound is above the largest data point. This format is supported for bar, line, area, and combo charts which use a Linear or Log scale type.
    Custom The Axis dialog box opens where you can define the scale layout.
    • Lower bound. The minimum scale value. Must be less than the upper bound.
    • Upper bound. The maximum scale value. Must be greater than the lower bound.
    • Steps. The number of divisions between the bounds. Must be greater than 0.

    Custom scales are supported for bar, line, area, and combo charts using any scale type, and high-low charts which use a Linear scale type.

  3. Click OK.
  4. Click Save Changes.