Show All

Group or ungroup data in a chart

1. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
2. Select the category or series field whose items you want to group or ungroup.
3. On the toolbar, click Commands and Options , and then click the Filter and Group tab.
4. Do one of the following:

   Group data

   1. Under Grouping, set Group items by to a value other than (No grouping).
   2. Set Interval to the value you want. The type of interval you can specify for a field depends on the data type of the field.
      • Numeric fields   You can group in intervals of any integer, such as 1, 2, 5, 100, and so on. For example, you can group the EmployeeID field into groups of 1–100, 101–200, and so on.
      • Date and time fields   You can group in intervals such as days, weeks, and quarters. For example, you can group the values in the ShippedDate field into months to show data for orders shipped in January, orders shipped in February, and so on.
      • Text fields   You can group based on the first n characters of the individual items. For example, you can group the LastName field by first letter to create groups such as A, B, and so on.
   3. 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.

   Ungroup data

   • Set Group items by to (No grouping).