Stacked Columns Chart

The Stacked Columns Chart shows the contribution to trends in the data. This is done by stacking lines on top of each other. Stacked Line charts are used with data that can be placed in an order, from low to high. The charts are used when you have more than one data column that all adds up to the total trend.

Datamodel

The Stacked Columns Chart uses a single list or filtered list for its source values. This list has the fields for the Series and Categories on each row. From this list a field is selected for the 'Values', the widget will then iterate over this list and use the indicated field to generate the values shown in the widget. This field must be numeric type. The categories and series properties are then set to respective category and series field from the source list. So this list will contain the following:

1. Numeric field, for holding the values to show on the stack - per specific category and series

2. Text field, to hold the specific Category value that is displayed along the other axis from the values: for example, the Month Name to show values per month.

3. Text field, to hold the specific Series value for which the Value should be applied (like years, and if they hold a numeric value, just use the ToString([field]) in the widget property) for example to show the different Total Values for the same month in Categories but with a different color per year.

Properties of Stacked Columns Chart