top of page

Tableau charts: Dual axis chart

Updated: Nov 8, 2022


dual axis chart in Tableau

Definition

Dual axis chart also known as combo chart is a combination of two or more charts into one chart.

e.g., combination of a bar and line chart.

Typically used to illustrate two or more measure fields e.g., profit and sales.

Example of a dual axis chart

example of a dual axis chart

Best practices for creating a dual axis chart.

  • Always show the axis clearly.

  • Use color, gridlines, and borders conservatively.

  • Avoid labelling the actual metrics as can lead to clutter.

  • Provide additional details on the tooltip.

Step by step guide on how to create a dual axis chart.

In this class, using data on Main type of roofing in Kenya, we will create a dual axis chart to compare use of ‘Asbestos sheets’ and ‘Corrugated iron sheets’ for different County’s. We will be creating a dual axis chart using a line chart and a bar chart.

Connect data on main type of roofing to Tableau app and follow the guideline below.

Step 1: Build a simple bar chart using measure field ‘Asbestos sheets’

  • Drag dimension ‘County' to the columns shelf.

  • Drag measure field ‘Asbestos sheets' to the rows shelf.

Resulting,

tableau column chart

Step 2: Build a second bar chart using measure field ‘Corrugated iron sheets’

  • Drag measure field ‘Corrugated iron sheets’ to the rows shelf next to the field ‘Asbestos sheets’.

See resulting chart.

dual charts

Step 3: Make the charts dual

There are two ways to achieve this;

  • Select the drop arrow of the field SUM(Corrugated iron sheets) in the rows shelf and choose ‘Dual Axis’.

tableau dual axis chart
  • or right click on the axis of the second chart ‘Corrugated iron sheets’ for this case, and select ‘Dual Axis’.

tableau dual axis

Note; Executing this step may change your chart from a bar to a circle, like in my case.

Step 4: Lets synchronize the axis

Right click on any of the two axes and select ‘Synchronize Axis’.

Note; Synchronizing your axis ensures the two charts use the same scale (hence this should be optional depending on how you would like to represent your data).

synchronizing axis in tableau

Executing we’ve;

Step 5: Change the charts to line and bar chart respectively

Under marks card, make the First chart a bar chart and the second chart a Line chart.

combo chart tableau

Executing above and removing one of the axis we’ve;

combo chart in tableau

From this chart, we can easily compare use of ‘Corrugated iron sheets’ and that of ‘Asbestos sheets’ across all the counties. According to this data, ‘Corrugated iron sheets’ is used more than ‘Asbestos sheets’ across all the Counties.

Based on this data, dual axis chart is not the best chart to visualize this data since the variation between the two variables is huge. However, the data served its purpose - which is helping you learn how to create a dual axis chart in Tableau.

I hope this article was helpful to you. To receive more of the Tableau tips and tricks, kindly join our mailing list by subscribing below.

If you like the work we do and would like to work with us, drop us an email on our Contacts page and we’ll reach out!

Thank you for reading!


Blog.png
Black & white.jpg

About Me

More About the Author

Bernard K

Analytics Consultant | 3X Tableau Certified

Bernard is a data analytics consultant helping businesses reveal the true power of their data and bring clarity to their reporting dashboards. He loves building things and sharing knowledge on how to build dashboards that drive better outcomes.

Let’s discuss your data challenges! Let’s work together!

bottom of page