« Chart cleanup | Main | Trying too hard »



Why are you calling it a pie chart? It's a Venn diagram.

Tufte famously answered his own question, "What's worse than a pie chart?", with "Multiple pie charts", but another answer might be "A Venn diagram." Where a pie chart is bad at representing quantitative values by relative area, for a Venn diagram, it's frequently impossible, even in theory. I can do the arithmetic for the overlap of two circles, provided I'm allowed to assign the two circles different radii. I have suspected it's possible to represent the intersections of three circles quantitatively, provided they're allowed to be ellipses, and four circles provided they're allowed to deviate from symmetry to become a sort of pear shape, but that's as far as it goes, and I wouldn't like to even begin to work out the math.

And yet people very frequently arrive in the Excel charting newsgroup on Usenet asking where the option in Excel is for multiple overlapping circles with rigorously accurate areas, as if it's the most natural thing in the world. But a Venn diagram can't be a display of quantitative information: it's really a sort of table, like a grid, or a tree-shaped org chart. If you want the numbers, you have to write them in the cells and read them as numbers.

Jon Peltier

Derek - In which case a table is probably better, because it's simpler and the user isn't distracted by trying to over-interpret the overlapping shapes.


Your version does not show the overlap, or am I missing something?

Perhaps extend the blue bar down by 96.6 million?


derek: good point. I was following the reader's lead calling it a pie chart. That would be a stretch.

A Venn diagram is great for illustrating concepts but not data.

Bob: for making the original author's point, it's not needed to differentiate between the overlap and the customers who are exclusively Microsoft but you're right, my chart does not explicitly label the overlapping area


Derek: I somewhat disagree with the assertion that venn diagrams cannot possibly display data in a meaningful, intelligible way. For instance, I'm interested in plotting the concurrent use of substances. The Bayes theorem gets in the way when trying to explain the findings to stats lay people because of conditional probabilities in the context of with stochastic dependence. Example: Among all alcohol users, 30% smoke. Among smokers, 75% also drink alcohol. Clearly P(A|B) ~= P(B|A). I'm convinced this could be nicely graphed with a venn diagram. The size of the circles/eclipses would be the base rate in the population, the overlap would nicely show that the cigarette circle is almost completely embedded in the alc circle. Vice versa that would not be the case. THe alc circle had only a third covered by the cigs circle (I made up the data to explain). I'm desperately looking for software that can do proportional Venn diagrams. Despite your avwersions, any hints to such software? Google is not of much help. Thanks a bunch, Frederic


In this case a Venn Pie Chart might be as good as the bar graph.
Or, maybe even better.


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name is required. Email address will not be displayed with the comment.)


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Marketing analytics and data visualization expert. Author and Speaker. Currently at Columbia. See my full bio.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Good Books

Keep in Touch

follow me on Twitter