Column Chart with Multi-Category Axes

Version

Application Scenario

You can add multi-category axes to the three built-in combination types of combination charts, column charts, bar charts, line charts, and area charts, supporting up to three levels of categorization for more utility.

Function Description

1. In the chart property panel, select Data and click which is behind Category to add a category. You can add three categories at most.

2. The order of category display: The category added in the first level corresponds to the bottom-level category data closest to the displayed chart, and the further down, the corresponding parent-level data.

3. The order of categories in each level will be consistent with the order of the category in the dataset, as shown in the following figure.

4. For the designer of version 11.0.3 and later versions, the axis label of the category axis support Display Logic setting, where you can select Whole Display or Layered Display.

• Whole Display: You can set Display Mode, Character, Text Rotation, and Label Gap of the axis label. Those settings can be applied to all categories.

• Layered Display: You can decide whether or not to display the category axis label by selecting or deselecting. You can click the setting button corresponding to each category to set the axis label style separately, as shown in the following figure.

Data Preparation

Create a general report and create a dataset named ds1. The SQL statement is SELECT * FROM Sales_Volume.

Report Design

Column Chart Insertion

Merge required cells, right-click the mouse, and choose Cell Element > Insert Chart to insert a column chart, as shown in the following figure.

Data Binding

Choose Cell Element > Data, select ds1 as Dataset, and add three categories: Product_type, Salesperson, and Region. Select Product for Series, Sales_Volume for Value, and Sum for Summary, as shown in the following figure.

Style Setting

This example shows the setting method of Layered Display for category axis label only. Other settings of chart styles can be set as needed.

Choose Style > Axis, and the category axis of the column chart is X Axis.

Select Layered Display for Display Logic of the axis label. Click the Setting button on the right side of Category1, set Text Rotation to 90, and deselect Category3 to hide it.

Note:

Category1 refers to the category closest to X Axis, which in this example is the Product_type field, and Category3 refers to the Region field.

Effect Display

PC

Save the template and click Pagination Preview. The following figure shows the effect.

Mobile Terminal

The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the effect.

For details, you can download the template Column Chart with Multi-Category Axes.cpt.