Create a spot matrix chart in 10 easy steps

When you want to compare data, radar charts can be a great tool.  However, they are not always so easy to read.

radarImagine you have the data set below and you want to compare each of the four areas against the 5 data parameters:


You set up the calculation in the overall column:


where the data is found in columns D to H and the current area is on row 4.

Just looking at the data it is difficult to compare the data.  And when you look at the radar chart, with so many lines, it’s difficult to see each line.

Similar to my post on how to create a dot chart, you can create a spot matrix in Excel using the “Wingdings 2” font and formulae (download the spreadsheet here) original work by Matrix

How is it done?

  1. First create a copy of your original table and remove the numberstable copy
  2. Then open up character map (click on the start button and type charmap in the program search box)character map
  3. Choose “Wingdings 2” as the font™š›œ˜
  4. Select and then copy the symbols as shown in the picture above in that order
  5. Paste the symbols into your Excel spreadsheet.  Mine are in cell B1.
  6. Then in the first line and first column of your table (where you want the first symbol to appear), type in the formula:
  7. The MID function returns the characters from the middle of a text string, given a start position
  8. The FLOOR function rounds a number down to the nearest multiple of significance
  9. In other words, the FLOOR function returns a value between 1 and five.  If for example the FLOOR function returned a value of 2, then the MID function would display the second character from cell B1.
  10. Copy and paste the formula across the rows and columns of your table and the table is done.



Alesandra Blakeston

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s