The Problem with Pie Charts
By Zach Gemignani
December 27, 2006
Find more about:
The popularity of pie charts is a bit of a mystery. The data visualization goals of a pie chart can easily and more effectively be shown with a bar chart or even a simple table. In the worst of cases, a whole pie chart is used to show a single number:

That's an example pulled from Google Analytics by Coda Hale. He's justifiably flabbergasted that "this piechart uses 78,050 pixels to display a single fact–that 9.94% of all visitors had previously visited the site–resulting in a spectacular data-point-to-pixel ratio of 0.0013%."
Pie charts break some of the basic rules of data visualization:
- Readers of pie charts will struggle to judge the relative size of the pie slices. If the goal is to clearly show your results, pie charts can do more harm than good.
- As noted, pie charts aren't particularly efficient in the data-to-ink/pixel ratio. They take a lot of space to present a little information.
- A well-designed pie chart is hard to pull off—colors need to have high contrast, labels need to be carefully placed to not overlap and be readable, too many values quickly result into a visual mess.
- The all too popular 3-D pie chart exacerbates all of the above.
Here's a little more color commentary from Coda and others to elucidate this problem:
In his post about Google Analytics, Coda Hale takes out some aggression on pie charts. A few of my favorite quotes:
Piecharts are defeat in circular form.
Piecharts are for middle management.
Piecharts are the information visualization equivalent of a roofing hammer to the frontal lobe.
[Piecharts] have no place in the world of grownups, and occupy the same semiotic space as short pants, a runny nose, and chocolate smeared on one’s face. They are as professional as a pair of assless chaps. Anyone who suggests their use should be instinctively slapped.
Eric G. Myers's Improving Customer Experience blog provides another take on using pie charts in "Pie Charts Must Die. Mmmmm. Pie."
To my mind, the best use of a pie chart is when you have one value that is overwhelmingly larger than the rest and you don't want the audience to focus on the actual values, but just bamboozle them with the overwhelming size of the leading segment. Of course, this seems to come close to embracing the old adage, "There are lies, damn lies and statistics."
Wikipedia's entry on pie charts even includes a warning against using:
Pie charts are rare in the scientific literature, but are more common in business and economics. One reason for this may be that it is more difficult for comparisons to be made between items in a chart when area is used instead of length. In Stevens' power law, visual area is perceived with a power of 0.7 compared to length that is 1.0. This implies that length would be a better scale to use, since differences would be linearly related. Pie charts should be used only when the sum of all categories is meaningful, for example if they represent proportions.
In research at AT&T Bell Laboratories, it was shown that comparisons using angles was less accurate than comparisons using length. This can be illustrated with the diagram below. Most subjects have difficulty ordering the slices in the pie chart, however when a bar chart was used the comparison is much clearer.
Maybe I'm being too hard on pie charts. Consider, for example, their unique ability to support a joke (via BoingBoing):
Try pulling that off, Bar Chart!
Related links:
Consulting and Rice Krispie Treats
By Zach Gemignani
December 19, 2006
Find more about:

Sometimes consulting is like making Rice Krispy Treats.
The client says they're hungry. The consultant ducks into the kitchen, makes a lot of noise and emerges four hours later, sweat on their brow, covered in flour, with a pan of Rice Krispy Treats in hand.
Sometimes the work is easy and it's hard for the client to know exactly how much effort went into it.
I wish we could say Rice Krispie Treat consulting—trading on your client's ignorance and their hunger—wasn't sustainable. For the record, when dealing with data, many things are easy that used to be hard, and everything is getting easier.
Some things that are easy:
* Cleaning data with well recognized patterns
* Dealing with millions of records (billions can be hard)
* Repeating a process or analysis that has already been defined
* Matching datasets with unique identifiers
If your consultant isn't willing to admit that some portions of the problem are easy, then they are either being disingenuous, aren't using the right tools, or should avoid the kitchen altogether.
5 comments
Chris Meisenzahl said:
Clever post. ;-)
Adam said:
Very true! But the Rice Krispie Treats are very tasty!
Another Gary said:
Wasn't there a TV commercial that used that idea? Also one for flavored coffee/cappuccino - the coffeemaker made milk-steaming noises in the kitchen before bringing out the instant stuff. I think consultants should make funny noises, too.
Mary said:
There is no flour in Rice Krispie treats.
derek said:
Mary, that's part of the metaphor :-) some of the sturm und drang that is thrown around during the project does not in fact play a part in the delivered product.
Add a comment
Squaring the Pie Solutions Screencast
By Chris Gemignani
December 14, 2006
Find more about:
excel
infographics
screencast
squarepie
tools
visualization
1 comment
Brett said:
Is there a reason that the navigation to the next and previous posts etc has not been included on this page. It makes this page a bit of a dead end and having to navigate around it seems a bit clumsy. Really great site guys!!
Add a comment
Solving the Pie
By Chris Gemignani
December 14, 2006
Find more about:
design
excel
infovis
innovation
screencast
Last week I challenged the you to reproduce this alternative to pie charts in Excel. I promised a screencast to show how it's done.

Eighteen people answered the call with nearly three dozen different solutions. Click here to watch the screencast showing how to accomplish the two most popular solutions; filling cells with conditional formatting and pushing the column chart to extremes.
If you want to look at the source,Clint Ivy produced an excellent version of the cell filling approach.
Dermot Balson submitted an terrific version of the column chart approach.
Thank you to everyone who submitted a solution.
14 comments | Show all comments only the last 5 are shown
Robert Kosara said:
Great to see that you picked up the idea, and made this challenge around it! Being able to do more than the old pie and bar charts in Excel makes these techniques accessible to a lot more people, and hopefully shows them how much more can be done with visualization than the simple things Excel offers directly.
I agree with some of the comments in the other posting, there are some issues with perception here. Especially when only showing one number, filling the cells from the bottom (like a bar chart) is probably a better idea. However, when comparing several numbers, having areas as square as possible is preferable (squarified treemaps have shown this quite clearly). But this shows that even for simple graphics like this, there is still quite a bit of work to be done to understand how to use them most effectively.
Anyway, great blog, and you have really active readers/contributors!
Rage on Omnipotent » Blog Archive » Square pies said:
[...] Nice ways of getting square pie charts. We’ll have to start using them. [...]
Rage on Omnipotent » Blog Archive » Square pies said:
[...] Nice ways of getting square pie charts. We’ll have to start using them. [...]
David Boyle said:
Fantastic. And LOVE the video.
The challenge now is for someone to build in the functionality for showing two different ranges in the same chart.
David Boyle said:
I answered my own question and emailed in a solution (building on the previous work) that allows multiple values in the same chart. It is also here: http://beglen.googlepages.com/square_pie_DBB.xls
ross said:
Looks nice, I think this is a terrible chart, for reason as made before, but it does look nice. I could not view the video sadly, in FF or IE :-( - could you put in on youtube?
Henk said:
This excercise flashed my memory back ages ago when someone showed me how to make a squared circle. But that's maths, not Excel.
GrahamC said:
Surely to show 2 values in the same chart you'll have the 1 colour which is the lower number, then the 2nd colour which is the higher number, the 2nd colour only needs to be stacked ontop of the 1st colour to show the comparitive difference?
DBM Forum » Blog Archive » Ban de Pie Chart said:
[...] Toch lijkt deze uitwerking niet echt een goed alternatief: Optisch lijkt de eerste “taart” (of kunnen we deze grafiek beter “cake” noemen?) voor meer dan 56% gevuld. Een andere invulling (bijvoorbeeld hele regels van onderaf naar boven) vangt dit wellicht op. Ook het invullen van meerdere segmenten kan onduidelijk worden. Mocht je toch een vierkante taart willen maken in Excel, op Juice Analytics staan enkele in Excel uitgewerkte voorbeelden. [...]
Googlizing myself | Chris Teplovs said:
[...] In that alert I found a blog post on Data Visualization Gone Wrong, which was fun to read and reminded me of the Coda Hale’s rant against Google Analytics’ pie charts. The Gone Wrong posting led me to juiceanalytics, which is also helpful. [...]
Mozlog.nl marktonderzoek weblog » Blog Archief » Square pie-chart of pie-chart? said:
[...] Als oplossing wordt de square pie-chart gegeven. De blog juiceanalytics heeft hier van een aantal Excel bestanden gepost. [...]
SPSSlog.com » Happy holidays! said:
[...] If you need something to do during your time off, try out the great online graph service Swivel, or try making the coolest SQUARE PIE-CHART graphs with SPSS! Post all your creations in our comments… [...]
Stefan Schwarzer said:
Hi there,
to make things more complicated, I would like that my square actually displays with two different colors (in addition to white or "empty"). Say, I have a value of 62 (which is for example the Percentage of students finishing a course). Then I have another value, say 38 which is the Percentage (out of the total) of students finishing with a specifc grade.
So, my square looks like this (2 for those students finishing and 1 for those with a specific grade):
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 2 2 2 2 2 2 2
0 0 0 2 2 2 2 2 2 1
0 0 2 2 1 1 1 1 1 1
0 0 2 2 1 1 1 1 1 1
0 0 2 2 1 1 1 1 1 1
0 0 2 2 1 1 1 1 1 1
0 0 2 2 1 1 1 1 1 1
0 0 2 2 1 1 1 1 1 1
But how can I visualize it in this way: http://geodata.grid.unep.ch/Picture_2.png ?
Chris Gemignani said:
Stephan, Here's a quick capsule of one way to do what you want.
Create a 10x10 block and number the blocks in the order in which you would like them to be filled. For instance:
1 2 5 . . . . . . .
3 4 6 . . . . . . .
7 8 9 . . . . . . .
. . . . . . . . . .
. . . . . . . . . .
. . . . . . . . . .
. . . . . . . . . .
. . . . . . . . . .
. . . . . . . . . .
. . . . . . . . . .
Then if you want to show blocks for two values (call them A and B), use a two level conditional format to colorize the blocks:
IF blockval <= A: make color red
IF blockval <= A+B: make color orange
Add a comment
What about the (Analysis) Grunts?
By Zach Gemignani
December 12, 2006
Find more about:
analytics
management
Phillip Carter's article in Slate entitled What about the Grunts argues that the findings of the Iraq Study Group are fundamentally flawed because they fail "to study the war at its most critical level—that of the grunts." It is at this level that he believes the war will be won or lost. The Iraq Study Group:
needed instead to talk with soldiers, Marines, intelligence officers, and diplomats who regularly interact with Iraqis and understand the reality of this country that exists outside the blast walls of America's hermetically sealed bases.
The Iraq Study Group, the Pentagon, and the U.S. headquarters in Baghdad have all displayed an almost pathological inability to listen to and learn from their own people. Our enemies suffer from no such bureaucratic encumbrances; they learn, they adapt, and they evolve much faster than we do.
While the gravity of the situation is trivial in comparison, there is a similar debate in the world of analytics. The discussion of how and where analytics should exist in a business results in a similar divide between those that believe the answers can come from the top and those that prefer the insight of the front-lines (and of course the fence-sitters who see the value in both / don't want to mix it up).
Tom Davenport, in particular, seems enamored with the concept of creating a centralized analytics capability to rule them all. He believes that you "competes on analytics" if you "not only employ analytics in almost every function and department but also consider it so strategically important that you manage it at the enterprise level."
Meanwhile, Davenport minion Jim Novo responded to our criticism by stating:
"if a silo wants to keep an analytical “lead” in it’s own little box to do the navel-gazing, silo-focused analysis that impacts it’s own little box, then that’s OK. Just know that this analysis, while meaningful to the little box, cannot be used or trusted anywhere else in the company and so is of very little value in a macro way. But it’s safe; the silo can proceed with the $10 “micro tweaks” and have full accountability while the competition is making macro process changes worth millions using centralized analytics."
Ouch. There is hardly enough room in my little box to both do my navel-gazing and my micro-tweaking.
The alternative school of thought is that the majority of meaningful, actionable analysis takes place (or should take place) on the front-lines of the business. These are the people who understand the nuances of the situation and need to live with the results. Not unlike the grunts in Iraq.
Related links:
- Fernanda Viegas of IBM's Visual Communication Lab is a proponent of "democratizing" visualization. Audio version of her presentation at IDEA Conference.
- Article by Martin Ahrens discussing centralized vs. decentralized analytics and the important role of each.
3 comments
Kevin Hillstrom said:
Great food for thought!
During the past twenty years, I have had the pleasure of working in or leading analytics teams at small, and at very large companies. I have been in roles where the analytics team is de-centralized. I currently lead a large, centralized team.
I can honestly say that there are huge benefits to de-centralization, and I also see the benefits of a centralized team. For a centralized team to work, the vast majority of the employees must implicitly trust the centralized team. The minute the centralized team begins to "take sides", or "promote a particular point of view", trust is broken, and the centralized team struggles to make contributions. The business units that no longer trust the centralized team frequently begin their own analytics function.
De-centralization has many benefits, including diversity of analytical methodologies and metrics. Diversity is more likely to flourish in a de-centralized environment.
De-centralization has drawbacks, too. Errors are more likely to occur. Methods that are not appropriate for various business problems are more likely to occur. De-centralization can be problematic when each unit uses a different data mart, with different data.
At the end of the day, either approach can work. I feel frustrated when pundits advocate one over the other, as if they have all the answers, have worked in every business culture, and know the solution to every possible business problem. Smart analytical minds know how to lead centralized teams within the culture they work in. Smart analytical minds know how to create a "coalition of the willing" in a de-centralized environment. I think the quality of the leader makes a much bigger difference than structuring the team based on a centralized structure or de-centralized structure.
Jeff O'Connor said:
Where I work, at least in the department that I directly support, analytics is seen as a technological deliverable rather than a job-related task. I suppose that means we've adopted the centralized model without actually creating a true analytics organization. On the plus side, it assures me a steady stream of work; the downside is that the overall value to the company would be greater if I were left to focus on "real" IS issues and left the charting, graphing, and pivot-tabling to my customers.
I don't mean to imply that by doing so we're somehow wasting my time or that of the other IS analysts throughout my group. What I am saying is that there's a real loss when the function of analysis is so tightly bound to a single department and its applications that it never even occurs to anyone that there might be a "bigger picture" to look at. Worse yet, the customers themselves sometimes fail to see the metrics and reports that we do generate as relevant to the *business*; instead they seem them as only being relevant to the application that generated them.
Am I alone in this, or have other people also experienced something similar?
Brian Timoney said:
Patrick Moynihan's quip the "everyone is entitled to his own opinion, but not his own facts" seems quaint these days where with the amount of subjective perspectivalism glibly offered in place of quantifiable measurement makes it seem everyone in the business world got their BA from the postmodernism-spouting English department at Duke.
And as a peddlar of interactive data visualization oriented towards middle- and upper-management, I continue to be dumb-founded by the push-back I get for suggesting that high-dollar decisions should be based on something other than the table-laden PDF or that great screen capture inserted into a Power Point slide...
That's why the Google Maps, Swivels, Zillows are so important: eventually people wake up and wonder why they can't do something similar at work.
BTW, the new rule is no references to Fernanda Viegas without accompanying photo...
Brian
Add a comment
If you're going to move the world, find the longest lever
By Chris Gemignani
December 12, 2006
Find more about:
Jon Udell—technology analyst, do-gooder, digital tinkerer, and one man media company—is heading to Microsoft with a license to question the status quo. This is good news for all of us. Good luck, Jon!



17 comments | Show all comments only the last 5 are shown
chris said:
I think the example we put in wikipedia gets to the message--the bar chart rules over the pie chart, especially when the categories are close to 1/5th of the area. Some people like to see pie charts, or rather, a pie chart. Think of it as a variety in your sentence structure. Sure, you should not end a sentence with a preposition, but sometimes that is up with something you can put.
If anyone wants to start a draft of Dot chart in wikipedia, the position is open.
Daniel Waisberg said:
Very interesting. In fact, I think I have never used a pie chart in my life, but I did not have anything against it. Now I understand why it never seemed to me a good way to explain data.
Very insightful post.
Jorge Camoes said:
I feel sorry for this little bastard, so let me play the Devil's Advocate role (it is not easy) .
People conveniently forget that some research (e.g. Spence & Lewandowsky, "Displaying proportions and percentages") actually shows that pie charts perform better than bar charts in some cases. Also, a pie chart has more anchor points (25%, 33%, 50%, 66%, 75%) than a divided bar chart, so it easier to estimate values.
Pie charts are in general misused. People ask them more than they can deliver by nature (they can't deliver much, but they are humble enough to recognize that). The difference between boys and grownups is that grownups know how/when to use them.
The *real* problem with pie charts is that Tufte doesn't like them. And he doesn't like them because they don't fit in his aesthetics agenda. Tufte's framework is just that, a framework, not the 10 Commandments ("Thou shall not use chartjunk..."). And you can use another one that fits your taste better. (This is a slippery floor, and I like Tufte, but sometimes his over-positivism seems to fall into Flatland.)
Also, it doesn't matter what you think and what your personal tastes are. What matters is what your audience thinks and likes and understands.
Perhaps you should ask your readers examples of best practices using pie charts. I am sure there are good examples.
The post shows so much Christmas rage :)
Now I risk to be instinctively slapped (and that seems sooo Tufte-esque...)
My role as Devil's Advocate ends here. In general I agree with the post.
Pie chart het blijft een discussie punt said:
[...] We hebben het er al eerder over gehad, de pie chart staat onder discussie. Juicy Analytics heeft gister nog een aantal nieuwe argumenten aangehaald, waarom de pie chart uit onderzoeksrapporten moet verdwijnen: [...]
Another Gary said:
I suppose there's a 12-step program for pie chart users; first step is admitting you have a problem -- and I apologize to all the readers of my pie charts in the past. Stacked bars (or tables!) are preferred in most cases. There may be at least a couple of capabilities of pie charts, though - 3-way comparisons, for one, and grouping by color/shading/proximity.
An example that combines these: a pie chart describing the composition of a legislative body with three major blocs, each of which comprises 1-3 political parties. A pie chart could display relative size of each of the parties, differentiate the blocs by using related colors within each bloc, and allow for fairly easy comparison of the size of blocs - the stacked bar could do the color grouping, I suppose, but the three-way size comparison might be handy to do with the pie chart. Just a thought.
I've been pie-chart free for six months, now.
Paul said:
I agree to an extent, but pie-charts are a form of chart that virtually everybody understands and can read.
I do personally prefer bar, colum and line charts wherever possible but I do also have pressure placed upon me to try 'mix up' the way charts look. For instance when viewing 6 reports over 2 pages people push for 'variety' in the presentation method. So even if say some basic bar-charts would be a better representation for the data they want variety. I think this reasoning, plus the fact that 99% of people I know/work with understand how to read a pie-chart this makes them worthwhile.
The more advanced-charts shown in this blog are fantastic but many of them require a lot of 'fiddling' to get them working (at least on the ones i've tried). The basic-charts that Excel give allow me to integrate auto-update and auto-manipulation to ensure that report production is rapid and reliable.
Now if I could find a way to implement these wonderful charts into my routines then I would be a happy man indeed, but working in a business with very standardised software/multi-computer use etc. and that becomes a little tougher. So whilst I agree they are maybe not the perfect thing, there is justification for their use.
Jorge Camoes said:
Paul
There is a serious problem of graphicacy in the corporate sector. The managers are not aware of that because they are very illiterate themselves (information visualization-wise). They think that a general-purpose Excel training is enough to create some charts to put on a report, just to embellish it, not for anything serious (decision making, for example).
People like pie charts because they are linked to the everyday life experience since one can remember. People don't like scatter plots because they are too abstract and don't fit in the daily routine. This is solved by education and training only.
If your audience asks you for 'variety' perhaps you could quote Druker ("good management is boring").
We have larger and larger databases, but we look at them through pie charts... It puzzles me.
"Heard about the guy who fell off a skyscraper? On his way down past each floor, he kept saying to reassure himself: So far so good... so far so good... so far so good." (La Haine)
Brad said:
As far as I'm concerned, a pie chart may still be the best tool for the job when you need to show the relative contribution of parts (the slices) to a whole (the pie). Bar graphs don't cut it because they fail to explicitly convey the sense of the whole; they only show you the parts. You could replace a pie chart with a single stacked bar, but I only think that's necessary in instances where the slices in a pie chart would be too similar in size for the viewer to judge the differences.
The litmus test in deciding whether to use a pie chart or a bar chart shouldn't be the data-to-ink ratio or a knee-jerk admonition to avoid using "the dreaded" this or that, but rather whether the chart you've prepared communicates effectively. If you've got a pie chart with a zillion slices and you can't tell what bits are more important than the others, then don't use a pie chart. But if your data offer just a few slices that are clearly differentiated from each other, and if your point is to show how a whole divides out into its major components, the pie chart might communicate more clearly than anything else.
del c said:
The problem with Brad's final sentence, as I see it, is that he's given the pie chart such an absurdly easy job to do that it stops making sense to use any graphical device at all. Why not just use a sentence or a table?
The point of resorting to info graphics, to me, is to communicate effectively <i>beyond the point where communicating with words and numbers alone is no longer effective</i>. And that is almost exactly the point where pie charts stop being effective.
Henk said:
The key question is: what is the purpose of the chart - what message is to be brought across.
I always learned pie charts are good for showing the distribution of a whole - the wh9le (circle) representing 100%. It is clear that when a large number of sections are necessary, a pie chart is meaningless - or at least difficult to read. Also, as in Zach's example of GA, with only a few slices there is no point using a graphical representation. I would say, empirically, that a division into say 4-8 sections could have a point for pies when relative distributions are important (% - e.g., market shares).
The bar chart is superior when the relative weight of distribution is the key point to make. A is larger than B, and the length of the the bar does a particular good job here, where the angle of the section (or surface for that matter, but I usually "see" the angle) is difficult to inteprete.
The stacked bar chart is to me about the same as the pie. It appears difficult to see the relative lengths in comparison; its only advantage over pie chart seems the lesser space it takes.
In conclusion: in almost every case the relative weight of the shares is what is of interest, even in classical cases where the books say a pie is indicated. E.g., what means a market share of 25% for A in itself? The relative position is important. The 25% has a total different meaning in case there are two others with respectively 65% and 10%, in comparison to the case that 10 companies fight for market share, A being #1, and B #2 with 17%. For this reason I believe the bar charts are more useful. But maybe this is just a personal preference.
Antanas said:
I fully agree with Henk. And if you show pie chart on the web you can use different roll over effects, pull out on click and other... I would be glad if google analytics could use these pie charts - personly I like them very much: http://www.amcharts.com/pie/examples/1/
The Problem with Pie Charts said:
[...] Juice Analytics has an interesting article on pie charts and how they can sometimes break the basic rules of data visualization. There are some interesting points worth noting. I’ve personally always been a fan of line graphs and bar graphs, though pie charts have there times. [...]
links for 2007-02-01 » Ross’ PhD Blog said:
[...] The Problem with Pie Charts - Juice Analytics It gives good stats, but Google Analytics delivers a surprisingly woeful user experience. This is just one small example of why. (tags: data visualization google presentation) [...]
Dan B said:
This is the best thing I've read in a long time. Thank you for making my week.
Nathan D said:
On the other hand, the rectangular pie chart, or marimekko chart, is extremely effective (http://www.mekkographics.com/sample/sample1.html#). It's like a 100% stacked bar in two dimensions, and it can clearly convey a lot of detail. It's so superior to the circular pie chart that I'm surprised it isn't more common.
Personally, I'm frustrated that I have to pay $500 to use it!
Don’t buy the pie at Vincenze’s Pit said:
[...] Juice Analytics on the problem with pie charts get to the core of the issue, pie charts don’t do what a chart is suppose to do, that is to facilitate data visualisation data, in fact they can do the opposite. [...]
Chris Wallace said:
A point I don't think has been made is the dependence on colour (usually) to distinguish the categories. A few months ago I sat through a presentation backed by pages of piecharts, which must have looked great on a colour displa but rather missed the mark when photocopied in black-and-white.
said:
Add a comment