Home » Excel Charts » Radar-Spider Chart

How to Make a Radar-Spider Chart in Excel

Use Radar-Spider Charts When Categories are Not Directly Comparable

Other examples would be 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.

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.

Alternatives to Radar Charts

Radar charts are seldom used because they are hard to read and interpret. For most data sets a Pareto chart is a better choice. Its easy using QI Macros add-in for Excel.

---

Ready to Take the Next Step and Upgrade Your Excel and Data Analysis Skills?

Stop trying to make your spreadsheets easy to read, because nobody wants to read your spreadsheet.
And stop using primitive line, bar and pie charts. Isn't it time to graduate to smart charts:
Control charts, Pareto charts and Histograms?

QI Macros add-in for Excel makes creating smart charts a snap. Try it Now!