Spider Chart Alternatives
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
In You are NOT spider man, so why do you use radar charts? Chandoo presented a “petal chart” as an alternative to a radar chart (or spider chart, after its spider-web-like appearance). Here is the radar chart Chandoo wanted to replace:

And here is the replacement petal chart:

That’s a pretty jagged flower. I think the name “petal chart” probably refers to an idealized chart of this type:

Though the corresponding radar chart is somewhat meaningless:

It actually seems that the petal chart is even worse at allowing comparisons than the lowly radar chart. At least in a radar chart, the items being compared are all along the same spoke, whereas in the petal chart, they are distributed around the circle, 90° apart in this example. Also, the false zero values on either side of the categories for each petal can be distracting.
Radar charts are not very effective, despite their frequent appearance where scores in a set of categories are being compared. Their radial nature gives more emphasis to larger values toward the outside of the chart. If there are any zero values, the chart can become very difficult to read:

This bias toward larger values and the confusion caused by zeros can be minimized by selecting a more appropriate chart type, the familiar line chart:

The line chart is a better choice even if the radar chart has no zeros to confound the data:

A vertical line chart (or dot plot) is also a good choice:

Derek of Information Ocean has analyzed Chandoo’s radar and petal charts in Reorderable tables II: Bertin versus the Spiders. He applied Jacques Bertin’s assertion that charts are really just tables, and after a little rearrangement of the categories and series, came up with this spot matrix:

Derek rearranged the data to impart a diagonal trend to the chart. He likes spot matrix charts, but I’m not really wild about them. Bertin liked to use a stack of column charts to show this type of data, and I think I prefer Derek’s stacked chart to his spot matrix.

Shrink the stacked chart a bit, and it becomes a sparkline.

The radar chart is no better for ordering of the data:

The line charts and dot plots are improved somewhat by the ordering. The sorted data makes it easier to see that the yellow line (option 1 in Derek’s charts) is good in all areas except for usability (probably the worst category to rank poorly in). The blue line (option 2) has outstanding usability, but it’s at or near the worst in four of the other five categories.


Bottom line: Radar charts are not too effective for what they are often used for. Chandoo made a noble attempt to improve on them, but sticking to a chart with a circular shape wasn’t a good move: the petal chart looked nice, but it was even less effective at displaying the data. Line charts are one of the best choices, though Derek presented a couple good alternatives. Derek’s sorting of the categories helps to bring out patterns in the data, in his charts and in the line charts.
Possibly Related Posts:
Posted: Friday, October 3rd, 2008 under Chart Types.
Comments: 8
Comments
I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.
Read the PTS Blog Comment Policy.
Pingback from Excel Links of the Week [Oct 06] | Pointy Haired Dilbert - Chandoo.org
Time: Monday, October 6, 2008, 1:05 pm
[...] couldn’t agree with you more. Now, Jon Peltier has a follow up article on this topic where he dissects the petal charts and suggests what could be a better option for you. Also check out : Information Ocean post on [...]
Comment from jenmoocat
Time: Tuesday, October 7, 2008, 11:36 am
For me, the rule of thumb about charts is that your audience should be able to grasp the main insight in 30 seconds or less.
And — even after 5 minutes of staring at a radar or petal chart, I still have no idea what the main takeaway is supposed to be…..
And the other line graphs — just as bad, in my opinion.
Now, the spot matrix chart — that I understand.
And very quickly.
This kind of graphic is actually somewhat familiar.
I believe that I’ve seen similar ones on sites that compare and review consumer goods like electronics along various dimensions.
I do not think, however, that the options should be presented out of order.
Comment from jenmoocat
Time: Tuesday, October 7, 2008, 11:48 am
Now I am all excited about the spot matrix chart.
It might turn out to be a really good replacement for a stack of five, independent bar charts.
I understand that you don’t really like them, Jon, but (off the top of your head) do you have any insight on the best way to construct such a thing in excel?
Comment from Jon Peltier
Time: Tuesday, October 7, 2008, 3:50 pm
Jen -
Go to Derek’s post at Reorderable tables II: Bertin versus the Spiders. He probably has a link to his spot matrix resources.
Pingback from Excel Spot Matrix Charts - An Alternative for Radar Charts - Download the Template | Pointy Haired Dilbert - Chandoo.org
Time: Tuesday, October 7, 2008, 5:35 pm
[...] to Radar Charts I have suggested using a radar chart tweak to replace the radar charts. Both PTSBlog and Information Ocean have posted their critical reviews of these petal [...]
Comment from Chandoo
Time: Tuesday, October 7, 2008, 5:36 pm
@Jenmoocat - I have posted a small tutorial on creating spot matrix charts in excel here: http://chandoo.org/wp/2008/10/07/excel-radar-charts-replacement-spot-matrix-download-template/
you can download the template and play with it to suit your data / needs. I hope this helps you :)
Comment from Andy Pope
Time: Wednesday, October 8, 2008, 9:40 am
I did a spot chart some time back,
http://www.andypope.info/charts/spotlight.htm
Comment from Jon Peltier
Time: Wednesday, October 8, 2008, 9:50 pm
Andy -
Once the decision is made to make a grid, there are a wide range of alternatives. Your spotlight, which is like the spot matrix, which is like Harvey Balls, which is like your tile chart, which if you expand the tiles to fill the grid is like a heat map.










Write a comment