Skip to content

How to Create 6 Different Tableau Bar Charts

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

Two reasons why

  • Reason 1: People know how bar charts work.
  • Reason 2: Bar charts make it easy to understand data

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.

There are a few types of Tableau bar charts. This guide covers the best ones.Direct links to everything covered in this guide

  1. Basic bar chart
  2. Clustered bar chart
  3. Stacked bar chart
  4. Dual axis bar chart
  5. Combo bar chart
  6. Diverging bar chart

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 screen 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

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

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
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

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.

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

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])
View post on imgur.com

4 thoughts on “How to Create 6 Different Tableau Bar Charts”

  1. Pingback: Tableau Dashboards: The Step-by-Step Guide - New Prediction

  2. Pingback: Tableau Line Charts: The Ultimate Guide - New Prediction

  3. Pingback: 5 Easy Steps to Rebuild a Confusing Chart from Scratch Using Tableau - New Prediction

Leave a Reply

Your email address will not be published. Required fields are marked *

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

List of 10 Awesome Data Visualization Books

All set! Check your email to download.

Tableau Dashboards
Beginner’s Guide

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

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

4-page PDF showing 10 slope graph examples + a video walkthrough

All set! Check your email to download the bonus materials.

Tableau Tutorial Chart Redesign

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.

All set! Check your email to download.

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!

Tableau Scatter Plots: The Complete Guide

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

 

All set! Check your email :)

Rebuild a Busted Chart with Tableau

Enter your best email to get the PDF version of this tutorial + the companion Tableau workbook for free

All set! Check your email to download.

Download the Bonus Materials

Enter your best email to get the PDF checklist version of this guide and the companion Tableau workbook for free.

All set! Check your email :)