Stacked Percentage Bar Chart

Version

Application Scenario

Stacked percentage bar charts are suitable for displaying the percentage that each part of the data accounts to the whole, and are particularly useful for comparing the relative sizes of different categories.

You can use stacked percentage bar charts to show the proportions of different parts to the current whole and compare them, and the proportional difference between the data can be shown more clearly.

Chart Feature

Advantage: Stacked percentage bar charts can clearly demonstrate the relative proportion of each part with intuitive bar splits, so that you can compare the relative importance of different categories easily.

Disadvantage: Excessive data categories may make the charts complex and difficult to differentiate and understand, and the charts are less intuitive than traditional bar charts in comparing absolute values.

Data Preparation

Choose File > New General Report in the upper left corner of the designer, and create a dataset ds1. The database query statement is as follows:

SELECT Category_Name, Inventory_Quantity, Order_Quantity, Reorder_Quantity FROM Product, Category

WHERE p.CategoryID = c.CategoryID AND Category_Name != 'Daily necessities'

ORDER BY Category_Name.

Chart Insertion

Merge required cells, click Insert Chart on the upper toolbar, and choose Bar Chart > Percentage Stacked Bar Chart. /

Chart Design

Select the chart, click the Cell Element icon on the right property panel, and set the properties (Type, Data, Style, and Special Effect) for the chart.

Chart Type

Select the cell where the chart is located and choose Cell Element > Type to view and select the chart type.

Data Binding

1. Select the chart and choose Cell Element > Data on the right property panel.

2. Bind the data in the Dataset. Select ds1 for Dataset, Category_Name for Category, Field Name for Series Name (Inventory_Quantity and Order_Quantity fields), and Sum for Summary.

Chart Style Setting

Select the chart, choose Cell Element > Style > Title, and enter Stacked Bar Char. Other settings remain as the default settings. 

Effect Display

PC

Save the report and click Pagination Preview. The effect is same as 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.

For details, you can click to download the template Stacked Percentage Bar Chart.cpt