Creating charts from data > Creating and editing charts in Layout mode > Formatting and scaling chart axes
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:
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 icon.
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, 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.
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.
6. 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.
Related topics 
Creating quick charts
Creating and editing charts in Layout mode
Column, bar, line, and area charts
Scatter and bubble charts