Series Options Dialog Box

The Series Options dialog box helps you to specify the sort order of the series values and define the number of the series values to show in a chart. It appears when you select the Order/Select N button below the series box in the Display screen of the chart wizard.

Series Options dialog box

The following are details about options in the dialog box:

Series Order

Specifies in which manner to sort the series values.

Ascend
Values will be sorted in an ascending order (A, B, C).
Descend
Values will be sorted in a descending order (C, B, A).
No Sort
Values will be sorted in the original order in database.

Series Selection

Specifies the number of series values that will be displayed in the chart.

Select
Specifies the Select N condition to define the number of the series values that will be displayed.
- All
  Specifies to display all series values in the chart.
- Top N
  If selected, specify a number in the field to the right and the first N series values in the chart will be displayed. You can also select a parameter from the drop-down list, which returns an integer, and then specify a value for the parameter when viewing the report to dynamically define the Top N condition.
- Bottom N
  If selected, specify a number in the field to the right and the last N series values in the chart will be displayed. You can also select a parameter from the drop-down list which returns an integer, and then specify a value for the parameter when viewing the report to dynamically define the Bottom N condition.
Based On
If the option is selected, you can select a field added to the value axis of the chart to sort the series values based on this field, or select Custom Sort to customize the sort manner in the Custom Sort dialog box.
- Ascend
  Sorts the series values based on the select field in an ascending order.
- Descend
  Sorts the series values based on the select field in a descending order.
Remaining Series In
Enabled only when Top N or Bottom N is selected from the Select drop-down list. Select this option and then type a character string in the text box to group all the series values beyond the top/bottom N range.
Overall Series
Not supported on series values.
Skip First
If you select the Skip First option and type a number M in the text box to the right, then the first M series values in the chart will be skipped and the Select N condition will take effect beginning with M+1. The skipped values will be included in the Remaining Series group together with all the series values beyond the top/bottom N range. Enabled when Top N or Bottom N is selected from the Select drop-down list.

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