Skip to main content

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

Popular posts from this blog

Quality dataviz about quality-of-life issues

To accompany its Better Life Initiative, OECD (the Organization for Economic Co-operation and Development) has put up a handsome, carefully constructed set of interactive data graphics called the Better Life Index:
There is more to life than the cold numbers of GDP and economic statistics – this Index allows you to compare well-being across countries, based on 11 topics the OECD has identified as essential, in the areas of material living conditions and quality of life. Each country is represented by a multicolored flower with 11 petals (OK, yes, potentially cheesy). The length of each petal represents the country's score in a given area; the width of the petal indicates the importance the user has assigned to that particular aspect. Drilling down into the details is easy to do; in fact, if you've a mind to do your own visualizations of this info, the underlying index data can be downloaded in spreadsheet format.

Kudos to Moritz Stefaner, Jonas Leist and Timm Kekeritz (for Raure…

Cool Map: Emissions worldwide

From the Center for Public Integrity comes this interactive map showing greenhouse gas emissions from many of the world's largest economies.

Lots of data is packed into this simple interface, and the map itself is blessedly clear.

Note, though, that when it comes to infoviz issues, even these pros needed a do-over. Check out the message in the lower left corner. In an earlier version they made the common mistake of comparing circles based on radius, instead of by area. It's to their credit that not only did they fix the mistake, but they also owned up to it and made the change. The larger problem, though, is that distinguishing the relative size of circles is not easy for the average viewer; rectangles are clearer, and would probably have made this cool map even stronger.

Note also that stats are from 2005. Since then there's been substantial economic growth in China (for example), so the current numbers are likely to be even higher than what's shown here.

Differing Vie…

What Not to Do with Infographics, now in handy infographic form

From Visual.ly, a cautionary illustration that expresses exactly what I hate about so very many infographics. It dumbs down information under the guise of making you smarter.

Browse more infographics.