« Hits and misses 2 | Main | Maps and dots »



Worth noting is that the clearer, simpler graph at the bottom is also easy to do in Excel. In many cases, you don't need fancier tools, you need more thought to what you are going to show.


I don't think that a line graph is the right solution, as these are - how do you call it: qualitative? - data, categories. So, no (cor)relation between them, which would justify a line graph. Instead, I would probably just use a simple bar graph.


An optimal solution needs the inadequacy of sun shadow to stand out. Maybe plotting proportion correct against most important factor would work, unfortunately not available.

It could be worse, the original could have used 3-D pie charts.


Stef: I tend to be less dogmatic about using line charts with categorical data than many others. In cases such as this, the lines do not mean anything: they are there to highlight gaps in the data. If the lines were not there, then we would have to use different symbols for each series, or different colors, and it'd be much harder to compare the groups!

Look up profile plot or parallel coordinates plot.

Code It Well

Excel will do this pretty well, enough to see what the pie wants to tell us.
But and this is good, better than excel.

The comments to this entry are closed.


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Kaiser Fung. Business analytics and data visualization expert. Author and Speaker.
Visit my website. Follow my Twitter. See my articles at Daily Beast, 538, HBR.

See my Youtube and Flickr.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Keep in Touch

follow me on Twitter