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.

## About this task

To specify the data series options of a chart:
## Procedure

- 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.

- 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.

- 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

- 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.

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