Contrast Column Chart

Version

Application Scenario

Contrast column charts are a variation of bar charts in which bars are placed back to back. They are mainly used for a comparative analysis of two indicators within the same dimension, making it easier to see the clear contrast difference. The following figure shows the comparison of voting results in major states of the U.S. during the presidential election. Red represents the Republican Party and blue represents the Democratic Party.

Basic Requirement

Basic requirements for contrast column charts are as follows.

Chart Feature

Advantage: Contrast column charts can clearly compare the data differences of different indicators in the current dimension because they are most commonly used for comparing two indicators with opposite meanings.

Disadvantage: Contrast column charts are only suitable for data without too many dimensions.

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. Click Local Excel and click Upload Data, as shown in the following figure. 

You can download the example data. U.S. Election Vote Data.xlsx

3. After the data is uploaded, click OK.

Component Creation

1. Click Component in the lower left corner.

2. Drag the State field into the Dimension bar and the Total votes-democrat and Total votes-republican fields into the Indicator bar respectively, and click the Contrast Column Chart icon in Chart Type. 

Note:

Drag the fields first and then select the chart type. After you click the Contrast Column Chart icon, the Dimension and Indicator bars will be changed to the Horizontal Axis and Vertical Axis.

3. Rename the component Contrast Column Chart.

Component Beautifying

1. Color Setting

Drag the Indicator Name into the Color bar under All and click the icon to set the Scheme to Light for Finance, as shown in the following figure. 

You can set the parameters of Size, Label, Prompt, and Fine-grained. For details, see Graphic Properties.

You can also set the parameters of Legend, Grid Line, Background, Adaptation Display, and so on for the component. For details, see Chart Component Style.

2. Field Setting in Analysis Area

Click the icon   of the Total votes-democrat and Total votes-republican fields respectively, select Set Value Axis from the drop-down list, select Custom, click Maximum, enter 110000000 in the pop-up box, and click OK, as shown in the following figure.

3. Value Format Modification

Click the icon   of the Total votes-democrat and Total votes-republican fields respectively, select Value Format from the drop-down list, select Million in the Quantity Unit, and click OK, as shown in the following figure.

At the same time, you can set the Summary Mode, Quick Calculation, Value Format, Special Display, and Analysis Line for the chart.

Effect Display

On PC

On Mobile Terminals

Displaying Two Indicator Fields Separately

Description

Two indicator fields are dragged into the horizontal axis and one dimension field is dragged into the vertical axis. The chart effect is shown in the following figure.

However, you want to display two indicator fields separately on the chart, with the final effect being two bar charts back to back.

Solution

Method One

Click the Contrast Column Chart icon in Chart Type. 

Method Two

1. Set the horizontal and vertical axes to Indicator Juxtaposition, as shown in the following figure.

2. Click the icon of the first indicator field on the horizontal axis, select Set Value Axis from the drop-down list, and tick the Axis Reverse Order, as shown in the following figure.