Help

Creating charts from data
F
ILEMAKER PRO HELP 416
• When you chart delimited data in the current record, a calculated y-axis data series (slice
data in pie charts) must return the result in a text field.
I received a parsing error when charting delimited data
When you chart delimited data, you must enter numerical data, dates, and times in the format of the
current locale. Otherwise, FileMaker
Pro displays an error.
Blank records appear in chart
If data points for unexpected blank records appear in your chart, it’s possible:
• there are restricted records in the database that you do not have access to chart
• the file contains invalid calculations that are returning the question mark character (?)
To remove zero data points from your chart, perform a find and omit the invalid records by entering
only the = operator in the appropriate fields. If the problem persists, check and correct calculations.
See
Finding records except those matching criteria.
Charting missing data values
If your x-axis data series contains missing values (no data), a data label is displayed on the x-axis
for most chart types, but no corresponding data point is displayed. Line and area charts display a
missing data point as a zero.
Tick marks display differently in the chart preview and Layout mode
FileMaker Pro automatically adjusts chart scale and tick marks depending on the size of the chart.
Therefore, tick marks and scales might look different when viewed in the chart preview and Layout
mode.
Charting repeating fields
FileMaker Pro does not recognize individual values in repeating fields as a data series. To chart data
in repeating fields, use the
List function to combine repeating data in a delimited format, then
choose Current Record (delimited data) for Chart Data.
Example: Charting delimited data
FileMaker Pro can chart multiple data entries from a single field when each data value in the field is
separated by a carriage-return character (carriage return-delimited data).
About the chart
In this example, you create a new database containing two return-delimited fields: Country and
Customer Count. The fields are located on one layout and all data is stored in one record. Then you
create a column chart that compares the number of customers located in each country.
Create a database
1. Do one of the following:
• If the FileMaker Quick Start Screen is open, click Create a New Database, then close
the Quick Start Screen.
• If the FileMaker Quick Start Screen is not open, choose File menu > New Database.
2. Name the file Worldwide Customers, then click Save to save the file on your hard disk.