Alternate method for setting a custom scale

To set a custom scale:

  1. On the Chart tab, in the Axes group, click the dialog box launcher.
  2. From the Axis list, select Y Axis or 2nd Y Axis.
  3. From the Layout list, select Custom.
  4. Under Bounds, define the scale layout as previously described.