Modify the Y-Axis

You can change some properties of the Y-axis.

For example, you can increase the number of gridlines to make it easier to distinguish the differences between categories that have similar values.

Procedure

  1. Click the arrow to the right of the chart button chart icon, and click a chart type.
  2. Click the arrow to the right of the chart button and click Chart Options.
  3. Click the Scale tab and select the options that you want:
    • To set the maximum or minimum scale value, select the Use manual axis scale check box, and enter a value in the appropriate box.
    • To turn grid lines on or off, select the Show the gridlines check box.

    For a 3D bar display, select the gridline boxes for the appropriate facings.

    • To reverse the axis so that the largest number is at the bottom, select the Reverse Axis check box.
    • To specify the number of ticks on the axis, select the Number of Ticks check box and enter a value in the box.
    • To specify the location of the axis, under Axis Placement, click either Left, Right, or Left and Right.

    The last three options are not available for 3D bar displays.

  4. Click OK.