Specifying data series options

You can specify which columns of a result set are used to generate data points of a chart on the Data series page of the New Chart wizard.

1. To specify the column that will populate the category axis, select a column from the Result set tree and click Add to category.
   The column is added to the Category Axis node of the Series tree.
2. To specify a column that will be displayed as a value, select a column from the Result set tree and click Add to value.
   The column is added to the Values node of the Series tree.
3. Select aggregation type for value column from the Aggregation drop-down list. Valid options are:
   • No aggregation
   • Count
   • First
   • Last
   • Maximum
   • Minimum
   • Sum
   • Average
   • Standard Deviation
4. Specify the way of aggregating a value column by selecting or clearing the Calculate as formula check box.
   The Calculate as formula check box is available only if you use a calculated column as a value. The expression you have specified for the calculated column is used as aggregation formula.

   If you select the Calculate as formula check box, the fields of the columns that provide data for calculated column (and thus for value column) are aggregated at first. The formula uses already aggregated field values as arguments to calculate the result value.

   If you clear the Calculate as formula check box, the defined formula calculates the value column fields separately. After the calculations the fields are aggregated to calculate the result value.

5. To remove a column from the series tree, select the column and click Remove. The column is added back to the Result set tree.