Help

Creating charts from data
F
ILEMAKER PRO HELP 401
• field type and contents of the selected fields
• sort order you have specified
Note The active field is the field you right-click when you create a quick chart.
If you have the correct privileges, you can save the chart on a layout in your database.
Quick charts work best for column, bar, pie, line, and area charts, which have a single data series on
one axis and one or more data series on the other axis.
To create a quick chart:
1. Open the database containing the data that you want to chart.
2. In Browse mode, click View As in the layout bar to switch to Table View.
Tip You can create quick charts in Form View and List View, but it’s easier to work in Table
View.
3. Use Table View to sort data. (Right-click or Control-click a column and choose a sorting
option from the shortcut menu.) Quick charting uses the first sort field to group and
summarize the data in the chart. Consider adding groups or summaries if those are the
data
points you intend to chart. See Working with data in Table View and Creating dynamic
reports in Table View.
FileMaker Pro chooses an appropriate summary type based on the active field.
4. Right-click the column of the values you are most interested in charting.
5. Choose one of the following:
The Chart Setup dialog box appears. When you chart data in Table View, FileMaker Pro uses
the current state of the file and the context of your selection to estimate chart settings.
Depending on the complexity of your data set and the chart type you choose, you might need to
use the Chart Setup dialog box to make adjustments to a quick chart.
Choose To
Chart by <field name> Plot individual data points in the current column
Chart <field name> by <sort field> Plot data from the current column in groups based
on the sort order