Select Page

Pretty much everyone knows that bar charts are a great way to visualize your data.

Two reasons why

  • Reason 1: everyone understands them starting in grade school. People know how bar graphs work.
  • Reason 2: everyone can quickly estimate values to spot check the numbers displayed in the bar chart.

You have probably created bar charts on paper or even in Excel.

If you are just getting started with Tableau then creating bar charts is a great way to get familiar with the tool as a beginner.

Here’s the thing…

There are a few types of Tableau bar charts. This guide covers the best ones.

Direct links to everything covered in this guide

(Don’t forget to snag a PDF version of this post to save time in the future)

Featured Download: Download my entire Tableau Bar Chart guide with step-by-step instructions for each of the bar charts listed here as an easy reference for the next time you need to create a bar chart in Tableau ūüôā

click here to download

How to Make a Basic Tableau Bar Chart

There are really just two steps to create a basic Tableau Bar Chart

  1. Drag and drop a measure field from the lower left of the scren to the Rows shelf at the top of the screen
  2. Drag and drop a dimension field from the upper left of the screen to the Columns shelf at the top of the screen

If you’re wondering, measures are just things that can be counted. Dimensions are used to group those things. For example, “Sales” is something that can be counted and “Category” is one way that we can view sales.

Your turn!

Try making a simple bar chart in Tableau

View post on imgur.com

How to Make Clustered Bar Charts in Tableau

If you want to compare sales across multiple dimensions (like sales by customer segment and order year, as you see below) then you definitely want a grouped bar chart.

Tableau Clustered Bar Chart Instructions

  1. First, drag a measure to the Rows shelf
  2. Second, drag any dimension to the Columns shelf
  3. Lastly, drag another dimension to the Columns shelf at the top of the screen

You should know:

Viewing your measure by two dimensions creates the grouping or clustered bar chart view. Pro tip: add your second dimension to the Color section of the marks card so it’s¬†easier to understand the data.

View post on imgur.com

How to Make Stacked Bar Charts in Tableau

Stacked bar charts are the best way to show how the individual pieces contribute to the total.

For example, if you want to show sales data by categories in addition to total sales you can build a stacked bar chart to show all of that in one easy-to-read view.

Tableau Stacked Bar Chart Instructions

  1. Drag and drop any measure to the Rows shelf
  2. Pull a first dimension into the Columns shelf
  3. Finally, drag any dimension to the Color section of the Marks Card

Keep in mind:

You can add multiple dimensions for a stacked bar chart¬†but it’s best to stick with just a few for one visualization to keep it simple.

View post on imgur.com

How to Make Dual Axis Bar Charts in Tableau

Dual axis bar charts (also known as bullet charts) are a great way to compare two different measures with just one dimension.

For example, if you wanted to compare both sales data and profit data against the same time period, you can use a dual axis bar chart to show that.

Tableau Dual Axis Bar Chart Instructions

  1. Take a measure and drop it into the Rows shelf
  2. Drag a first dimension to the Columns shelf
  3. Drag a second measure to the edge of the visualization to drop it on the second axis
  4. Reduce the size of the bar in the front, synchronize the axis, and format as needed

Pro tip:

Dual axis bar charts are a great way to show progress against a goal. Make the first measure the goal and the second measure the actual value and you have a quick gauge to see where you stand against a target.

View post on imgur.com

 

How to Make Stacked Combo Charts in Tableau

Stacked combo charts are a combination of a stacked bar chart and a grouped bar chart (both are covered earlier in this guide).

These can be useful for showing how pieces in one category or group compare against the whole and also against other categories. It’s a good way to show some context without overwhelming the viewer with too much detail.

Tableau Stacked Combo Chart Instructions

  1. Drag and drop any measure to the Rows section
  2. Pull one Dimension to the Columns section
  3. Finally, drag a second Dimension to the Columns section
  4. Create a calculated field that returns the pieces of one category but the total for all other categories.

Use this code as an example

IF [Category] = 'Furniture'
then [Sub-Category]
ELSE [Category]
END

One thing…

Add your calculated field to the Color section on the Marks card to highlight the differences.

View post on imgur.com

How to Make Diverging Bar Charts in Tableau

This bar chart style takes a little more skill to build but it’s a great way to compare the difference of one measure between two dimensions.

For example, you can use a diverging bar chart in Tableau to show the difference in sales from one year to the next.

Tableau Diverging Bar Chart Instructions

  1. Pull one measure to the Columns section
  2. Drag a dimension field into the Rows section
  3. Drag another dimension to the Filter section and select two items to compare
  4. Create two new calculated fields based on the measure from Step 1 above.
    1. The calculated fields are inverse from each other
    2. For example: if you are looking at total sales 2012 vs. total sales 2015, then one of the calculated fields must be a negative value.
  5. Drag both calculated fields to the Columns section and remove the initial measure to clean up

Use this code as an example

IIF(YEAR([Order Date])=2015,[Sales])

Note:

This is a good standalone visualization but not a great choice as part of a larger dashboard since there’s a lot of processing involved for the viewer to compare all of the data points.

View post on imgur.com

Tableau & Google Sheets Checklist

This one-page checklist PDF will help you learn how to upload your data into Google Sheets and build an awesome Tableau dashboard without wasting time.

You have Successfully Subscribed!

4 Things For Every Tableau Dashboard Creator

This free 4-page eBook PDF will walk you through the 4 most important steps for creating a Tableau dashboard

You have Successfully Subscribed!

Massive List of Tableau Tools

Tableau is even more powerful with these 20 tools you might not know about. The 2-page PDF includes a description and helpful links for each tool to get you started.

You have Successfully Subscribed!

Career Boosting Business Analytics Trends

Use this list as a road map to take you from boring data job to the GO-TO PERSON in your company that knows the answers to all the questions.

All set! Check your email :)

Massive List of Free Data Viz Books

Download the FULL listing of 10 free data visualization books covering dozens of topics across 100s of pages. All nice and neatly organized in an awesome Google Sheet for you to print or copy.

All set! Check your email :)

Tableau Dashboards: Beginner’s Guide (Free PDF)

Get the full 2-page PDF with the 5 steps outlined in this guide + 3 bonuses to help you along the way

BONUS #1: 5 Beginner mistakes to avoid

BONUS #2: Video walkthrough

BONUS #3: Links to the the Google Sheet and final Dashboard

All set! Check your email :)

How to Create 6 Different Tableau Bar Charts (Free Guide)

Get the step-by-step guide to create all 6 different types of Tableau Bar Charts (with copy-and-paste calculated fields included) for free.

 

All set! Check your email :)

Massive List of Tableau Web Data Connectors(Free List)

Download the list of 21 different Web Data Connectors for Tableau in this Google Sheet (save a copy for yourself, too!) 

All set! Check your email :)

Slope Graph Examples PDF + Dashboard Walkthrough Video

This 4-page example PDF lists 10 examples of slope graphs curated from around the web with author links for each one. You'll also see the 16-minute walkthrough video where I create an interactive Tableau Dashboard from scratch. 

You have Successfully Subscribed!

Download the Tableau Tutorial PDF Checklist & Workbook

The step-by-step checklist for fixing busted charts with Tableau PLUS the full workbook with all of my formatting and calculations for free.

Tableau Tutorial Chart Redesign

You have Successfully Subscribed!

Download the TableauHighlight Tables PDF Guide

The step-by-step guide for creating Tableau highlight tables
(plus direct links to the YouTube video walkthrough and link to final Tableau workbook)

You have Successfully Subscribed!

How to Create 6 Different Tableau Bar Charts (Free Guide)

Get the step-by-step guide to create all 6 different types of Tableau Bar Charts (with copy-and-paste calculated fields included) for free.

 

All set! Check your email :)

Tableau Scatter Plots: The Complete Guide

Get the step-by-step checklist guide to create scatter plots with Tableau

 

All set! Check your email :)