Creating charts from data > Chart planning guidelines
Chart planning guidelines
Choose the best type of chart to convey your comparison. Some chart formats compare similar data from different sources, some show trends over time, and some show percentages of a total. See About chart types.
Sketch the chart on paper to help you determine the data series you need to assign to the x-axis and y-axis (category labels and slice data in pie charts). Charts typically show category labels on the x-axis (values you are comparing, such as companies by name) and values on the y-axis (values you are measuring, such as quarterly sales figures for each company).
Decide whether you need to modify data to show your comparison.
Do you need to perform any calculations on the data before you create the chart? For example, do you need to add summary fields to the database to calculate quarterly sales figures or does your database already contain quarterly information?
Do you need to sort data to show your comparison?
Consider this
Chart summary data
If you’re creating a chart in Layout mode, make sure data is grouped and sorted correctly and that you place your chart in the appropriate layout part. See Placing your chart in the appropriate layout part.
Chart data in related records
You can sort data based on related fields, but you must set the sort order in the Chart Setup dialog box, not the Sort dialog box. See Specifying the data source for a chart.
Chart multiple data values located in single fields (for example, data in repeating fields or delimited data in a single field)
To chart delimited data, your database must contain multiple data values in single fields. You can use a calculation or a function (such as the List function) to do this. You then specify one delimited data field for the x-axis (category labels in pie charts) and one data field for the y-axis (slice data in pie charts). When you chart delimited data, values from the x-axis field correspond to values in the y-axis field in the order they were entered. See Example: Charting delimited data.
Note  FileMaker Pro recognizes only the carriage-return character as the data delimiter.