BI & Analytics
Blog
Tableau
7
min read

Bar Charts: The Good, the Bad, and the Ugly

Why can bar charts be effective and how to use them to get answers easier, and faster!
Author
Matthias Fröhlich
Matthias Fröhlich
Analytics Engineer
Bar Charts: The Good, the Bad, and the Ugly
Share article

How to use bar charts: The good, the bad and the ugly

One of the important tasks in visual analytics is to address the question of how to visualize information in order to drive better decision making.

With powerful visual analytics tools at the ready, we’re capable of building dashboards at high speed and with great diversity in terms of chart types.

But despite our growing visual vocabulary, there appears to be one chart that rules them all: the bar chart. Bar charts are found everywhere, from typical business dashboards to scientific data presentations (more on that later) and became seemingly a standard solution for effective data visualizations.

In this blog post, we are going to look into the question why bar charts can be very effective and how to use them. But we will also address potential caveats, and how we can discover the unexpected by going beyond the bar chart.

How to use bar charts: the Good

Next to line charts, the bar chart is considered the main building block from which more advanced chart types are built (e.g., grouped bar chart, stacked bar chart, diverging bar chart, bullet graph, waterfall chart, ... ). There are several reasons why that’s the case.


Bar Chart GIF

When we display our data, we think about how we are going to encode the data. By using color, shape, size and other features, we can format our visualizations, provide visual cues for the viewer, and guide the attention. This visual encoding makes smart use of our innate ability to process visual information very efficiently due to preattentive attributes.

The bar chart makes very effective use of this, by encoding quantitative values as length (or height) from a common baseline. Additionally, changing the position of the bars by sorting them from left to right or from top to bottom, caters to the way most people read a chart.

The general appearance of a bar chart further adds to the understanding of the data we’re looking at. By using whitespace between the columns, the bar chart emphasizes we’re dealing with discrete categories, and each bar is of equal width because only frequency is at stake.

Both features are in contrast with a histogram, where the absence of whitespace highlights the continuity of the data, and the width of the bars may vary to tell us something about the frequency density. The common baseline starting at zero stresses the congruency between the length of the bar and a discrete quantity (i.e., a finite set), and avoids skewing the relative difference between categories.

It’s clear that the famous bar chart is highly effective for comparison and ranking, discerning patterns between categorical and ordinal data. Combining only two basic features, length and position, it beats everything by simplicity. But its omnipresence suggests that the bar chart is frequently used in an improper way, exceeding its purpose.

Using bar charts: the Bad

In many cases, bar charts are used to tell us something about general features of the data, while they show us very little about how the data itself looks like. In fact, they leave a lot to the imagination of the viewer.

A scientific paper discussing the use of bar charts in scientific literature gained wide support in the academic world, prompting many journals to adopt new visualization policies. The message was unambiguous: bar charts muddle accurate interpretation of the underlying data, especially when representing summary statistics of continuous data.

When we start comparing summary statistics of continuous data (e.g., mean, median, standard deviation, mode, …), things get more complicated than with nominal or ordinal data. Summarizing data using measures of central tendency, causes several issues.

First, different distributions of data may cause the exact same bar graph. Second, by using measures of central tendency per se, we cause the viewer to wrongly assume that the data is normally distributed without any outliers.

And third, when we deal with time series or paired data, we erroneously suggest that the different groups or time bins are independent from each other.

Data vs Stats
Same stats. Same bar charts. Completely different data. The “Datasaurus Dozen” dataset (inspired by Alberto Cairo’s Datasaurus) retrieved from here.

One could argue that, when dealing with real business cases, most of these concerns do not apply. For example, we don’t deal with small sample sizes that may cause distortion of the real internal structure of the data. One could even argue that, since we’re dealing with large amounts of data, we don’t need to care about the underlying structure in any way. Both arguments are valid… sometimes.

The third issue, however, is less influenced by the nature of the data we deal with. Time can be treated as ordinal and discrete; think about the days of the week, which we can further group into weekdays and weekends.

But in most situations, time is continuous and independence between different time points is not met. Besides, are your workweek and weekend really independent from each other?

Using bar charts: the Ugly

Whether you find a bar chart ugly or not, is completely up to you. Nevertheless, we can hardly call it original or creative considering its omnipresence in dataviz.

Most people tend to go for the comfortable and the familiar, here coined as the inertia of common practice. When William Playfair invented the bar chart, somewhere in the 1870ies, the only prerequisites for a successful bar chart were paper, a straightedge, and a pencil.

And until now, we barely deviated from the graphical language and techniques the great John Tukey proposed in his groundbreaking work on ‘exploratory data analysis’ to tackle the challenges that come along with it.

It is interesting on its own that we render data at unprecedented speed and accuracy by using very powerful visual analytics tools, but still use very basic graphical ways to visualize it. With the risk of downplaying our favorite workhorse, I invite you to go beyond the bar chart and try to look beneath the surface.

Visualizing summaries of data can be a different thing than visualizing data. Be mindful of the effectiveness and simplicity of the bar chart, but also be aware of how deceiving its simplicity can be.

Facts & figures

About client

Testimonial

Blogs you might also like

5 Ways to Level Up Your Bar Chart Using Tableau Parameter Actions

5 Ways to Level Up Your Bar Chart Using Tableau Parameter Actions

Tableau Parameter Actions are a great feature in Tableau. Read all about it in our latest blog.

BI & Analytics
Blog
Tableau
Everything you need to know about Tableau Certifications

Everything you need to know about Tableau Certifications

Thinking of taking one of the Tableau Certifications? We explore how to get ready in our latest blog. Read all about it here.

BI & Analytics
Blog
Tableau
Personalise your Tableau Dashboard with Custom Titles

Personalise your Tableau Dashboard with Custom Titles

Learn about how to add the personal touch to your Tableau Dashboard with custom titles.

BI & Analytics
Blog
Tableau
How to create a waterfall chart in Tableau

How to create a waterfall chart in Tableau

Learn how to create your own waterfall charts in Tableau Desktop by following these steps.

BI & Analytics
Blog
Tableau
The Ultimate Guide to Embedded Analytics

The Ultimate Guide to Embedded Analytics

Discover what embedded analytics is all about and how it can drive additional revenue streams for your business.

BI & Analytics
Blog
ThoughtSpot
How to label pie charts in Tableau

How to label pie charts in Tableau

Learn more on how to label pie charts in Tableau like a pro.

BI & Analytics
Blog
Tableau
How to label bar charts in Tableau

How to label bar charts in Tableau

Learn how to label bar charts in Tableau like a pro and level up your dashboard design. Read the full article here.

BI & Analytics
Blog
Tableau
How to create a donut chart in Tableau

How to create a donut chart in Tableau

Looking to create a donut chart in Tableau? Read our in-depth guide on how to level up your donut charts in Tableau here.

BI & Analytics
Blog
Tableau
How to ace your ThoughtSpot certifications?

How to ace your ThoughtSpot certifications?

Learn more about ThoughtSpot certifications and how to ace your exams.

BI & Analytics
Blog
ThoughtSpot
How to stop marks being highlighted when ‘clicked’ in Tableau

How to stop marks being highlighted when ‘clicked’ in Tableau

Learn how to stop marks from being highlighted when clicked in Tableau.

BI & Analytics
Blog
Tableau
How to Create Multiple Select Parameters in Tableau

How to Create Multiple Select Parameters in Tableau

Learn how to create multiple select parameters in Tableau to add more control and interactivity to your analysis.

BI & Analytics
Blog
Tableau
How to apply conditional formatting to tooltips in Tableau

How to apply conditional formatting to tooltips in Tableau

Learn how to apply conditional formatting to tooltips in Tableau with our step-by-step guide. Improve your data visualization skills today with Biztory.

BI & Analytics
Blog
Tableau
Rediscovering Business Intelligence with Sigma Computing

Rediscovering Business Intelligence with Sigma Computing

Discover how Sigma Computing is reshaping the BI landscape with its user-friendly interface and powerful capabilities.

BI & Analytics
Blog
Sigma
Sigma Computing: Our Favourite Features

Sigma Computing: Our Favourite Features

Discover our favourite features of Sigma for powerful and fun data analysis.

BI & Analytics
Blog
Sigma
Tableau vs. Power BI: Everything to know

Tableau vs. Power BI: Everything to know

Compare Tableau and Power BI to determine the best business intelligence tool for your needs.

BI & Analytics
Blog
Tableau
Tableau Map Layers: Getting Started (1/3)

Tableau Map Layers: Getting Started (1/3)

Learn how to leverage Tableau's Map Layers feature to create complex visualizations.

BI & Analytics
Blog
Tableau
Tableau Map Layers: Pull everything into one view (3/3)

Tableau Map Layers: Pull everything into one view (3/3)

Use Tableau Map Layers to combine multiple visuals in a single worksheet and create custom dashboard views for enhanced data visualization.

BI & Analytics
Blog
Tableau
Tableau Map Layers: Building Different Charts (2/3)

Tableau Map Layers: Building Different Charts (2/3)

Learn how to create Pie, Doughnut, Line, and Area charts using Tableau Map Layers.

BI & Analytics
Blog
Tableau