Stacked Column Chart

1) Stacked Column Chart is a detailed form of data visualization that layers data in columns on top of each other to represent cumulative totals. This chart type is crucial for showing the proportion of each value to a total across categories, making it easier to understand part-to-whole relationships within data. 

2) Stacked Column Charts are particularly beneficial for visualizing complex datasets in a compact form, aiding in quick comparisons and trend recognition in business and analytical contexts. They allow decision-makers to efficiently track changes and distributions within grouped data, enhancing strategic planning and reporting.

3) Version：

4) Application Scenario： The stacked column chart effectively illustrates the proportions of subcategories within broader categories by segmenting each column. This visualization enables the direct display of each metric's value alongside the total for each dimension. Stacked column charts are particularly useful in scenarios where understanding the contribution of individual components to the whole is critical, enhancing clarity and insight in data analysis.

• 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.

5) Basic Requirement：

Note:

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

6) 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.

In conclusion, the stacked column chart is a versatile and informative visualization tool that effectively communicates complex data by displaying proportions within larger categories. It is particularly valuable for identifying trends and making comparative analyses between different groups. This chart type enhances data interpretation, aiding stakeholders in making data-driven decisions by providing a clear and concise visual representation of multiple layers of information.