Formatting and scaling chart axes
You can use the Chart inspector to set display options for the x-axis and y-axis.
To set axis options:
In the Chart inspector, click Chart and navigate to the Axis Options.
If Axis Options are not displayed, click Axis Options button.
To display a data value for each data point, select Show data points on chart.
To set display options for axes labels, click X-Axis, Y-Axis, or Radius (bubble chart only) and do the following:
For Label Angle, enter a value between 0 (zero) and 90 or click or drag the angle control Angle control icon.
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).
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, FileMaker Pro estimates an appropriate tick mark setting (auto) 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.
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.
You must enter a positive number for Fixed number of decimals.
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.
Related topics 
Creating quick charts
Creating and editing charts in Layout mode
Column, bar, line, and area charts
Scatter and bubble charts