This is a Quick Tip on how to build a Dual Line Chart in Tableau, so less reading and more jumping in. We are going to spend 5 minutes or less building our Dual Line Chart in Tableau.

Note: As always never choose a data visualisation type and try to fit your data into it, instead, understand your data and choose the best visualization for your data consumers.

Data

Load the following data into Tableau Desktop / Public.

CountryDateSales
United Kingdom1-Jan-201990
United Kingdom1-Feb-2019110
United Kingdom1-Mar-2019100
United Kingdom1-Apr-2019130
United Kingdom1-May-2019130
United Kingdom1-Jun-2019150
Germany1-Jan-201980
Germany1-Feb-201970
Germany1-Mar-2019110
Germany1-Apr-2019140
Germany1-May-2019120
Germany1-Jun-2019110

Worksheet

To start building our dashboard:

  • Change the Mark Type to Line.
  • Drag Country onto Color.
  • Drag Date onto Columns.
    • Right-click on the object and select Exact Date.
  • Drag Sales onto Rows Twice.

You should now see the following:

Now we will update our visualisation:

  • Right-click on the second SUM(Sales) pill in Rows and select Dual-Axis.
  • Right-click on the axis header and choose Synchronize Axis.
  • Double click on the Axis header to open Edit Axis and untick Include zero.
  • Click on the second SUM(Sales) and change the Mark Type to Circle.

Now we can add some formatting and end up with something like the following:

and boom, you are done. You can also choose to use the Shape Mark type for fun. However, we are done and you can find my Dual Line Chart Dashboard on Tableau Public at https://public.tableau.com/profile/toan.hoang#!/vizhome/DualLineChartsinTableau/DualLineCharts

Summary

I hope you all enjoyed this article as much as I enjoyed writing it. Do let me know if you experienced any issues recreating this Visualisation, and as always, please leave a comment below or reach out to me on Twitter @Tableau_Magic.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.