Set the minimum and maximum axis values in a chart

The maximum and minimum axis values on a chart change automatically by default, which can sometimes make data difficult to view. You can fix this by setting static minimum and maximum axis values.

  1. Select the axis on the chart.

  2. Right-click the axis then select Format Axis in the menu. The Format Axis panel appears on the right side of the window.
  3. Under Axis Options in the Format Axis panel, set the minimum and maximum axis values by entering a value in the Minimum and Maximum boxes under Bounds.