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.
Load the following data into Tableau Desktop / Public.
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
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.