Example 1: Charting summary data
This example is based on the database of a fictitious business named Favorite Bakery. Use the FileMaker Pro tutorial sample file, Sample.fmp12, to create this chart. The sample file is located in:
FileMaker Pro 12/English Extras/Tutorial
or
FileMaker Pro 12 Advanced/English Extras/Tutorial
About the chart
In this example, you create a pie chart that compares bakery customers from three corporate accounts. The chart shows the percentage of customers from each company.
Save a copy of the sample file
1.
Locate the tutorial sample file (Sample.fmp12), copy it, and save it in another folder on your hard disk.
2.
Open your copy of the sample file.
You see the sample file’s Data Entry layout. It displays one record in Form View.
3.
Click View As Table View in the layout bar to switch to Table View.
You see there are 29 customer records in the database. Each record contains the name and address information for a bakery customer employed by the ABC, DEF, or XYZ company.
4.
Scan the data to familiarize yourself with it.
Sort data by company and create the chart
1.
Right-click or Control-click the Company column and choose Sort Ascending to sort the data in alphabetical order by company name.
2.
Right-click the Company column again and choose Chart by Company.
The Chart Setup dialog box appears. FileMaker Pro displays the total number of corporate bakery customers by company in a column chart.
Note  If you save the chart on a layout, FileMaker Pro creates a summary field in the database to store this summarized data. If you only print the chart, the summary field is not created in the database.
Customize the chart title and display the data in a pie chart
1.
In the Chart inspector on the right, under Chart, enter the following settings:
 
For
Do this
Title
Select “Company Count” and type Customers by Company.
Type
Choose Pie.
Options
Select Show values on chart.
Data values stored in the Company field appear as labels for each slice of the pie chart.
Select Percentages.
The percentage of total customers from each company appears on the chart.
2.
Click Save as Layout, then OK to close the Chart Setup dialog box.
The completed chart appears in Browse mode.
Note  You can double-click a chart in Layout mode to open the Chart Setup dialog box and modify the chart.
Related topics 
Using shortcut menus
Creating quick charts
Example 2: Charting delimited data
Example 3: Charting related records
Was this topic helpful? Send feedback.