Here’s a quick quiz for all of you aspiring chart experts:
Question
In the chart below, rank the following in decreasing order of value:
- Red wedge
- Orange wedge
- Pink wedge
- Sum of four smaller wedges
The real answer may surprise you (or maybe not).
. . .
Don’t peek until you’ve ranked the data points!
. . .
No cheating!
. . .
Answer
Whichever way you have ranked the options, if you tried to eyeball their sizes, you were wrong. Maybe the slight 3D tilt was enough to distort the truth.
Here is the answer key.
It looked to my bleary eye like the sum of the small slices was largest, followed by the orange slice close behind, then the red, and finally the pink. Or maybe the orange is slightly larger than the sum of the four small ones. Either way is wrong. Here are the actual values, in order:
- 301 – Red wedge
- 284 – Orange wedge
- 276 – Sum of four smaller wedges
- 229 – Pink wedge
Interactivity
Another interesting “feature” of this display is its interactivity. When you mouse over a pie segment, it moves away from the other pieces, a leader line is drawn from the pie slice to its legend entry, and a box pops up with some information about the data point.
It’s pretty awkward how the rightmost data point has to reach all the way across the other pie slices to connect to its legend key.
Alternative Chart
In the bar chart below, rank the following in decreasing order of value:
- Supermarkets
- Medical Services
- Services
- Sum of four smaller bars
You can display this data more clearly in less space if you use a bar chart. The only difficulty is in judging the relative sizes of the three larger bars and the sum of the four smaller bars, but the numbers are there if you need to do some mental math.
You could make this chart interactive by popping up the same info box as is shown in the pie chart, and it would feel just as cool. If you wanted to, you could even highlighted the targeted bar with a darker shade and make its category label bold.
The colorful interactive pie chart above was provided by Discover Card’s Spend Analyzer Demo.
ikkeman says
in all honesty, if you didn’t show the values ascociated to the bars, I might not have put the sum of the smaller bars in the right place either.
Dan Murray says
Great example. I cringe at the use of pie charts and wonder why so many people think they are useful. In most cases I find that a pie chart with more than three slices does not aid in understanding. Your example clearly demonstrates that with a minimum number of words. Well done.
Jon Peltier says
@ikkeman –
The sum of the four items isn’t really important in general. In the context of the pie it was important to illustrate how poorly this particular pie represented all of the numbers. If the four numbers naturally go together, maybe their bars should be stacked, although that makes comparing the heights of the stacked bars less precise.
DMurphy says
…and trying to make a 100% stacked bar version is just as confusing:
http://www.box.net/shared/vxsvsjbhq1
I’ll sign your petition, Jon, if you want to start banning these as well ;-)
DaleW says
Jon,
Sometimes it seems that Liberals on FOX news get fairer treatment than pie charts on your blog.
Even though you pitted that pretty unlabeled 3-D pie chart against your champion, a functional 2-D labeled pareto-ized bar chart, the rout was not complete:
(1) It was still clear that the pink item was the smallest of the four choices. That question can’t be answered from your bar chart.
(2) For those who have checked out Microsoft’s tutorial on scientific pie charts — not joking — it is possible to recognize that this a slightly offset version of the polar trig pie chart, which the tutorial failed to create with Excel (due to reverse polar logic?). Here, the slices are properly ordered counterclockwise from largest to smaller, per the standard polar chart convention. (Just oddly starting at -30 degrees from the X axis.)
In the interest of fairness, why not do an apples-to-apples comparison and show how an good ordered pie chart in 2D (starting crisply from 0 or 90 degrees) compares? Then I bet viewers would get the ordering right, AND even recognize how the sum of the other slices compares to the big three more easily than with a bar chart.
Jon Peltier says
David –
What you came up with is the horizontal version of this, which is pretty useless:
What I was thinking of in my comment to ikkeman is this, which may or may not help the analysis:
Jon Peltier says
Dale –
There are two conventions for polar coordinates. The mathematical convention starts with zero angle pointing to the right (the Cartesian X axis) and increases in the counterclockwise direction. The everyday convention, embodies in every common analog clock you encounter, starts with zero angle vertically upwards (the Cartesian Y axis) and increases in the clockwise direction. Since pie charts are the graphical opiate of the masses, and since Microsoft is Lord of the Desktop, we’ll use the second convention.
The colors have morphed from the originals, but sure, this one shows the relative angles pretty well. Supermarkets is well over 90°, medical is a little over (I think), the combined last four are perhaps slightly over 90°, and services is well under. The pie beats the regular bar at comparing how the sum of one group of adjacent data points compares to another. If we want to make other comparisons, like medical plus automotive vs. supermarkets plus gasoline, we have to reorder the chart, losing the help that sorting gives.
I think the mixed bar chart in my previous comment beats the pie at comparing the group of four to the ungrouped three.
And keep in mind I only grouped the four because the original chart distorted them. There may be no financial basis for combining them.
Here’s that last pie displayed using Conventional Mathematician’s Polar Coordinates:
Liu 's chart blog says
We all know you dont like pie chart , you use sorted bar chart , but you neednt talk about this again and again:)
Jon Peltier says
Hi Liu –
I know I’ve been on the topic of bad pie charts a lot lately, and I’m worried about saturating my readers. At the same time, lately I’ve become hyper-aware of the problem, and I keep seeing examples to talk about. And people keep sending me other examples: maybe they like to set me off.
I’ll try to write about something interesting next week!
DaleW says
Jon,
I appreciate your follow-up response: a fair and balanced treatment for pie charts.
Yes, your unique bar of bar charts is better than an spatially misleading pie of pie charts, no contest.
If you & Chandoo embrace diversity a bit and even teach your readers how to make better pie charts, that might mean a few less really bad pie charts in the world, and those people who learned to improve their pie charts can mull over your message that bar charts are generally more powerful and accurate than pie charts.
Obviously, your best 2-D bar chart still is better than the best 2-D pie chart for visualizing almost all small differences. Even in your 2-D pie, I admit that I still can’t be certain without reading the numbers (or noticing the polar ordering convention!) which of the two slices was biggest.
Which brings me to my final point this week. Discover Card likely uses 3-D pie charts because the people who glance at a pie chart rather than carefully read their statements really don’t care about 1% or 2% or even 5% differences in their monthly categorical spending: they are satisfied with a quick colorful approximate superficial view of it. Which seems pretty practical to me.
We might save the pies for dessert . . . or we might save the good bar charts for when the details really matter. (And when the details really matter, we both know a dot plot is often *technically* a better choice than a bar chart anyway.)