Series Options dialog

This dialog appears when you click the Top N button above the Series box in the Bind Data screen of chart in the Web Report Wizard, Insert Chart dialog, Chart Wizard, or To Chart dialog. It helps you to set the sort order of the series values and define the number of the series values that will be displayed in the chart. See the dialog.

Series Order

Specifies in which order data on the series axis 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 in database.

Series Selection

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

Select
Specifies the Select N condition to define the number of series values that will be displayed.
- All
  If selected, all series values will be displayed.
- Top N
  If selected, specify a number in the field to the right and the first N series values will be displayed.
- Bottom N
  If selected, specify a number in the field to the right and the last N series values will be displayed.
Based On
If checked, the series values will be sorted by values of the summary selected with the direction specified. If unchecked, the series values will be sorted by the order specified in the Series Order box of the dialog.
Remaining Series In
Enabled only when Top N or Bottom N is selected from the Select drop-down list. Check this option and then type a character string in the text field to group all the series values beyond the top/bottom N range.
Skip First
If you check the Skip First option and input a number M in the text field 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.

Accepts the changes and closes the dialog.

Cancel

Discards the changes and closes the dialog.

Help

Displays this help document.