Merging Pareto chart categories

Merge categories to reduce clutter and see the vital few rather than the trivial many.

1. Activate the analysis report worksheet.
2. On the Analyse-it ribbon tab, in the Pareto group, click Combine.
   The analysis task pane, the Categories panel opens.
3. To merge all the categories with a frequency less than a threshold:
   1. In the Combine group, select the Threshold option.
   2. In the Less than value / % edit box, type the frequency count or relative frequency % threshold.
   3. In the Name edit box, type the name of the newly merged category.
4. To merge a fixed number of smallest categories:
   1. In the Combine group, select the Last option.
   2. In the Categories / % edit box, type the number of categories to merge, or the % of categories.
   3. In the Name edit box, type the name of the newly merged category.
5. To merge specific categories:
   1. In the Combine group, select the Custom option.
   2. In the Categories grid, click to select the first category, and then hold down SHIFT and click to select the last category to make a contiguous selection, or hold down CTRL and click to select additional categories to make a discontiguous selection.
   3. Click Merge.
   4. In the Categories grid, under the Name column, alongside the category in the edit box, type the name of the newly merged category.
6. Click Recalculate.