Table of content

Bar Chart in Tableau

Bar charts are one of the most common data visualizations across all BI(Business Intelligence) platforms. You can quickly highlight differences between categories, show trends and outliers, and reveal historical highs and lows at a glance.

Bar charts are simple, yet, effective, especially when you have data that can be split into many categories.

  • Open Tableau and click on Connect to Data.
  • Then the Connect page will open, click on Microsoft Excel.
  • Navigate to the downloaded files, select Sample Superstore.xls excel file, which is a saved excel file, and click on Open.
  • You can download a Sample Superstore.xls excel file from the link:
  • Once the data source has been connected, open a new worksheet by clicking on sheet1.
  • Sample Superstore.xls excel file contains the below details.

In Tableau, take profit to the columns shelf and Sub-Category to the Rows shelf. It automatically produces a horizontal bar chart as shown in the following screenshot.

In case, If Tableau does not show the default chart type, you can choose the chart type from the Show Me tool to get the following result.

You can also apply colors to the bars based on their ranges. The longer bars get darker shades and the smaller bars get the lighter shades. To do this, drag the profit field to the color palette under the Marks Pane. And Tableau provides a feature that it will produce a different color for negative bars.

You can add another dimension to the above bar chart to produce a stacked bar chart, which shows different colors in each bar.

Drag the dimension field named segment to the Marks pane and drop it in colors. The following chart appears which shows the distribution of each segment in each bar.

0 results
Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions