Interesting Links for 3-April-2009

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.

Peltier Tech Chart Utility

Comments

  1. Love the Little Red Riding Hood animation! I can also imagine doing a similar concept with Goldilocks in which nutritional data were used to illustrate “too big,” “too small,” and “just right” in scientific terms!

  2. Matt – How about The Three Pigs, showing structural information about their building materials, plus comparisons of lung capacity of wolves, pigs, and other selected mammals.

  3. Jon – I too am linked to and get a lot of traffic from the Excel Pro Chart blog. It’s a little frustrating that I can’t read a single word on the blog. I have gotten a few comments from the writer and I think it’s legit.

  4. Tony – I think he’s cool; we’ve had a few email discussions. I tried using the Google translation service, and the result was a strange mix of technical and flowery text. I’m sure some technical and descriptive terms don’t make the jump reliably.

  5. Very timely. I’ve been looking for bad visualizations to include in a presentation this week so the link to Michael Friendly’s site is a great help.

    Excuse me…I’m going to go watch that Little Red Riding Hood movie again.

  6. Excel Pro is the most popular Excel chart evangelist blog as far as myself as a Chinese reader knows, and recommended by quite a few bloggers.

    Unfortunately I didn’t deep dive into it but I may bring up some proper translation of his declaration post.

    Regards,

  7. 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
    —————————————————————–
    Mr Liu said, he is very glad to bring a lot readers to your blog.
    comments about his blog? yes, it focused on what is the better way to present the data with the chart. and it use some easy way to show the best result.

Subscribe without commenting

Write a Comment

I welcome comments from my readers. If you have an opinion on this post, if you have a question, or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion. If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Subscribe without commenting

Peltier Tech Chart Utility

 

Create Excel dashboards quickly with Plug-N-Play reports.

 

Site by: Dawud Miracle, Business Coach & WordPress Websites