Speedometer with time series (Excel chart shop x2503)

,

Speedometer with time series If I had to get rid of a chart forever, I would probably choose the speedometer. It is a metaphor taken too far, a waste of premium screen real estate, and it tells you very little. That said, too many people like it and changing their minds [...]

Dotplot comparing two series (Excel chart shop x3031)

,

Dotplot comparing two periods Dotplots are nice alternatives to bar charts: they are much lighter and in many cases detecting a pattern is easier because the chart is much less cluttered. A frequent issue with dot plots is that, when comparing two periods, growth and decline are not obvious. The reader [...]

Pictorial bar chart (Excel chart shop x3041)

,

Pictorial graph Pictorial graphs are fun, so it means they are very ineffective and should never be used for serious data visualization. Let's leave this disclaimer, just in case. Now, I can think of many cases where you could use use a chart like this (many include kids, but not all). [...]

Square four-fold chart (Excel chart shop x1011)

,

Square four-fold chart Four-fold charts are interesting to represent a 2 x 2 table. Weight loss for people following diet A vs diet B and exercise vs  no exercise is a common example of when to use four-fold charts. They can be square or round. If you can't find the round one [...]

A bullet chart on steroids (Excel chart shop x2502)

,

Bullet charts on steroids I like to find ways of improving bullet charts, although not everyone agrees with that. I already have a version with a red alert, now I'm adding a blue alert (some managers say that there should be a positive feedback, and not only the negative variety. Often [...]