Group data in PivotChart view

1. Open a datasheet or form in PivotChart view.
2. Select the category field or series field whose items you want to group.
3. On the PivotChart toolbar, click Properties , and then click the Filter and Group tab.
4. Set Group items by to a value other than (No grouping).
5. Set Interval to the value you want. For example, if you are grouping alphabetical items by prefix characters, setting Interval to 2 would group items based on the first two prefix characters.
6. To specify the value at which grouping begins or ends for numeric intervals, select either or both of the Start at or End at check boxes, and then enter a value in the adjacent text box.