Stacked area chart

The stacked area chart typically uses three data dimensions, or variables, to compare trends or changes over time for two or more categories. Categories are non-quantitative data elements such as customers, vendors, departments, branches, merchant category codes, transaction types, statuses, and so on. A single, quantitative category can also be plotted using a stacked area chart.

In addition to comparing changes over time, the stacked area chart also shows the proportion of the total that each category represents at any given point in time. Each category is represented by an area, differentiated by color. The areas are stacked, and for each increment on the horizontal axis they vary in width in accordance with the percentage of the vertical-axis total they represent. The top edge of each stacked area represents the cumulative total of that category and all the categories beneath it.

The stacked area chart in Figure 1 uses two data dimensions to show total daily transaction amount. The stacked area chart in Figure 2 uses three data dimensions to compare the total daily transaction amount for each customer.

Table 1 provides additional details about stacked area chart configuration settings.

Figure 1. Stacked area chart with two data dimensions (Transaction Date and Amount)

 

Figure 2. Stacked area chart with three data dimensions (Transaction Date, Amount, and Customer Number)

 

Table 1. Stacked area chart configuration settings

Setting

Data types supported

Example field

Description

X-Axis

(horizontal)

Datetime

Numeric

Transaction Date

Specifies the field to use as the basis for the chart’s horizontal scale. Typically, a date field is used as the basis for the X-Axis.

Y-Axis

(vertical)

Numeric

Amount

Specifies the field to use as the basis for the chart’s vertical scale.

The position of data points on the vertical scale determines the width of each stacked area, and the cumulative height of the stacked areas. The width of an area is interpolated if a data point is missing.

Total (sum) is the default aggregation option. The Y-Axis field also supports average, minimum, maximum, or count aggregation options. For more information see About visualizations.

Color by

(optional setting)

Character

Customer Number

Specifies the field to use to add a third data dimension to the chart.

Adding a third data dimension creates the categories represented by stacked areas. A separate stacked area is created for each unique value in the field.

The Color by setting provides the following options:

  • If you omit a Color by field, a single area representing all categories is displayed on the chart.

  • If you specify a Color by field, separate stacked areas, differentiated by color, are displayed for each unique value in the field.

Related concepts
About visualizations
Related tasks
Creating charts


(C) 2015 ACL Services Ltd. All Rights Reserved.