In data analysis, comparing values across different categories is very important. When working with tools like Tableau, simple tables are not enough to clearly understand patterns and trends. That is where visualizations become useful.
One of the most effective charts for comparison is the Side-by-Side Bar Chart, also known as a grouped bar chart. This chart helps you compare multiple categories simultaneously in a clear, easy way.
For example, if you want to compare sales of different product categories across regions, this chart gives you a quick visual answer instead of reading numbers from a table.
In this article, you will learn everything about side-by-side bar charts in Tableau, including definition, steps, examples, comparison with other charts, and best practices.
What is a Side-by-Side Bar Chart in Tableau?
A Side-by-Side Bar Chart is a type of bar chart where multiple bars are placed next to each other for comparison within the same category.
It is also called a Grouped Bar Chart because it groups related data together.
Key Points:
- Each group represents a main category (like Region)
- Each bar represents sub-category values (like Product Category)
- Bars are placed next to each other for easy comparison
Example: If you have –
- Regions: East, West, Central
- Categories: Furniture, Office Supplies
You will see two bars (Furniture & Office Supplies) side by side for each region.
Check out: Create a Map Chart in Tableau
Why Use a Side-by-Side Bar Chart?
Side-by-side bar charts are mainly used for comparison.
Benefits:
- Easy to compare multiple categories
- Clear visual difference between values
- Helps identify trends quickly
- Better than tables for analysis
Bar charts in general are designed to compare categorical data using bar lengths, making them very easy to understand.
Create a Side-by-Side Bar Chart in Tableau
In this example, we will create a side-by-side bar chart to compare sales of the Office Supplies and Furniture categories across different regions.
- First, we will add the dimension Region to Rows and Sales to Columns.
Now, we have sales data for products across all regions.
- To compare sales for the Office Supplies and Furniture categories across all regions, add the category to the Filters section.
In the filters, select the checkboxes for the categories you want to compare, then click OK.
- After applying the filters, press the Ctrl key and drag the Category to the Columns. With this, the bar chart will display the sales of both selected categories side by side for each region.
Check out: Create a Tree Map in Tableau
- For comparison, we can also change the bar colors to differentiate them. For this, add the Category to the Color card in the Marks section.
This will display both bar charts in different colors, like Blue for Furniture and Orange for the office supply category.
- To add a more accurate sales comparison, we can also display sales figures on the bars. For this, add the Sales to the label card.
With this, we can see the sales figures on each bar.
This way, we can create a side-by-side bar chart in Tableau by following the above steps.
Check out: Create a Bar Chart in Tableau
Create a Stacked Side-by-Side Chart in Tableau
In Tableau, we can convert a side-by-side chart into a stacked side-by-side chart.
In this example, we will create a side-by-side bar chart to display the Profit, Sales, and Quantity of sold products across various states in the USA.
In this chart, the measures will be divided by States, and we will then stack the bars by Sub-Category.
- Add the States to the Columns, and to select specific states, click on the States in the Columns and select Edit Filters.
In the filter, select the state you want to include in the bar chart, then click OK.
- To compare the product quantity, profit, and sales across the states, add the Measure Names to Columns.
Click on the Measure Names and select Edit Filters. In the filter, select the values quantity, profit, and sales, then click OK.
- Add the Measure Values to the Rows, and it will retain the filters we applied to the Measure Values, showing values for quantity, sales, and profit.
With this, we will see a side-by-side chart, distributed by state and grouped by quantity, sales, and profit.
Check out: Create a Box and Whisker Plot in Tableau
- To add stacking in this side-by-side bar chart, add the Category or the Sub-Category to the Color card.
Now the bars in the grouped state data will be stacked by category, as shown by different colors.
This way, we can create a stacked side-by-side bar chart in Tableau by following the above steps.
Side-by-Side vs Stacked Bar Chart
| Feature | Side-by-Side Bar Chart | Stacked Bar Chart |
|---|---|---|
| Purpose | Compare categories | Show total + breakdown |
| Bars | Separate | Stacked |
| Clarity | High for comparison | Better for the total |
| Use Case | Category comparison | Part-to-whole analysis |
- Use Side-by-Side for comparison
- Use Stacked for distribution
Frequently Asked Questions
1. What is a side-by-side bar chart?
It is a chart that displays multiple bars side by side to compare values across categories.
2. What is another name for this chart?
It is also called a grouped bar chart.
3. When should I use it?
Use it when you want to compare multiple categories within the same dimension.
4. Can we customize it in Tableau?
Yes, you can add colors, labels, filters, and sorting options.
5. What is the difference between a stacked and a side-by-side chart?
Stacked shows total and parts, while side-by-side shows direct comparison.
Conclusion
I hope you now understand how to create both side-by-side and stacked side-by-side bar charts in Tableau.
These charts are useful for comparing multiple metrics or categories across a standard dimension, such as regions or states.
The side-by-side bar chart in Tableau is one of the most powerful visualization techniques for comparing data across categories. It helps analysts quickly understand patterns and make better decisions.
By following the steps in this guide, you can easily create and customize your own chart. To get better results, always use best practices such as proper color, labeling, and sorting.
You may also like to read:
- Create a Scatterplot in Tableau
- Tableau Bubble Chart
- IF Statement in Tableau
- Concatenate Fields in Tableau
I am Bijay Kumar, the founder of SalesforceFAQs.com. Having over 10 years of experience working in salesforce technologies for clients across the world (Canada, Australia, United States, United Kingdom, New Zealand, etc.). I am a certified salesforce administrator and expert with experience in developing salesforce applications and projects. My goal is to make it easy for people to learn and use salesforce technologies by providing simple and easy-to-understand solutions. Check out the complete profile on About us.
