Skip to main content

BackPrevious TopicNext TopicNext

Order/Select N

The Order/Select N dialog box is used to set the sort order and the Select N condition in a chart.

Order/Select N dialog

Order

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

  • Ascend
    Lists data in an ascending order.
  • Descend
    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
    If the option is selected, the category/series values will be sorted by the values of the summary selected with the direction specified. If it is unselected, the category/series values will be sorted by the order specified in the Order box of the dialog box.
  • Other
    Enabled when Top or Bottom is selected from the Select N drop-down list. Select 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 box.

Cancel

Discards the changes and closes the dialog box.

Help

Displays the help document about this feature.

BackPrevious TopicNext TopicNext

Was this article helpful?