Stacked Area Chart

Version

Application Scenario

The general area chart is a type of chart used to display the changes of data over time or other ordered categorical variables, while the stacked area chart can also show the relationship between parts and the whole of the data.

Stacked area charts can visually display the cumulative and relative sizes of various indicators by stacking the values of each category in a certain order to form a whole area.

For example, you can use a stacked area chart to show how Order Quantity and Inventory of different categories of products contribute to Total Amount, as shown in the following figure.

Implementation Method

Use Custom Chart, select Area in the drop-down list under Graphic Property, and select Enable Stacking for the vertical axis indicator field.

Basic Requirement

Chart Feature

1. Advantage

• Stacked effect: The values of each data series are stacked on the Y axis to create an accumulation effect, and the entire area of chart is composed of the stacked data series.

• Displaying accumulation and proportion: Stacked area charts can not only display the cumulative total of each category, but also display the proportion that each part occupies in the total amount.

2. Disadvantage

• Increased complexity: When numerous variables are stacked, the chart may become too complex to read and understand.

• Difficult to analyze individual data series: Stacked area charts are not suitable for analyzing the changes of each data series over time individually, because each series is based on the cumulative value of the previous series.

Data Preparation

1. Log in to FineBI, click My Analysis, select a folder, and click New Subject, as shown in the following figure.

2. Choose Local Excel > Upload Data, as shown in the following figure.

Sample data:Area Chart Data.xlsx

3. Click OK after the data is uploaded, as shown in the following figure.

4. Click Save and Update to complete the data creation, as shown in the following figure.

Component Creation

1. Click Component in the lower left corner.

2. Select Custom Chart in Chart Type, and select Area from the drop-down list under Graphic Property.

3. Drag Category from the left to-be-analyzed area into the horizontal axis, and drag Order Quantity and Inventory into the vertical axis, as shown in the following figure.

4. Click the drop-down icon of Order Quantity and Inventory respectively on the vertical axis, and select Enable Stacking to enable the stacking effect, as shown in the following figure.

Component Beautification

Color Setting

Drag Indicator Name from the left to-be-analyzed area into the Color bar under Graphic Property > All. Different indicators will be displayed in different colors, as shown in the following figure.

Label Setting

1. Drag Order Quantity in the left to-be-analyzed area into the Label bar under Graphic Property > Order Quantity, as shown in the following figure.

2. Click the Label setting icon under Order Quantity, click the edit icon for content format in the pop-up setting box, enter Order Quantity:, and click OK, as shown in the following figure.

3. Drag Total Amount and Inventory in the left to-be-analyzed area into Graphic Property > Inventory, as shown in the following figure.

4. Click the Label setting icon under Inventory, click the edit icon for content format in the pop-up setting box, enter Total Amount: Inventory:, and click OK, as shown in the following figure.

Dashboard Creation

1. Click the Add Dashboard button at the bottom of the editing page of the analysis subject.

2. Drag the component into the dashboard on the dashboard editing page, as shown in the following figure.

3. Select Edit Title from the drop-down list, set Font Style to Custom, enter the title as Stacked Area Chart, and click OK, as shown in the following figure.

Effect Display

PC

Mobile Terminal