Setting the Chart Axis

Chart Axis properties affect the visual display of the chart's axis labels. You can create a title and label for the X axis, and the primary and secondary Y axis of the chart. You can also edit the text and number format of the Y axis, and define a custom range for both Y axes.

Note:

This tab doesn't display for chart views with Type set to Doughnut, Pie, or Tile.

To define the chart axis:

  1. Open the Axis tab of the Edit Chart dialog.
  2. Select X Axis and specify the following (only for chart views with Type set to Date in the Layout tab):
    • Interval: Select Auto, Daily, Monthly, or Yearly.
    • Maximum: Select Auto or Fixed. For Fixed, select a date.
    • Minimum: Select Auto or Fixed. For Fixed, select a date.
  3. Click Y Axis and specify Auto or Fixed for the following: Minimum, Maximum, Major Unit, and Minor Unit.
  4. If Dual Y Axis is selected for the chart in the Properties tab, click Dual-Y Axis and specify the Minimum, Maximum, Major Unit, and Minor Unit.
  5. Click OK to save the chart view settings.