All tagged Tips and Tricks

Dual Axis Chart in Tableau - 3 Methods

Comparison charts are very common and most important charts for any data. Tableau also can create some very special comparison charts. One such widely used and popular chart in excel and other BI tools is a Dual Axis Chart or referred to as Combo Chart (Involves the combination of 2 charts).

We focus on 2 measures where one measure is superimposed over another measure. Many of us assume that the second measure is placed above the first measure. It is not above, it is on (One behind another).

Any other comparison chart that we build in Tableau needs the same scale for comparison. But Dual Axis (The word itself is very intuitive – 2 Axes: one for each measure) allows for the use of different measures. In many cases, Dual Axis is used for Time Series.

KPI shapes on the left of Bar Chart in Tableau

KPIs (Key Performance Indicators) drive a lot of business decisions. Showing bold and big font numbers on a Dashboard are good practices for visualization. But color coding them will take it to the next level because colors appeal to the end users more by adding the “wow” factor. Using shapes to represent the KPI will seal the deal making the best approach. Scientifically, human brain is tuned to understand and react to shapes and color pretty fast. Showing them together will make it a deadly combo.