To | 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. |