October 21, 2016
Fix It Friday: Ten Alternatives Methods for Presenting Alcohol Consumption in OECD Countries
alcohol consumption
,
arrows
,
bar chart
,
barbell chart
,
chart junk
,
Fix it Friday
,
gantt
,
makeover
,
map
,
OECD
,
Paul Kirby
,
trellis chart
12 comments
If this post turns into a bit of rant, bear with me. Let's start with the Tweet that got me worked up:Interesting @OECD chart on alcohol consumption. By country & trend. E.g Austrians drink twice as much as Italians pic.twitter.com/OOGYJ3BpAq— Paul Kirby (@paul1kirby) October 19, 2016
You might think "It's just a chart Andy, relax!" True. It's a chart. It's not changing the world or anything. There are several things that have me a bit upset:
- Paul Kirby calls the chart "interesting" and maybe the CONTENT is interesting, but the chart is terrible.
- He says "Austrians drink twice as much as Italians", a fact that is simply not true. They drink 61% more than Italians. You can't just spout facts like that.
- Paul is visiting professor at the London School of Economics. I can only assume that his students follow him on Twitter. When he tweets things like this, his student will assume that this is how charts should be made, which only proliferates the number of poor charts we'll continue to see.
The chart itself has its own set of problems:
- It's too dark overall. The dark red bars and dark bottles are hard to see against the blue background.
- The flags are unnecessary. What value do they add?
- The bottles are cute, but unnecessary decoration.
- The legend is in reverse order.
- Do the bottle extend beyond the bars or do they start from the same baseline?
- It has a weak title. What's the story?
This is chart junk at its best. Don't create charts like this. I went to the OECD website and downloaded the data. Below I present ten alternative charts that all work better than the original. You can download the Tableau workbook with all of these charts here.
Subscribe to:
Post Comments
(
Atom
)
Great post, Andy! My vote is for chart #3. (what do you call that viz style?) Challenge: Can you move the country labels closer bars and position them so that the labels appear immediately to the left of the red bars and to the right of the blue bars?
ReplyDeleteI like chart #3 the best. It's just a bar chart that shows the difference, so I don't think it has any special name. And nice challenge! Here you go - https://goo.gl/photos/onSLrv96wE6qjMJU9
DeleteI think I like this newest version with you recommendations even better. Thanks for the suggestion!
DeleteNice! how did you do the label positioning and color (which is a nice touch, btw)?
DeleteYou should be able to download the workbook. I labeled them with a dual axis gantt chart fixed at 0. I then had to manually move half of them. Took about 5 min.
DeleteLesson learned: before playing 30 min with the workbook and try to reverse engineering the chart, read all the comments. "I then had to manually move half of them." Ha!
DeleteThis is really great - nice to see the different approaches applied to the same data-set! Downloading the workbook doesn't seem to be an option anymore for some reason - unless there is an issue my end...
ReplyDeleteStrange! That must have happened when I uploaded it again. I've fixed it. You can download it now.
DeleteGreat stuff, thanks for that! Was trying to re-create but got stuck on some of them :)
ReplyDeleteNo problem Lou! Thanks for letting me know. Glad to see you're using this for practice too. It's fun to create lots of charts and explore the possibilities.
DeleteAndy,
ReplyDeleteA great post with some terrific alternatives (and the red and green you use in the fourth chart are color vision deficiency-friendly!) Do note that I believe Kirby's assertion that Austrians drink twice as much as Italians is in fact correct -- at least it is in 2014 in *his* chart as it looks like a little more than 12 for Austria and a little more than 6 for Italy. Your numbers appear to be a bit different (A little more than 7 for Italy in 2014).
Steve
Thanks Steve! Indeed his chart does look like Austria is 2x Italy, but the data is certainly not what OECD provides. Thanks for the comments!
Delete