### Order/Select N dialog

This dialog allows you to set the sort order and the Select N condition in a chart. See the dialog.

Order

Specifies in which order data on the category/series axis of a chart will be displayed.

- Ascending
  Lists data in an ascending order.
- Descending
  Lists data in a descending order.
- No Sort
  Keeps the data in their original order.

Select N

Specifies the Select N condition to define the number of category/series values that will be displayed while others are hidden.

- Select N
  - All
    If selected, all category/series values in the chart will be displayed.
  - Top
    If selected, specify a number in the text box to the right and the first N category/series values in the chart will be displayed.
  - Bottom
    If selected, specify a number in the text box to the right and the last N category/series values in the chart will be displayed.
- Based on
  Check this option to order the category/series values by the values of the selected summary with the direction specified. If you uncheck this option, the category/series values will be sorted by themselves.
- Other
  Enabled when you select Top or Bottom from the Select N drop-down list. Check this option and then type a character string in the text box to group all the category/series values beyond the top/bottom N category/series values.

OK

Accepts the changes and closes the dialog.

Cancel

Discards the changes and closes the dialog.

Help

Displays this help document.