Give a chestnut! Tableau Tips (63): Learn to make beautiful and easy-to-use dumbbell diagrams

When we do data analysis, time dimension analysis is essential. We often struggle with how to present multiple dimensions intuitively and easily, without messing up the layout.

Such a dumbbell-shaped chart (we call it a dumbbell chart) is not only beautiful, but also can clearly compare the data changes in different years.

Of course, you can also make it appear upright, which looks more like a DNA chain diagram.

So, how can such charts be implemented in Tableau?

In this issue of "Choose a Chestnut", the Tableau technique that Ada wants to share with you is: Learn to make beautiful and easy-to-use dumbbell pictures.

To facilitate learning, we use the global supermarket data that comes with Tableau.

Specific steps are as follows:

Step 1：Make a circle chart

Drag the product subcategory to the row and the total (sales) to the column. Mark the card into a shape to complete a circle diagram.

Step 2：Copy circle chart

Double-click "Sales" to copy a circular chart.

Step 3：Change the second circular graph to a line graph

Change the second "Sales" on the tag card to a "Line" graph.

Step 4：Drag the dimension "Order Date" into the "Path" tag card

Next, drag the dimension "Order Date" into the "Path" tag card. Note that this step is very important!

Tips: When the "order date" is dragged into the "path" card, because there is already an "order date" in the "color" card, the subsequent "order date" is automatically adjusted to "season", you need to manually change to "season" year".

Step 5：Use dual axis

Change the second "sales" to "dual axis".

Tips: After setting "dual axis", in order to avoid misalignment of points and lines, remember to select "synchronous axis". For a beautiful layout, you can cancel the "display title" on the top horizontal axis.

Step 6：Adjust the "size" of the marker

Finally, adjust the "size" of the mark, and the beautiful and easy-to-use dumbbell diagram is complete. Think about it, where else can you use the "path" tag in daily use? Welcome to leave a message~

Hurry up and open your Tableau, give it a try!