Previous Topic  Next Topic

Order/Select N Dialog Box Properties

You can use the Order/Select N dialog box to set the sort order and the Select N condition in a chart. This topic describes the options in the dialog box.

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.

Previous Topic  Next Topic