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

Imagine 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:

=AVERAGE(D4:H4)

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 Chandoo.org:

### How is it done?

1. First create a copy of your original table and remove the numbers
2. Then open up character map (click on the start button and type charmap in the program search box)
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:
=MID(\$B\$1,FLOOR((C4-1)/5,1)+1,1)
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.

Enjoy!

Alesandra Blakeston