In Partition Charts in Excel – alternative to pie charts [visualization hack], Chandoo offers a “partition chart” as an alternative to a pie chart. We all know pie charts are bad (don’t we???), so it’s good to look for alternatives. Here is part of Chandoo’s partition chart:
This chart uses conditional formatting to achieve the mottled appearance. It’s almost reminiscent of camouflage, partly because of the mottled colors, and partly because the information is well hidden. The colors cover 22%, 30%, and 48% of the area of the chart. Without looking at the legend of the full partition chart below, can you at a glance match up the colors with their associated proportions? I couldn’t, either.
Here is Chandoo’s complete chart, including the legend:
As I told Chandoo in a comment to his post:
While pie charts are somewhat ineffective at showing relative proportions, this partition chart is completely ineffective. If not for the legend, I would have guessed that the darkest color accounted for the largest, not the smallest, proportion. The pie at least puts all of its bits into one wedge per category, while the partition chart keeps all the bits separate, and they are scattered across the chart. It’s as if you spilled a package of M&Ms on the table and tried to determine the portions of each color.
Since there are only three categories, a pie chart isn’t a terrible choice for this data:
As always, the simplest and clearest way to show this data is in a bar or column chart:
Chandoo spoke of the partition chart as a way to look at geographic variations in data. He mentioned that it might be sales of your products in a number of cities. It makes more sense if you were looking at a map of counties, states, regions, or countries, and you were filling each geographical unit’s shape with the fill color. The user would not be expected to integrate the entire map to get an overall percentage. Instead the user could compare the colors of familiar shaped geographical units and make sense of the data. Wikipedia has some examples of this in Red states and blue states:
In this context, regions of different colors can effectively present information about, in this case, election results in different states. In contrast, the partition graph is a map of nothing.
Jon Peltier says
Jorge – That’s just what it looks like. Funny that I didn’t notice it.
Jorge Camoes says
Jon, the partition chart is not that bad. It just needs to be defragmented… :)
Chandoo says
@Jon … that is why I called it partition chart… :P because the partition is poorly fragmented… A very well critique there btw… :)
Chandoo says
@Jorge Camoes : you asked for it, a de-fragmented partition chart.. find it here : http://chandoo.org/wp/2008/07/10/partition-charts-visualization-fun/
This chart could be a straight forward replacement of pie charts (just 2-3-4 pies, not more) but, it breaks a pattern in that human eye can make out angles with some accuracy, but not blocks… but then this is supposed to be a different way of cutting the pie… so there you go.
derek says
Actual work on this has been done by psychologists and other researchers, most famously by William Cleveland, and also earlier in the 1920s by W. C. Ells, and it turns out that the human eye can not make out angles with some accuracy. Stephen Few summarises the history in this paper (warning: PDF)
People like pies, they like them a lot, but they’re not being as informed and enlightened by them as they think they are. It’s a triumph of prettiness over information.
Chandoo says
@Derek … that is an interesting insight… no wonder Pies have been berated by chart makers all over the world. Even though we may not be able to tell 170 from 230, our eyes are well equipped to tell a 900 from 450 which is pretty much the point of pie charts.
Again thanks for point to the paper :)