« Chart cleanup | Main | Trying too hard »

Mar 17, 2008

Lunar eclipse

Todd B. sent me this pie chart, with a note: "Do the areas in the pie chart represent the numbers?"

Overlapmsnyahoo

The short answer is NO. 

It's also not so simple to figure out the areas of crescents.  The purple area looks tiny compared to the dark green region.  If shown this chart, we get the impression that  Microsoft's intention to absorb Yahoo! will not vastly expand the number of unique visitors to its properties because so many of their current users overlap.



The following is a bar chart representation of the same data.  Redo_overlapThe combined entity will have 31% more users than what Microsoft has right now.  Not a bad growth rate for a mature business!  The author of the original post calculated that Microsoft would in effect be paying about $1000 each to acquire these new users. 

Perhaps the most important question is how one values a "unique visitor".  Have anyone seen any sophisticated analysis on this topic?


 

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/t/trackback/452792/27157372

Listed below are links to weblogs that reference Lunar eclipse:

Comments

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.

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

Post a comment

Mentions


  • My Amazon.com Wish List

  • Yahoo! Picks

Recent Comments

Search Junk Charts


  • Custom Search

Residues

May 2008

Sun Mon Tue Wed Thu Fri Sat
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31