Fixing a junky chart:
Jon Peltier breaks it down for us

At the PTS blog, Excel charting whiz Jon Peltier takes an all-too-common type of crappy chart and walks the reader through his methods for analyzing and improving it. He starts with this:


... and ends up with this far better version:


The second version is far clearer and more scaleable — not to mention that it's more correct mathematically. (He alters the bars to make them all the same width; this does away with any questions about whether the varying widths mean anything, and if so, what that might be.)

Overall, Peltier's site is a handy resource, with pages of newbie-friendly tutorials and tips here. Thanks, Jon.

Comments

Post a Comment

Popular posts from this blog

I want to be Jorge Camoes when I grow up.

Portuguese infoviz enthusiast Jorge Camoes has spent the last year and a half writing informed, insightful blog posts on the field, complete with examples and citations. To his credit, he approaches everything -- even the revered work of Edward Tufte and Stephen Few -- with loving skepticism. I'm gratified, too, that he seems to agree with me on one central point: Snazzy tools alone don't get you good data visualization. It all comes down to putting serious thought into the project before you plot the first data point. In future posts we'll discuss more of Jorge's ideas. Bem feito, o Sr. Camoes!
Read more

Hype and backlash:
visualizing pop culture trends

Image
Back in 2005, the astute pop-culture chronicler Adam Sternbergh pointed out that a person's opinion of any given entertainment product depends largely on how long they've been aware of it — that is, where the product sits on the sine-wave timeline of public expectations (aka buzz). His findings, in chart form: "Welcome to the undulating curve of shifting expectations—the Heisenbergian principle by which hype determines how much you enjoy a given pop-culture phenomenon. The first-wave audience is pleasantly surprised, but the second-wavers feel let down; then the third wave finds it’s not as bad as they’ve heard—and they’re all watching the exact same show." Almost five years later, this pattern describes just about all our collective experiences. Sports fans, how much sweeter was it to watch the New Orleans Saints come out of nowhere to win the NFC championship than to have seen the Minnesota Vikings do it for the umpteenth time? As for politics, consider the poll
Read more

Critique: NYT unemployment graphics

Image
To illustrate the horrible unemployment numbers announced today ( "employers in the United States have shed about 3.6 million jobs since December 2007" ), the New York Times presents a series of graphics : 1 ) We have a perfectly nice bar chart here: clear, legible, professionally done, all that. This chart tells us two (2) things: what month it is and how many jobs were lost. Surely there is additional info about this two-year stretch that would add depth and meaning (and potentially even yield an epiphany or two!). One suggestion: The story says, "Manufacturers eliminated 207,000 jobs, more than in any year since 1982. The construction industry eliminated 111,000 jobs. And retailers, who were wrapping up their worst holiday shopping season in years, eliminated 45,000 jobs." Segmenting each bar by color to represent the various sectors would show at a glance where the biggest losses were coming from. 2) Again, a perfectly nice fever chart. (I don't mean to min
Read more