### Charting on summary or subtotal fields (Group layout)

Many of the charts you create are based on summary or subtotals within your report. In order to create these charts, you must have a summary or subtotal already inserted into your report. For more information on inserting summaries and subtotals, see Summarizing grouped data and Subtotaling.

###### To chart on a summary or subtotal field

1. On the `Insert` menu, click `Chart`.

   The Chart Expert dialog box appears.

2. On the `Type` tab, in the `Chart type` list, click the chart type that best illustrates your data. See Chart types.
3. Click the `Data` tab.

4. In the `Layout` area, click `Group`.

   Note: When summarizing or subtotaling a field, the data is automatically grouped. See Sorting, Grouping, and Totaling.

5. In the `Placement` area, in the `Place graph` list, specify how often your chart appears on the report, then click `Header` or `Footer` to specify where to place your chart.
6. In the `Data` area, in the `On change of` list, click the group field you want to base your chart on, then in the `Show` list, click the summary field you want to display on your chart.
7. On the `Axes` and `Options` tabs, add data values, a legend, or other elements to your chart.
8. Click the `Text` tab.
9. Accept the default title information or add new titles to your chart.
10. Click `OK`.

    Your chart is placed in the Header or Footer section of the report, depending on your selection in Step 5.

    Note: When your chart is inserted, it may cover a portion of the report. Move and resize the chart so that it fits properly within the report.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com