Placing your chart in the appropriate layout partData in charts created in Layout mode is evaluated based on the layout part in which the chart is located.
When Summarized groups of records is selected, FileMaker Pro charts data in
• 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 outer-most 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.
• 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 (category labels in pie charts) to be the sort field and your y-axis definition (slice 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 category labels) and summarize data in the Company field (y-axis or slice data) to calculate the number of companies in each country. FileMaker Pro then charts the summarized values by country.