Skip to main content

Symmetric Bar Chart

Features: It is a type of bar chart that supports symmetric comparison based on two categories of data. It can show the differences between data more clearly and intelligently.

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

Example: In the worksheet Sales Order, create a chart to count and analyze the revenue and refunds for this year​

Data Range: [Sales Time] (this year)

X-axis: Select the field [Sales Time]

Time Granularity: By Store, that is, to count the overall revenue and refunds of the store

Direction 1/2: Sales and refund amount (revenue is displayed above the X-axis, while refund is displayed below the X-axis)

Configuration Steps​

1. Create a new chart​

2. Set the data source​

You can select a view or all records.

Time range: [Sales Time] (this year)

If you need to filter further, you can add filter conditions.

3. Set the X-axis​

Select the field [Store].

Note: Click [Rename] to edit the name of the field.

4. Set the direction 1/2​

The total amount of sales is displayed above the X-axis, and the refund amount is displayed below the X-axis.

5. Direction​

You can set the display direction of the symmetric bar chart, whether it is horizontal or vertical. Click [Save] to finish the chart configuration.