Need to Make a Radar-Spider Chart in Excel?
QI Macros can help you draw more than simple Radar-Spider charts!
Use Radar-Spider Charts When Categories are Not Directly Comparable
For example, sales of various product lines throughout the year or comparing products of two vendors using a list of various features. Radar charts plot data on an axis that starts at the center and ends on an outer ring.
Create Radar - Spider Charts using QI Macros
- Select your data.
- Click on QI Macros menu > Excel charts > Radar Spider Chart.
- QI Macros will do the math and analysis for you.
Example of a Radar - Spider Chart in Excel
Radar Chart Data Examples
How to Create a Radar Chart in Excel
To create a radar or spider chart in Excel, select your data, then click on the Insert tab, Other Charts, then Radar.
Consider a Pareto Chart Instead of a Radar Chart
Radar charts are seldom used because they are hard to read and interpret. For most data sets a Pareto chart is a better choice and its easy to create Pareto charts using QI Macros.