Follow these steps to specify the scale for the chart view's x, y, and z axes (if applicable).

  1. Click the Axis Scaling tab to specify the scale for the data axis. These options are only applicable for chart types that display axes.
  2. If the data for your chart type appears along the X-axis (such as a bar chart), select a scaling option from the X Scaling drop-down list and enter an Interval.
  3. If the data for your chart type appears along the Y-axis (such as a column chart), select a scaling option from the Y Scaling drop-down list and enter an Interval.
  4. If the data for your chart type appears along the Z axis (such as a column chart 3D), select a scaling option from the Z Scaling drop-down list and enter an Interval.

 Axis Scaling Options