Previous Topic
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
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.
- All
- 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.