Aligning Zero Tick Marks on Left and Right Axes

Problem

Sometimes, the zero tick marks on the left and right axes may not align horizontally, as shown in the following figure.

How to align the zero tick marks on the two axes horizontally?

Implementation Method

To align the zero tick marks horizontally in FineBI, you only need to ensure that the maximum-to-minimum ratios of the two axes are the same.

Data Preparation

1. Log in to the system as the admin, click My Analysis, select a folder, and click New Subject, as shown in the following figure.

2. Choose Local Excel > Upload Data, and upload the table data, as shown in the following figure.

Sample data: Banking Institution Indicator Data.xlsx

3. Click OK after the data is uploaded, as shown in the following figure.

Component Creation

1. Click the Component button in the lower left corner, drag the PA product name field into the horizontal axis, and drag the Net profit after tax_Complete profit and External interest net income fields into the vertical axis to create a column chart - line chart. For details, see Column Chart - Line Chart.

2. Set the right-value axis. For details, see Setting Two Y Axes for Charts.

In this case, the zero tick marks on the left-value and right-value axes do not align horizontally.

Aligning the Zero Tick Marks Horizontally

Since the maximum-to-minimum ratio of the right-value axis is -7 (70,000/-10,000) in this example, set Max Value to 1400000 and Min Value to -200000 for the left-value axis, as shown in the following figure.

Dashboard Adding

Create a dashboard and add the component to the dashboard, as shown in the following figure.

The following figure shows the effect.