#### How to group category series data

In the chartbuilder, on Select Data, choose Edit Group and Sorting. Figure 15-3 shows the location of Edit Group and Sorting. In Grouping, select Enabled to see the grouping options shown in Figure 15-4.

Figure 15-4 Grouping and sorting options

Use the following options to set up a group:

- In Type, select Text, Numeric, or Date and Time. If you select Date and Time, you can specify the units to use to form the groups, such as Minutes.
- In Interval, select a number that represents the size of the groups to create. For example, to group three-row sequences of text data, select 3. To group numeric data in sections of four, select 4.
- In Aggregate Expression, select the function to use to aggregate the data in the group. You can select Average or Sum.