Stacked Column Chart - Single Indicator

Version

Application Scenario

Each column of each category is stacked by several series, and the total height of the column is the sum of the several series. The stacked column chart can be used to compare data from different series within the same category. Besides, the chart can also be used to compare the total data between different categories. You can use the stacked column chart in the following scenarios:

• Compares the sales of different products in different regions

• Compares the performance of different departments or teams in a certain indicator (such as sales and profit), as well as compares the data changes of the same department or team in different periods

• Compares the total sales of different regions and observes the product sales in each region

Basic Requirement

Chart Feature

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: Stacked column charts are only suitable for data without too many dimensions.

Data Preparation

Create a new analysis subject, choose Local Excel > Upload Data, and upload the sample data, as shown in the following figure.

Sample data: Office Supplies Data.xlsx

Component Creation

Click Component in the lower left corner, as shown in the following figure.

1. Click Component.

2. Select Column Chart in Chart Type.

3. Drag Region and Sales from the left to-be-analysed area into the horizontal and vertical axes of the analysis area.

4. Drag Classification into the color bar, and each column will be displayed in different colors according to different product classifications, as shown in the following figure.

Chart Beautification

1. Display the categories with the fewest sales above the column, which is more consistent with your visual habits.

2. Sort the regions in descending order by sales amount, as shown in the following figure.

3. Change the color of the bar chart by clicking the settings button in the color bar, as shown in the following figure.

Effect Display