Formatting and scaling chart axes

  1. Create a chart or double-click an existing chart in Layout mode.
  2. In the Chart inspector, click Chart and navigate to the Axis Options.
  3. If Axis Options are not displayed, click Axis Options button.
  4. To display a data value for each data point, select Show data points on chart.
  5. To set display options for axes labels, click X-Axis, Y-Axis, or Radius (bubble chart only) and do the following:
  6. To

    Do this

    Change the angle of data point labels

    For Label Angle, enter a value between 0 (zero) and 90 or click or drag the angle control Angle control.

    Set the scale for tick marks

    For Scale, choose one of the following:

    • Select Linear to measure data that changes arithmetically (for example, sales growth or decline).
    • Select Logarithmic to measure data that changes exponentially (for example, sound waves measured in decibels or earthquake magnitudes).

    Specify tick mark characteristics

    Select Show major ticks or Show minor ticks, then enter a value to specify the frequency that labels appear on tick marks. If you don't specify tick mark settings, an appropriate tick mark setting (auto) is estimated based on the data values in your chart.

    Select Set minimum or Set maximum, then enter a value to specify the range of tick marks displayed.

    Positive/Negative charts: Select Set mid-point to specify a custom mid-point. The default mid-point is zero.

    Format labels based on the field type

    For Data Type, choose the appropriate field type, then choose data format characteristics. For example, you can display number data as a decimal, percentage, or as currency.


    • Custom decimals or thousand separators must be ASCII printable characters.The tilde character (~) is not allowed.
    • Decimal digits must be from 0 (zero) to 99.
    • You must enter a positive number for Fixed number of decimals.
  7. Set any other options, then click Print or Save as Layout (quick charts) or Done (Layout mode charts) to finish the chart. See Creating quick charts or Creating and editing charts in Layout mode.


  • Decimal and thousands characters can be any ASCII character except a hyphen (-).
  • If a format applied to a data series is incompatible with the data returned (for example, date settings are applied to a text field containing the string "date"), the data point is ignored and does not appear in the chart.