coaching newsletter contact

Bad Bar Charts

In previous roles I worked on data analysis and visualization. When you boil it down, that just means I was well versed in Excel and building charts.

I love the challenge of working on a chart until it displays the data honestly. That also means I notice bad designs in charts. There are many ways to skew results with chart design and they all make me see red. If you see a chart with one of these aspects, either ignore it or rebuild it.

Non-Zero Based Scale

This is one of the biggest culprits in bad charts. It's easy to change the baseline of a chart and make it look like there's a big difference between two segments. In the chart above, it looks like "Unsure" is drastically overpowering the "Unlikely" category. But if we change the chart to a zero-based axis, we can see that the difference is fairly small.

Now it's a lot harder to see the difference between the categories, but it provides a more accurate picture of what's going on because the visual matches the real data.

Varying Width Bars

This is more subtle but it can make a big impact on how the outcome is perceived. If you make the already taller bars wider than the others, you increase the visual effect on the viewer and leave them with an exaggerated perception of the data.

Unnecessary Lines

In the same way that a non-zero based scale alters the view of the data, a scale that goes too high can also mislead you to thinking there is no difference between two data points. You want the scale to go from zero to the lowest possible number while still allowing room for the entirety of the bars.

We can now see that Minnesota has a decent lead on the others. But we couldn't draw that conclusion until the scale was set appropriately.

Inconsistent scale

If you don't have all the data points (or don't like them), you either need to forego the chart entirely or be honest. I have seen a similar chart used to show exponential growth of membership when in reality the membership growth rate was fairly consistent. Don't lie with the data.

When you include all of the data points, you can see a big difference. Your perception of the first is that the pace is picking up fast. The second chart shows that the rate of increase is normalized.

3D

This is just bad design. It's hard to get a feel for the difference in the bars because our eyes are trying to follow the perceived lines on the chart. And it looks bad. Don't do it.

Overall, these are really simple fixes. But they can have a major impact on the viewer and how they perceive the data. Don't lie with a visual. If the data doesn't show what you want, then you have bigger decisions to make. Get to work and change your methods to get to your desired outcome. Don't fabricate positive results.

Sun, Dec 20, 2015 06:00pm CST https://bhlg.us/4ep6
#charts #data

Want to see my August 2020 Bullet Journal setup?

Join 1,514 subscribers!

I'll send you the link to a six-minute overview video of my August 2020 spreads when you sign up for my newsletter, The Weekly Impulse.

Site Analytics

I use Fathom Analytics on this site because I care about your privacy. And if you ever want to see the stats collected and the data I see, check out the live analytics here.

Amazon Affiliate

joebuhlig.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means to earn fees when linking to Amazon.com and affiliated sites.

Disclaimer

Disclosure of Material Connection: Some of the links in the post above might be “affiliate links.” This means if you click on the link and purchase the item, I will receive an affiliate commission. Regardless, I only recommend products or services I use personally and believe will add value to my readers. I am disclosing this in accordance with the Federal Trade Commission’s 16 CFR, Part 255: “Guides Concerning the Use of Endorsements and Testimonials in Advertising.”

an analog mind in a digital world

👋 I'm Joe Buhlig. I strive to build productivity systems that stand the test of time and help me do more than check boxes. I'm here to help you do the same.

🎙 I read a lot of books and talk about it.

🐿 I can't focus on one thing for long, so I write a lot of code for an eclectic grouping of projects.

📓 And I'm a bit obsessed with finding non-proprietary solutions to digital problems. Thus, text files for the win! 🎉

MN U.S.A 1986-09-30
  • all
  • articles
  • code
  • likes
  • notes
  • photos
  • replies
  • reposts
  • steps
  • videos
coaching newsletter contact
© 2014-2025 by Joe Buhlig