Dick Kusleika from the “Daily Dose of Excel” blog is a big fan of popular medical drama/Sci-Fi show House (as am I), and recently analyzed the commercial content of a DVR-recorded episode and charted it quickly with Excel. No surprise, an hour-long program is actually only about 40 minutes of real content.
Jon Peltier found his analysis, and saw an opportunity to analyze his chosen visualization (Stacked bars) in closer detail to see if there was a better way. Along the way, he and his commenters tried several different charts including pie charts, scatter graphs, bars, timelines, and segment analysis graphs to see what worked best. All of the discussion and examples are on his site.
Which do you think is best?
