Skip to content

5 Easy Steps to Rebuild a Confusing Chart from Scratch Using Tableau

Nested bubble charts are a bad way to compare data. In this guide, I show how simple bar charts are a better option and rebuild a less than stellar data viz along the way. 

The fine folks at Statista put together a data visualization to show how spending compares between major holidays in China and in the US.

However:

There were a few issues with the original chart.

This data visualization is busted. 

  1. China and United States have very different populations. You can’t really compare facts about these countries without considering that
  2. The nested bubble charts make it really hard to compare data points between the two countries.
  3. The labels are kinda far away from the charts themselves. So, readers have to look at the chart, then at the label, and then back to the chart. Too much thinking!

Here’s how to fix it.

  1. Include population data for each country in the visualization.
  2. Ditch the nested bubble charts in favor of simple bar charts.
  3. Put the labels as close as possible to the chart.

In this guide, I’ll take you through the entire process to fix this bar chart using the data provided by the MakeoverMonday team, Andy and Eva.

Quick links to each step in this guide

  1. Connect to the data
  2. Create a few calculated fields
  3. Build the bar charts
  4. Formatting and clean up
  5. Build the dashboard 

Step 1: Connect to the data

# back to top

https://imgur.com/4ow2jhc

The first thing you need to do is grab the data for this tutorial.

It’s hosted over on data.world and you can connect using the builtin web data connector.

https://tableau.data.world/?dataset_name=makeovermonday%2F2019w6

Just paste that URL into the Web Data Connector screen and you’re ready to create some calculated fields to fix the original chart.

Step 2: Create the calculated fields

# back to top

https://imgur.com/YCUfdsq

Next, we’re going to create 6 calculated fields to fix this chart:

Below are each of the calculated fields and the code you need for each one.

1) 2015 Population

case [Country]
when "USA" then 321000000
when "China" then 1371000000
end

2) N Amt

//Amounts normalized by the population of each country
[Amount]/[2015 Population]

3) N Amt Formatted

//normalized amounts with formatting for each data type
case [Unit]
when 'people' then ROUND([N Amt],1)
when 'Trips' then ROUND([N Amt],2)
when 'US$' then ROUND([N Amt])
when 'viewers' then ROUND([N Amt],1)*100
END

4) Label with Amts and Units

//label formatting
Case [Unit]
when 'Trips' then LEFT(STR([N Amt Formatted]),4)+" "+'trips per person'
when 'people' then STR([N Amt Formatted])+" "+'people'
when 'viewers' then STR([N Amt Formatted])+"% "+'watched a major TV event'
when 'US$' then '$'+STR([N Amt Formatted])+" spent per person"
else [Unit]
END

5) Label with Amts Only

//label formatting
Case [Unit]
when 'Trips' then LEFT(STR([N Amt Formatted]),4)
when 'people' then STR([N Amt Formatted])
when 'viewers' then STR([N Amt Formatted])+"%"
when 'US$' then '$'+STR([N Amt Formatted])
else [Unit]
END

6) Label with Units Only

//label formatting
Case [Unit]
when 'Trips' then 'trips per person'
when 'people' then 'people'
when 'viewers' then 'watched a major TV event'
when 'US$' then 'spent per person'
else [Unit]
END

Step 3: Build the bar charts

# back to top 

https://imgur.com/EGPOmpf

Once that is finished…

Simply drag each of the fields below to build the bar charts.

  1. Drag [Category] to the columns shelf
  2. Drag [Country] to the rows shelf
  3. Drag [N Amt] to the columns shelf
  4. Adjust the colors and sizing as needed

Step 4: Format your visualization

# back to top 

https://imgur.com/exKpXS5

The next step is to adjust the way your visualization looks.

Here’s the thing

This part can take quite a while depending on how much effort you want to put in.

For me, I think it’s important. So I spend more time on this then others might.

You do you. 🙂

Here’s the steps I took to format my bar charts

  1. Relabeled each of the categories and countries to be more reader friendly
  2. Adjusted the colors to match the original visualization, with some slight tweaks to improve readability
  3. Made the bar charts wider to give more room for the labels
  4. Adjusted the axis to be independent and then hidden
  5. Increased the font sizes
  6. Added relevant labels with formatting and alignment settings
  7. Removed extra grid lines and axis markers that I found distracting

Step 5: Build the dashboard

# back to top

https://imgur.com/NnU56Dn

Okay, the last step is to build the actual dashboard.

REMINDER:

Tableau makes this super easy if you know what you’re doing 🙂

  1. Create a new dashboard sheet in the workbook
  2. Drag your bar charts worksheet onto the dashboard canvas
  3. Add a horizontal divider and text box object at the top of that worksheet container
  4. Add your text into the text box as a title and format as needed.
  5. Create a new text box and add a description below the title
  6. Format the dashboard background, legends, and fonts for a clean look
  7. Include any footnotes, disclaimers, or other context at the bottom of your dashboard

# back to top

Conclusion

In this step-by-step Tableau tutorial you learned

  1. Why you shouldn’t use nested bubble charts to compare two data points
  2. What to use instead of nested bubble charts (hint: use bar charts 😜 )
  3. How to rebuild a busted chart in Tableau

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