Peltier Tech Blog

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Add-Ins

Peltier Tech Waterfall Chart Utility
Peltier Tech Cluster-Stack Chart Utility
Peltier Tech Box and Whisker Chart Utility
Peltier Tech Marimekko Chart Utility
Peltier Tech Dot Plot Utility
Peltier Tech Cascade Chart Utility

 
Excel Dashboards

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Spider Chart Alternatives

by Jon Peltier
Friday, October 3rd, 2008
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

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:

radar chart

And here is the replacement petal chart:

petal chart

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

petal chart

Though the corresponding radar chart is somewhat meaningless:

radar chart

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:

radar chart

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:

line chart

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

line chart

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

vertical line chart

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:

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.

stacked charts

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

stacked charts

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

radar chart

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.

line chart

vertical line chart

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.

Related Posts:

Bookmark and share this entry:
  • Twitter
  • Digg
  • Facebook
  • LinkedIn
  • del.icio.us
  • Technorati
  • StumbleUpon
  • Google Bookmarks
  • Reddit
  • MySpace
  • Slashdot
  • Yahoo! Buzz
  • Tumblr

Learn how to create Excel dashboards.

Comments


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

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.

If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Read the PTS Blog Comment Policy.





Subscribe without commenting

Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.