How to Create Chart Summary data in Filemaker

How to Create Chart Summary data in FilemakerFilemaker Logo

To chart summary data:
1.
Sort data by the appropriate break field to form groupings (categories) of data. See Sorting records by subsummary values.
For example, to chart worldwide sales by country, sort data by the Country field.
2.
Create a summary field in your database to calculate an aggregate value for the category. See Defining summary fields.
For example, to chart total sales, create a summary field Total Sales that calculates the total of the Sales field.
3.
Create a chart in the body, header, footer, or grand summary part of the layout in which you want the chart to appear. See Creating and editing charts.
In the Chart Setup dialog box:
 •
For Horizontal (X) Axis (Vertical (X) Axis in horizontal bar charts and Label Data in pie charts), specify the sort field.
In this example, the X-axis is the Country field.
 •
For Vertical (Y) Axis (Horizontal (Y) Axis in horizontal bar charts and or Value Data in pie charts), specify the summary field.
In this example, the Y-axis is the Total Sales field.
 •
For Use Data From, select Current Found Set and Show data points for groups of records when sorted.
The chart compares total sales by country.
You can also chart summary data by subcategory (for example, total sales by company within one country). To do so, you could change the chart settings specified in the example above as follows:
 •
sort records by the main category, then the subcategory (for example, sort by Country, then by Company)
 •
set the X-axis to the subcategory (Company)
 •
place the chart in a subsummary layout part sorted by the main category (Country)
For information on how chart placement affects the data displayed in a chart, see Placing your chart in the appropriate layout part.
The chart compares total sales by company within one country.

Credit: http://www.filemaker.com/help/11/fmp/html/create_layout.9.49.html