Reordering Pareto chart bars

Reorder bars to put a specific category at the end (for example, Miscellaneous).

1. Activate the analysis report worksheet.
2. On the Analyse-it ribbon tab, in the Pareto group, click Reorder.
   The analysis task pane Categories panel opens.
3. Select the Keep specific category at end check box.
4. In the drop-down list, select the category to place at the end.
5. Click Recalculate.