BackPrevious Topic  Next TopicNext

Series Options Dialog Box Properties

This topic describes how you can use the Series Options dialog box to set the sort order of the series values and define the number of the series values to show in a chart.

Server displays the dialog box when you select the Top N button Top N button above the series box in the Chart Wizard, Insert Chart dialog box, Convert to Chart dialog box, or To Chart dialog box, or the Bind Data screen of chart in the Web Report Wizard.

Series Options 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 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.
  • Remaining Series In
    Enabled 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 type a number M in the Skip First text box, 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.

OK

Accepts the changes and closes the dialog box.

Cancel

Discards the changes and closes the dialog box.

Help button

Displays the help document about this feature.

Close button

Ignores the selection and closes this dialog box.

Back to top

BackPrevious Topic  Next TopicNext