»Me, myself and BI«

Bissantz ponders


« previous | next »

Sure-fire ways to spoil data, Part I

In his bestseller “The Situation Is Hopeless, but Not Serious”, Paul Watzlawick describes how people can pursue unhappiness (or remain unhappy if they already are). In a similar yet unrelated topic, Howard Wainer explains how people can make consumers of charts miserable as well. According to the American statistician, anyone can succeed in spoiling data by following a few, simple guidelines:

  1. Show as few data as possible (i.e. Minimize the data density). If the chart looks too empty because it only contains a handful of values, fill the rest with pretty pictures that do nothing to help further explain the facts.

  1. Hide what data you do show. And there are many effective ways to do so. Use a flashy grid and print the data on it – but in a subdued color. Alternatively, you can firmly abide to the “never chop the axes” rule so that the interesting differences among the data are barely visible.

  1. Ignore the visual metaphor altogether. Do not sort data by size even if the chart type and data allow it. For example, use a bar chart but sort the data in alphabetical order.

  1. Only order matters. Use length as a criterion for organizing objects, but confuse readers by showing them as an area. This way, you can magnify even the smallest of differences.
  1. Graph data out of context. This works well with time-series analyses. If you want to disguise a strong drop of a value, simply start the chart with the following period. If the difference is minimal, just enlarge the scale and compress the X axis.

  1. Change scales in mid-axis. Simply take two rows of data, scale them individually and place each of them into a different chart. Then combine those charts to one – something for connoisseurs.

Leave a response

Friday, June 12th, 2009

Report Performance Measurement

Friday, May 29th, 2009

Palace evolution

Friday, May 15th, 2009

Criss-crossing circles

Friday, May 1st, 2009

The ‘moving’ means to an end

Friday, April 17th, 2009

Vis-à-vis is not yet visualization

Friday, April 3rd, 2009

Bean counter … and proud of it

Friday, March 20th, 2009

Gold mine or mine disaster?

Friday, March 6th, 2009

Your circles disturb me

Friday, February 20th, 2009

May you chop axes? No…you must!

Friday, February 6th, 2009

German Newspaper FAZ uses sparklines (well, almost…)


»Me, myself and BI« Bissantz ponders
DE Deutsch