Transforming Analytics from Qualitative to Quantitative
Thursday, October 9th, 2008Almost a year ago now, I wrote a post on the topic of Harvey Balls and how they can be used as a qualitative analysis tool. I have seen them used primarily in Consumer Reports and also in many marketing departments. Shown below is an example of the five scale Harvey Ball font that can be used in analysis.
The problem with this font is that it is not included in the default Excel package. In my original post, I included a link to a site that provided this font, which can be added to the default Excel fonts. Adding a new font isn’t that hard, but it does take an effort. The downside of this font is that it is a derivative of pie charts, which have shown to be ineffective in data visualization.
Chandoo at Pointy Haired Dilbert just wrote a post describing how to use Wingdings2 to accomplish the same type of visual. Also, he included a formula to automate the process when you have a table of data that you want to visualize.
So a table like this can easily become…
this Spot Matrix chart:
Using the Wingdings2 font:
Check out Chandoo’s post to see the formula to automate this process.
I think there are some limitations to this type of data visualization because it can be hard to identify/quantify the variance between two coordinates in the table. For example, can you tell the difference between Option 2 – Availability and Scalability or option 2 and option 4 Availability using the spot matrix chart above? It’s very difficult. I think the use of a table with conditional formatting can be a more effective tool for analysis. A table wouldn’t pass the pretty chart test, but would be more effective.
Suggested Reading:
