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:
- Open the Axis tab of the Edit Chart dialog.
- 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.
- Click Y Axis and specify Auto or Fixed for the following: Minimum, Maximum, Major Unit, and Minor Unit.
- 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.
- Click OK to save the chart view settings.