Custom Column Chart

Version

Application Scenario

When standard column charts cannot meet your specific needs for data presentation, you can use custom column charts to customize multiple axes.

Chart Feature

Advantage: The high flexibility and creativity of custom column charts allows you to meet the needs that regular column charts cannot meet through self-designing.

Disadvantage: Improper design of custom column charts may reduce the clarity and readability of the data.

Data Preparation

Choose File > New General Report in the upper left corner of the designer, and create a Built-in Dataset, as shown in the following figure.

Chart Insertion

Merge required cells, click the Insert Chart icon on the upper toolbar, and choose Column Chart > Custom, as shown in the following figure. 

Chart Design

Select the chart, click the Cell Element icon on the right property panel, and set the properties (Type, Data, Style, and Special Effects) 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

Click Data and bind required data to the chart, as shown in the following figure.

Style Setting

Select the chart, choose Cell Element > Style > Title, and enter Operation in Q1, as shown in the following figure.

Series Setting

1. Choose Style > Series, select Theme for Color Scheme, select None for Line Style, set 5px for Rounded Corner, and add Stack and Axis1 and Stack and Axis 2, as shown in the following figure.

2. Set Stack and Axis 1:use Y Axis to display Total Profit Margin and Sales_Volume effectively due to the large difference in numerical values between them.

Select Y Axis 2 and set Series Index Equal to 3 in Common Condition, as shown in the following figure. /

3. Set Stack and Axis 2:use stacked columns to display sales volume of the two products more concisely and intuitively than using two separate columns.

Select Y Axis, select Yes for Stacked, and set Series Index Equal to 1 or Series Index Equal to 2 in Common Condition, as shown in the following figure.

Axis Setting

Choose Cell Element > Style > Axis to set the properties of the axis.

In this example, you need to set Y Axis 2 to display the Total Profit Margin as percentage, as shown in the following figure. 

Effect Display

PC

Save the report 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 Custom Column Chart.cpt.