Jul19

Extreme Makeover: Chart Edition - July 19

Categories: Business, Charts, Excel

As every week I end up receiving at lest one junkchart specimen, I’m starting the Extreme Makeover: Chart Edition series. I’ll show the old chart, the proposed improvement, and why I believe the old one doesn’t work. I’d love to hear your comments as well.

Here it goes:

And the makeover:


Problems:

  • Vertical labels: Even when the list of items is long and is tempting to use columns to use the width of the screen versus the height to show the items, it forces the audience to turn their heads to read the labels (or to not read them at all)

  • Clutter: Does your audience need to know to the dollar the GDP in each region? The new chart uses ‘000s. People will remember more easily data they get interested in. Will someone interested in the Shangdong province remember the GPD per capita is $3,162? More chance they will recall it was like 3.2 thousand, right?
  • More clutter: Once you label the bars/columns, why keeping the axis? Also, the arrow to highlight the 9x difference adds clutter to the chart
  • Lack of labels/legends/source: The original chart has an average line, which is evident only on close inspection because it is not labeled. Also, the columns are grouped in colors, without legends, so a reader, like me, is left clueless about their meaning. Finally, every chart using data must show its source (I’d have noted one if I knew where the original came from)

In charts, Simplicity is King: I’m assuming in the context of the presentation it was necessary to include every province by name.
“Is this cart needed? Is this level of detail needed?” That’s a question you should ask yourself before including any chart. The answer is completely situation-specific. What is the key message to communicate? Who is the audience? What will they look for from their specific viewpoint?

So, what do you think? How would you further improve my proposal?

Leave a Reply