PivotCategorySet

The PivotCategorySet data collector is an extension of the CategorySet data collector that will pivot the data to use a column of values as series, rather than individual columns themselves. This means that at a minimum, you will need a column from which the collector will retrieve the series names, and any number of additional numeric data columns that will serve as categories. The data values to be plotted for each series are the category columns' values.
Property Description
name A title for this data collector configuration. Typically you will only have one data collector per chart, in which case this property is not particularly useful.
category-columns The names of the columns you want to use to determine category names.
value-columns The data columns that determine the chart values (or series items).
series-by-value A static value that you want to use for the series name.
series-by-field Uses the selected column to use for series names. This will cause the value column to be split into series groups.
group-by This provides the name of the group that the chart is appearing in. If the chart contains detailed information, then this is not necessary.
reset-group Specifies a group that will be used to create charts within a sub-group. For example, if charting one chart per region, and the chart is displaying data for departments within a region, the reset-group would be set to the region group, and the chart group would be set to department group.
An example of a chart using the PivotCategorySet data collector.

In the above bar chart, Executive Management, Finance, and Human Resources (the yellow, blue, and red bars, respectively) are the series -- values taken from the series column DEPARTMENT. The categories Actual and Budget supply row-based data points for each series.