X-Axis aligned with 0 in Column Chart

1. Application scenarios

When the axis label position of X axis is set to 0, the axis label of X axis will be aligned with 0, as shown in the following figure:

2. Idea to achieve

Set axis label position: select style > Axis > X axis in property panel to set axis label position to 0.

1. Data preparation

New general report, new database query DS1: select Payment date, Balance - 20000 as balance, Payment - 6000 as payment from BillDetail limit 6

2. Design report

1）Merge a cell, click Insert > cell element > insert chart, and select the column chart (new feature), as shown in the following figure:

2）In the property panel, click data to bind column chart data, as shown in the following figure:

3）Select style > Axis > X Axis to set the axis label position to 0, as shown in the following figure:

4）Select style > series > stack and axis, and click add, as shown in the figure below:

5）As shown in the figure below, set the axis label position for y axis 2 to right

3. Effect preview

1）PC terminal

Save the template and click pagination preview. The effect is as follows:

2）Mobile

Completed template, please see %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Chart\ColumnAndBar\XAxis_0.cpt

Click to download the template:

XAxis_0.cpt