Note: If you are more interested in learning concepts in an audiovisual format, we have this full article explained in the video below:
- Tableau is the gold standard for business analytics and data visualization tools in the industry
- Learn how to create a double axis chart in Tableau
Data visualization is a key aspect of any analytics profession. Communicate a data story in a simplistic way, but aesthetically pleasing and impressive. According to Vitaly Friedman, the “main objective of data visualization is to communicate information clearly and effectively through graphic means”.
And there is no better tool than Tableau to do it!! Tableau is one of the most trusted tools in the community. It has been recognized as a Leader in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms for 8 years in a row. That is incredible!
In this article, we will see how to create the most desirable and useful dual axis charts.
For article and homework, make sure you have Tableau installed on your system. I'm using Public Table, that you can download for free. The data we will use is the EE sample superstore dataset.. UU. That is widely used in the Tableau community. Here is the link to descargar the Superstore dataset (but the dataset will be available within Tableau).
New to Tableau? We have the perfect free course to get you started:
Let's get into it!
Create dual axis charts
A double axis graph is used to present the relationship between two variables. More specifically, These graphs are useful to demonstrate the relationship between two or more measurements with different amplitude and scale.. Dual axis charts help to present a lot of information in the limited space present on your dashboard and also allow you to understand the trends that, on the contrary, could have lost.
For instance, in our EE Super Store dataset. UU., We have the profit and sales measures. These two measurements have different magnitude and scale. Let's dive right into the implementation in a staggered fashion.
Here, for our viewing, We will use three Subcategory attributes of the dimensions and two measures, namely, Profit and Sales.
Open a new worksheet and add the dimension panel subcategory to the Columns shelf.
Now select Sales in the Measures panel and place them on the Row shelf under Subcategory. In the same way, select the Profit measure and place it next to the Row Sales shelf. After this step, Your display will look like the picture below.
Here we have two graphs present on multiple axes. The next step is to convert these two different charts to a dual axis chart. For this, click on the triangle present in the profit pill on the row shelf.
Henceforth, will have a drop down menu, just select Dual Axis option from there.
Once you select the dual axis arm! your display changes completely. Like this
Although it has a dual axis display, are on different scales. Now it is necessary to bring both measurements to the same scale using synchronize axis. For it, right-click on any Profit or Sales axis and select Synchronize Axis from the menu. As shown in the following picture.
Here is the result of your dual axis graph with synchronized axes.
To make it more interesting, you can keep playing with him. How to change the form of Sales from Automatic to bar on the markets card or change the respective colors, adding borders.
In the same way, you can go to Profit and change its shape to a line. Your final visualization will look like this. Interesting right?
To sum up, in this article we learn how to create a dual axis chart, put together multiple measures and visualize hidden insights deeper in the data. A Tableau is an interesting tool that allows users to apply their creativity and play with great visualizations.
In case you're interested in learning more about visualization and Tableau, I will recommend you to follow our course. Tableau for beginners.
Feel free to comment below in case you have any complaints.