« 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.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name is required. Email address will not be displayed with the comment.)


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Marketing analytics and data visualization expert. Author and Speaker. Currently at Columbia. See my full bio.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Good Books

Keep in Touch

follow me on Twitter