Example 3: 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 (return-delimited data).
In this example, you will create a new database containing two return-delimited fields: Country and Club Member Count. The fields will be located on one layout and all data will be stored in one record. Then you will create a bar chart that compares the number of club members located in each country.
|
•
|
If the FileMaker Quick Start Screen is open, click Create a New Database, then close the Quick Start Screen.
|
|
•
|
|
2.
|
The file opens in Browse mode in Table View. FileMaker Pro creates the first table and layout for you. Both have the same name as the file.
|
1.
|
|
2.
|
|
3.
|
Click View As
 in the layout bar to go to Form View, then click Edit Layout to switch to Layout mode. |
|
4.
|
Select the Club Member Count field and field label and drag them down about an inch.
|
|
5.
|
Select the Country field and drag its handles down until you see 5 rows in the field.
|
|
6.
|
Select the Club Member Count field and drag its handles down until you see 5 rows in the field.
|
|
7.
|
|
1.
|
Click New Record in the status toolbar.
|
|
2.
|
In the Country field, type the following pressing Enter (Windows) or Return (Mac OS) after each country name.
|
|
3.
|
In the Club Member Count field, type the following pressing Enter (Windows) or Return (Mac OS) after each value.
|
|
1.
|
Click Edit Layout in the layout bar to switch to Layout mode.
|
|
2.
|
Click Body on the layout and drag the body layout part down to make room for the chart.
|
|
3.
|
Click the Chart tool
 in the status toolbar, then click in the body layout part and drag a large rectangle where you want the chart to appear. |
|
Choose Bar.
Note The chart preview updates when you make formatting changes to chart settings. However, the chart does not show data from your database until you view the chart in Browse, Find, or Preview modes.
|
|
|
Type Members by Country
Note FileMaker Pro encloses your title text in quotation marks when you click outside the Chart Title field.
|
|
|
Data values from the Country field will appear as labels for the bars in your chart (X-series). This is the data you are comparing.
|
|
|
The bars in your chart will show the data values from the Member Count field (Y-series). This is the data you are measuring.
|
|
|
Choose Current Record (delimited data).
|
, choose |
5.
|
Click OK.
|
You see placeholder data in the chart on your layout. You must switch to Browse mode to see data from this database.
You see the finished chart. Each return-delimited value in the Country field corresponds to a return-delimited value in the Member Count field in the order the data was entered.
|
•
|
If your chart is hard to read (for example, the country names overlap), return to Layout mode, select the chart, and drag the handles to make the chart larger. Then return to Browse mode to verify the chart.
|