Skip to main content

Biaxial Chart

Features: A biaxial chart is a chart with multiple (≥2) Y-axes. It is generally a combination of a column and a line chart, and the chart is more intuitive. In addition to analyzing two sets of data with large differences, biaxial charts are also suitable for trend analysis of data, etc.

The following is an example of how to create a biaxial chart.

Example: In the worksheet Orders, analyze the trend of sales and profit amount of new orders​

Data Range: Filter the orders that were closed during this month.

X-axis: Select the field [Date signed].

Time Granularity: By day, which means one value corresponds to each day (granularity is only required when the date field is selected for the X-axis).

Left Y-axis: sum of sales for this month; Right Y-axis: sum of profit for this month.

Configuration Steps​

1. Create a new chart​

Enter the configuration page of the chart.

2. Set the data source​

Time range: [Date signed] (this month).

If need further filtering, you can add filtering conditions.

3. Set the X-axis​

Selected field: Date signed; Time granularity: day

4. Set the left Y-axis / right Y-axis​

Left Y-axis: sum of sales; Right Y-axis: sum of profits

  1. For the left Y-axis, you can choose either a column chart or a line, while for the right Y-axis, it is fixed to a line chart. x-axis can only choose one field, while for the Y-axis you can choose multiple fields of value type or choose a field to split.

  2. The left Y-axis corresponds to a bar chart, and the right Y-axis corresponds to a line chart by default.

  3. When both left and right Y-axis correspond to line chart, only one field each for left and right Y-axis is supported. When the fields of Y-axis are increased, left Y-axis will correspond to column chart.

5. Save​

Save the configuration of the chart.