Create Barbell Chart in Tableau
Summary
A barbell chart in Tableau efficiently compares two related data points, such as sales from consecutive years, by visualizing values as connected dots with a line to highlight differences. This approach offers a cleaner, more insightful way than traditional bar charts to see gaps between metrics. It’s particularly useful for Salesforce professionals analyzing performance changes across products, regions, or segments. By using calculated fields and dual axes, you can build this chart to display both values and their differences distinctly for clearer data-driven decisions.
Takeaways
- Create calculated fields for comparing sales across years in Tableau.
- Use dual axes with circle and line chart types to form barbell charts.
- Connect dots with lines by setting Measure Names to Path for visual difference.
- Add a calculated field to display the difference as a label on the chart.
- Barbell charts offer clearer insights than stacked or grouped bar charts.
If you’ve ever wanted a clean way to compare two values side by side (like 2023 vs 2024 sales by product), a barbell chart in Tableau is one of the nicest options. As a data analyst, I used Tableau to compare sales performance across product subcategories between the current and previous years. I wanted to display the current and previous year’s sales on the same data points for easy comparison. In this, I also want to show the difference between the sales of the two years to identify the growth or decline in sales between them. For this data comparison in Tableau, I created a Barbell chart to display sales by product subcategory and the difference between them. In this Tableau tutorial, I will explain the Barbell chart in Tableau and how to create one to visualize a data comparison. What is a Barbell Chart in Tableau? A barbell chart (also called a dumbbell chart or connected dot plot) shows two (or more) values for each category as dots, with a line connecting them.