Imagine having two annoying little bloggers looking over your shoulder and trying to mess up with the chart you are making….
I am still waiting, go ahead, imagine…
Now come back, that is exactly what “The Chart DoctorBusters” is all about. It is a new series of posts on PHD and Jon Peltier where we take badly made charts, one at a time and suggest improvements, alternative visualization options and corrective measures.
For a doctor to be really good, he needs to have really sick people. In our case we need bad charts. I mean really bad ones with all those 23 colors or 17 pies or stressful extra grid lines or .. ok, you get the picture.
Here is what you should do:
- Upload your chart or excel workbook to a public site like skydrive.
- Now go to this google docs form and submit your charts
- (alternatively you can tweet us on @r1c1 or @Jon_Peltier)
Here is what Jon and I will do:
Every week we will take one of the really bad charts and post an entire article dissecting the problems and prescribing the treatment. We will take turns, so one week it will be Peltier and next week it will be me. We will also try to comment on each other’s treatment. With some luck, we should get other leading authorities in charting world to come and comment here.
Some rules to keep in mind:
- We are talking about charts here, not complicated dashboards or vibrating visualizations.
- As much as possible try to post the actual data associated with the chart and tell us clearly what you think the chart was trying to achieve.
- Remember, even parapsychologists get psyched.
- Have fun 🙂














4 Responses to “Office 2010 Contest Winners are here!!!”
I while ago I wrote a post on selecting a couple of names from a range via an UDF
I could have been handy.... especially because I didn't win.... lol
http://xlns.lamkamp.nl/?p=14
Sweet! I won! Thank you so much, Chandoo! I'm really speechless! I'll look out for an e-mail from you. Again, I really appreciate it, and I can't wait to fire it up!
Sincerely,
Tom "this one" 🙂
Thank You... Thank You... Thank You... 🙂
Hi,
Don't want to ruin your party.. 😉 but I noticed that when you sort the list A2:B11 (step 2), the RAND function re-calculates the numbers so that they are different and in mixed order again. I had to paste the whole area as values first and then sort to get it to work.
Wonder if the same happened to you because in your list at least Greg has a higher value than Tom 🙂