Home > Designing and creating databases > Creating and managing layouts and reports > Working with charts > Placing your chart in the appropriate layout part

Placing your chart in the appropriate layout part

Data in charts is evaluated based on the layout part in which the chart is located. If you place a chart in an inappropriate layout part, you may get unexpected results. For information on how data is displayed in different layout parts, see About layout part types.

When you use a calculation to specify a chart title, the title is calculated based on the chart’s layout part as well. See How layout parts affect calculated titles in charts.

If your chart doesn’t appear as expected when you verify it in Browse mode, it might not be placed in the correct layout part. The following guidelines will help you troubleshoot chart display problems.

Note  You cannot place a chart in a portal.

For more information about charting data in FileMaker Pro, visit www.filemaker.com.

When data is based on the current found set

 

When you place a chart in a:	FileMaker Pro charts data in:	When Show data points for groups of records when sorted is selected, FileMaker Pro charts data in:
Header or body layout part	The current found set	Every first record in the outer-most sorted groups
Footer layout part	The current found set	Every last record in the outer-most sorted groups
Leading subsummary layout part	All records in the sorted group	Every first record in the sub-group of the sorted group
Trailing subsummary layout part	All records in the sorted group	Every last record in the sub-group of the sorted group
Leading grand summary layout part	Current found set	Every first record in the outer-most sorted groups
Trailing grand summary layout part	Current found set	Every last record in the outer-most sorted groups

Notes

•

Charts placed in a subsummary layout part use data in the sorted group to create the chart. When there is no sort order, FileMaker Pro charts individual data values in the entire found set. Subsummaries are considered inner summaries, because they display aggregate data from a group within the data set based on the sort order you specify.

•

Charts placed in a grand summary layout part use data in the outermost level of each sorted subsummary group to create the chart. Grand summaries are considered outer summaries, because they display an overall summary of aggregated data based on the entire found set. You can also use grand summary layout parts to summarize each subsummary group.

•	The outer-most sorted groups are the group of records sorted by the first field listed in the Sort Order dialog box.

•

For grand summaries calculated on the current found set, FileMaker Pro assumes you want to chart data in each subsummary group. Therefore, FileMaker Pro expects your X-axis definition (Label Data in pie charts) to be the sort field and your Y-axis definition (Value Data in pie charts) to be a summary field. For example, to create a bar chart that compares the total number of companies per country, you must sort data by country (X-axis or Label Data) and summarize data in the Company field (Y-axis or Value Data) to calculate the number of companies in each country. FileMaker Pro then charts the summarized values by country. For more information, see Charting summary data.

When data is based on the current record (delimited values)

 

When you place a chart in a:	FileMaker Pro charts data in:
Header, footer, or body layout part	Current record
Leading subsummary layout part	First record in the sorted group
Trailing subsummary layout part	Last record in the sorted group
Leading grand summary layout part	First record in the found set
Trailing grand summary layout part	Last record in the found set

When data is based on related records

 

When you place a chart in a:	FileMaker Pro charts data in:
Header, footer, or body layout part	The set of related records that is obtained from the relationship between the current record and the related table
Leading subsummary layout part	The set of related records that is obtained from the relationship between the first record in a sorted group and the related table
Trailing subsummary layout part	The set of related records that is obtained from the relationship between the last record in a sorted group and the related table
Leading grand summary layout part	The set of related records that is obtained from the relationship between the first record in the found set and the related table
Trailing grand summary layout part	The set of related records that is obtained from the relationship between the last record in the found set and the related table

Note  If you place a chart in a grand summary part without sorting records, FileMaker Pro will chart data from the entire found set as though the chart had been placed in a header, footer, or body layout part.

How layout parts affect calculated titles in charts

 

When you place a chart in a:	FileMaker Pro displays a title for a chart element in the:
Header, footer, or body layout part	Current record
Leading subsummary layout part	First record in the sorted group
Trailing subsummary layout part	Last record in the sorted group
Leading grand summary layout part	First record in the found set
Trailing grand summary layout part	Last record in the found set

Related topics 

Working with layout parts

Adding a layout part

Changing a layout part