This is the first in a new weekly series of interesting links. Tune in every Friday morning for more.
Chart Galleries and Guidelines
Here are a few sites that provide charting guidance, and examples of how to and how not to make effective graphics.
Michael Friendly’s Gallery of Data Visualization – The Best and Worst of Statistical Graphics
Gary Klass’ Just Plain Data Analysis, which is actually the companion website to Gary’s book, Just Plain Data Analysis: Finding, Presenting, and Interpreting Social Science Data.
March Madness in April
This was more timely last week, but I’ll include it anyway. I’m not into the whole college hoops thing, I find basketball boring. But I liked Gilligan (Tim Wilson)’s improvement on ESPN‘s Game Flow graph in Data Visualization – March Madness Style. Rather than tracing both teams’ scores from bottom left to top right, Tim plots score differential. This lends itself to a small multiples layout of the charts, which can be arranged by bracket, and a quick glance at a bunch of these can give you an idea of how teams progressed up the ladder and how many upsets occurred.
A Chinese Excel Blog
A colleague in China has started an Excel blog in his native language. Liu Wanxiang’s blog is Excel Pro Chart Blog. The focus is on charting and analysis using Excel. I can’t actually read the blog, but it has referred its readers to a number of my pages lately, so it must at least be pretty good! If anyone can vouch for the Excel Pro Chart Blog’s quality, please add a comment below.
Modern Retelling of Little Red Riding Hood
Tomas Nilsson has recreated the old fairy tale of Little Red Riding Hood in this clever animation. I particularly enjoyed all the clever little infographics embedded within it.
Upcoming PTS Training Events
Second Excel Dashboard Boot Camp – May 2009: Join Mike Alexander and Jon Peltier in an intensive three-day training session covering advanced data and charting techniques for Excel dashboards.
Advanced Excel Conference, June 2009: Two days of Excel programming and charting on the Boardwalk with Bob Umlas and Jon Peltier.