Setting up auto-series

You can set up the chart so it will create new series automatically, depending on data in a data source. To set up auto-series, do the following:

• create one series and set up its properties. This series will be used as a template for all new series;
• select "Chart" object and set up the auto-series data column. The value of this column will be a name of new series. If there is no series with such name yet, the new series will be added.

Let us demonstrate how to create auto-series. We will use the MatrixDemo data table to get a chart of employee's sales per year. One series will represent one year. To do this:

• connect the chart to the MatrixDemo data source;
• create one series and set up its data:

• on the "Data processing" tab, check the "Group by X value" checkbox. It is necessary because our data source has several employees with the same name;
• select the chart in the series list and set up its auto-series column on the "Data" tab:

• our series may have different number of values (because some employees do not have sales in this particular year). To align series values, check the "Align X values" checkbox.

We will get the following result: