Overview
Application Scenario
In stacked percentage column charts, each layer of the column represents the percentage of each category's data to the total data in the group. Each series is stacked based on its percentage, allowing you to directly view each series' proportion. The following figure shows the effect.
Chart Feature
Advantage: The chart clearly shows the proportion of each series under each category.
Disadvantage: Too many stacks may make the data difficult to differentiate. Therefore, the chart is unsuitable for displaying too many series.
Example
Data Preparation
Choose File > New General Report, create a database query ds1, and enter the SQL statement SELECT * FROM Sales_Volume, as shown in the following figure.
Report Design
Chart Insertion
Merge required cells, click the Insert Chart icon, and choose Column Chart > Percentage Stacked Column Chart, as shown in the following figure.
Data Binding
Select the chart, choose Cell Element > Data, and bind the data from ds1 to the chart. Select Region from the drop-down list of Category, Product from the drop-down list of Series, and Sales_Volume from the drop-down list of Value, to stack the proportions of all products sales in one region, as shown in the following figure.
1. Title Setting
Select the chart, choose Cell Element > Style > Title, enter Stacked Percentage Column Chart in Text, and select left for Position, as shown in the following figure.
2. Label Setting
Select the chart, choose Cell Element > Style > Label, select Use Label, select Percentage for Text in the Common setting area, and select Center for Position in the Layout setting area, as shown in the following figure.
Effect Display
PC
Save the template and click Pagination Preview. The effect is the same as the that shown in section "Application Scenario."
Mobile Terminal
The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the display effect.
Previous：Column Chart
