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

  1. Select your data.
  2. Click on QI Macros menu > Excel charts > Radar Spider Chart.
  3. QI Macros will do the math and analysis for you.

Example of a Radar - Spider Chart in Excel

spider chart in excel

Radar Chart Data Examples

spider chart or 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.

making a radar chart in excel

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.


Stop using old technology!

Upgrade Your Excel and Data Analysis Skills to Smart Charts Using QI Macros.

Track Data Over Time

Primitive Chart
line graph
Line Graph
Smart Chart
control chart
Control Chart

Compare Categories

Primitive Chart
pie chart
Pie Chart
Smart Chart
pareto chart
Pareto Chart

Analyze Variation

Primitive Chart
bar or column chart
Bar or Column Chart
Smart Chart
histogram
Histogram

QI Macros add-in for Excel makes creating smart charts a snap.