Help

Creating charts from data
F
ILEMAKER PRO HELP 404
3. Click Done.
You see a placeholder image of the chart in Layout mode. FileMaker Pro uses sample data
when displaying a chart object in Layout mode.
4. Click Save Layout, then Exit Layout.
You see the chart based on data in the database.
To edit a chart:
1. In Layout mode, double-click the chart that you want to edit.
2. In the Chart Setup dialog box, change settings in the Chart inspector.
3. Click Done to close the Chart Setup dialog box.
4. Click Save Layout, then Exit Layout.
To chart summary data in Layout mode
1. In Browse mode, sort data by the appropriate break field to form groupings (categories) of
data. See Working with data in Table View or 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
Creating dynamic reports in Table View or Defining summary fields.
For example, to chart total sales, create a summary field Total Sales that sums the Sales field.
3. Create a chart in the body, header, footer, subsummary, or grand summary part of the
layout. See
Placing your chart in the appropriate layout part.
In the Chart inspector, click Chart.
• For X-Axis (Horizontal) or Category Labels (pie charts), specify the sort field.
For example, the Country field.
• For Y-Axis (Vertical), or Slice Data (pie charts), specify the summary field.
For example, the Total Sales field.
In the Chart inspector, click Data Source.
• For Chart Data, select Current Found Set.
• For Chart display when layout is sorted, select Summarized groups of records.
The chart compares total sales by country.
Change data labels, show or
hide tick marks and set tick
mark scale (if applicable), and
format data
See Formatting and scaling chart axes.
Change the color scheme,
legend, or fonts in the chart
Click Styles in the Chart inspector, then see Changing the
look of a chart.
Specify the type of data the
chart uses (records in the
found set, delimited records,
or related records)
Click Data Source in the Chart inspector, then see
Specifying the data source for a chart.
To Do this