Stacked Column Chart

Version

Application Scenario

The stacked column chart can show the proportions of subdivisions in larger categories by splitting each column. The chart can directly display the value of each indicator and the dimension sum. You can use the stacked column chart in the following scenarios.

• You need to show the comparison of the traffic obtained from different channels of a product within a week.

• The sales department has three subdivisions: sales department A, sales department B, and sales department C. You need to calculate the proportion and change of each subdivision's contribution.

Basic Requirement

Note:

You can also drag the dimension field into the Color column to achieve the stacking effect. For details, see Chart Color.

Chart Figure

Advantage: The chart can clearly display the value of different indicators in each dimension to help you compare the data volumes of different dimensions.

Disadvantage: The multi-series column chart is unsuitable for data with too many dimensions.

Data Preparation

1. Log in to the system as the admin, click My Analysis, click a folder, and click New Subject.

2. Click Local Excel and click Upload Data, as shown in the following figure.

Download the sample data: Week Traffic Data.xlsx.

3. After the upload, click OK.

Component Creation

Click Component in the lower left corner.

Chart Generation

Drag the Day field into the dimension column and the fields Direct Access, Email Marketing, Affiliate Advertising, Video Advertising, and Search Engine into the indicator column, and select Stacked Column Chart in Chart Type, as shown in the following figure.

Note:

The Stacked Column Chart icon can be selected only when at least one dimension field and at least two indicator fields exist in the horizontal and vertical axis respectively, otherwise the icon in Chart Type is grayed out and cannot be clicked.

Sort Based on Day

Method One: Custom Sort

1. Hover the cursor over the Day field on the horizontal axis, click the drop-down icon on the right, and set the custom sort.

Method Two: Sort Based on the No. Field

1. Drag the No. field into the Fine-grained column, as shown in the following figure.

Note:

You need to perform the operation (which does not affect the chart display effect) because the indicator field on which the sort depends must be in the analysis area.

2. Hover the cursor over the Day field on the horizontal axis, click the drop-down icon on the right, and choose Ascend > Number (Sum).

Chart Beautifying

The graphic properties set in All apply to all indicators; the graphic properties set in the individual indicator only apply to that indicator.

Setting the Label

1. Drag the indicator fields Direct Access, Email Marketing, Affiliate Advertising, Video Advertising, and Search Engine respectively into Label under the column with the same name as the indicator filed in Graphic Property, as shown in the following figure.

Note:

For details about how to modify the label font style and color, see Chart Label.

2. Click Label in All and set Label Location to Center.

Setting the Color

Click Color in All and select the color scheme Green.

Note:

For details about style settings, see Graphic Property and Graphic Component Style. For details about axis settings, see Setting the Category Axis on Charts and Setting the Value Axis on Charts.

Effect Display

On PC

The following figure shows the preview effect on PC.

On Mobile Terminals

The following figure shows the preview effect on the DataAnalyst app and in HTML5.

Problem

If the value of an indicator is 0, the indicator will also be displayed in the stacked column chart.

Solution

Convert 0 to the null value.

Click the drop-down icon, click Add Calculation Indicator, and enter a function. For example, use calculation indicators to remove 0 from Direct Access and Email Marketing and form new indicators Direct Access 1 and Email Marketing 1, as shown in the following figure.

Effect Display

Use Direct Access 1 and Email Marketing 1 to make the stacked column chart. The following figure shows the effect.