Are you excited about this twitter chart?
In this ironically titled “Let’s not get too excited” chart, David shows us how the twitter community is divided.
It looks stunning. According to this chart, Out of every 100 people (or accounts) on twitter,
- 20 are completely inactive
- 50 are lazy or not tweeted in last one week
- 5 have more than 100 followers
- 5 are loud mouths and hence tweet heavily and contribute to 75% of twitter volume.
- 20 are gray colored
Out of curiosity I went to the source of these statistics from which the info-graphic is made.
If my reading comprehension skills are to be trusted, the article in no way conveys that all the above 5 types of people are different. That means there can be overlaps. So the chart is trying to mislead us.
In plain speak, it is possible that the lazy group can have more than 100 followers.
Also, the entire “completely inactive” group is a subset of “lazy” group. Point #6 in the original source for this graph confirms this:
Half of all Twitter users are not “active.” If you take a general description of being “active” on Twitter to mean that you have posted a tweet at some point in the last 7 days (1 week), then the survey learned that 50.4% of all Twitter users fit this category. If you remove the 21% from point #1, this leaves about 30% of users who have an account and have tweeted before, but happen to be inactive now.
What is the most important lesson this can teach us:
- Next time you plot percentages (either in a pie chart or square pie) make sure there are no overlaps. Each block is complete in itself. Otherwise, just list them down as a bunch of stats and don’t bother making a chart.
I am not too excited about this chart. What about you ?
PS: Follow me on twitter. I am not lazy, inactive, loud mouthed or gray.
PPS: Browse more examples of bad charts and learn from others mistakes.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Time to showoff your VBA skills – Help me fix ActiveSheet.Pictures.Insert snafu||Twitter Formula Contest – We are 5000 strong now »|