Database Reference
In-Depth Information
Figure 15-26. In the FileMaker charting world, “delimited” just means a list of values with
line breaks between them. The link between the delimited values of these two fields is simply
the order they're listed in. If you rearranged the names on the left to be in alphabetical or-
der, the numbers on the right wouldn't automatically change with them.
3.
Click the Chart heading in the column on the right
.
4.
Click the box to the right of the Chart Title field and then select Specify Field
Name from the list of fields that pops up. Choose “chart title” and then click OK
.
Repeat this step for X-axis Data, selecting the “chart labels” field and the Y-axis Data,
choosing “chart data.”
5.
Click the Data Source heading in the column on the right. Finally, set the Chart
Data pop-up menu to “Current Record (delimited data),” and then click Done
.
The finished chart should resemble the preview pane seen in
Figure 15-27
.
Switch back to Browse mode to admire your chart. If you modify data in any of the fields,
the chart will reflect your new data as soon as you commit the changes by clicking some
empty space or pressing Enter on your numeric keypad.
The beauty of charting delimited data is that you can use FileMaker's calculation tools and
scripting capabilities to pull together a chart's raw data on demand. And because FileMaker
