Reordering Pareto chart bars

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

You must have already completed either of the tasks:
  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.