Setting Two Y Axes for Charts

Problem

When you encounter the following problems:

1. Multiple indicators on one vertical axis impair data clarity.

2. You want to use two Y axes to show values and percentages separately.

3. Two lines have similar values and are overlapping.

You can refer to the solutions in this document.

Solution

Drag two indicator fields into Vertical Axis, and select Right-value Axis as Shared Axis when setting value axis of the second indicator field.

Note:

Before setting the right-value axis, you must make sure Vertical Axis is an indicator aggregation.

This document takes a column chart as an example.

Data Preparation

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

2. Choose Local Excel > Upload Data to upload the table data.

Sample data: Contract Information.xlsx

3. After the data is uploaded, click OK, as shown in the following figure.

Component Creation

1. Click Component in the lower left corner, as shown in the following figure.

2. Select Custom Chart in Chart Type and select Column Chart in Graphic Property. Drag Country into Horizontal Axis. Drag Contract Amount and Payment Amount into Vertical Axis, as shown in the following figure.

3. To differentiate the colors of the indicator fields, drag Indicator Name into the Color bar, as shown in the following figure.

Setting Two Y Axes

Note:

To set Y axis labels, scales, titles, etc., see Setting Chart Value Axis.

1. Hover your cursor on Payment Amount in Vertical Axis, click , and click Set Value Axis(Left-value Axis), as shown in the following figure.

2. Select Right-value Axis as Shared Axis, as shown in the following figure.

3. The column chart now has two Y axes, as shown in the following figure.

Setting the Value Format of Y Axes

1. Hover your cursor on Contract Amount in Vertical Axis, click , and click Value Format.

2. Select Million as Quantity Unit, as shown in the following figure.

3. Follow the same steps to set the numeric format for Payment Amount. Select Million as Quantity Unit.

Effect Display

1. PC

The following figure shows the effect.

2. Mobile Terminal

The following figure shows the preview effect on the DataAnalyst app and the HTML5 terminal.