Stacked Column Chart

Application Scenario

The stacked column chart, also known as the yamazumi chart in the manufacturing industry, is suitable for comparing the total amount of data in each group, reflecting the sizes of values of each series within the group. The following figure shows the effect.

Chart Feature

• Advantage: The chart intuitively displays the values of different series of different categories and compares the data volume of different categories.

• Disadvantage: The chart is unsuitable for scenarios with too many series.

Data Preparation

Choose File > New General Report, and select Refresh Technology as the template theme.

Create a database query named ds1, and enter the SQL statement SELECT * FROM Sales_Volume WHERE Region='Eastern China' to extract the data in Eastern China from the Sales_Volume, as shown in the following figure.

Report Design

Chart Insertion

Merge the required cells, click the Insert Chart icon, and choose Column Chart > Stacked Column Chart, as shown in the following figure.

Data Binding

Select the chart, click the Cell Element icon on the right property panel, and select Data. Select Dataset Data from the drop-down list of Data Source, select ds1 from the drop-down list of Dataset, select Salesperson from the drop-down list of Category, select Product from the drop-down list of Series, select Sales_Volume from the drop-down list of Value, as shown in the following figure. (Namely, the accumulated sales volumes of all the products of a salesperson form the total sales volume.).

Chart Style Setting

1. Title Setting

Select the chart, choose Cell Element > Style > Title, enter Stacked Column Chart, and remain the default setting of other items, as shown in the following figure.

2. Series Style Setting

Select the chart, choose Cell Element > Style > Series, set Gradient Style to Off, and set Line Style to None in the Border setting area, as shown in the following figure.

Label Setting

Select the chart, choose Cell Element > Style > Label, select Use Label, select Common and value in the Content setting area, and set Position to Inside in the Layout setting area, as shown in the following figure.

Effect Display

PC

Save the template and click Pagination Preview. The section "Application Scenario" shows the effect.

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 Column Chart.cpt.