How to Use Radar Chart for Competitive Analysis?

How to Use Radar Chart

What is Radar Chart

Radar charts are also known as web or spider charts are used to visualize multivariate(more than 2 variables) data. A radar chart is used to plot one or more groups of values over multiple common variables represented on axes starting from the same point. Each variable has its own axis, all axes are joined in the center of the chart.

When to use Radar Chart

We can use Radar chart in the following situations

  • When we have to compare two or more variables.
  • When our decision is based on a data-driven method,
  • When we wanted to understand a concept and how its value is changed over different parameters.

How to create radar chart in excel

To create a radar chart in excel we need to select our data first then go to Insert >> Insert Waterfall, Funnel, Stock, Surface, or Radar Chart >> Radar.

How to Use Radar Chart
How to create radar chart in excel

A new chart will like below image.

Radar Chart
Radar Chart in excel

How to read Radar Chart

If we see the above chart we observed there are 5 students which are on every side of the polygon(pentagon). Apart from this we also find the score of 4 subjects is available and it is visualized by the different colors of lines. Also, there is a scale from the center point to the highest point.

From this graph, it is easily interpreted that Jiya has the highest score in English. Also, we can see Shin got the highest in Chemistry.

1Excellent in comparing different variable easilyArea of the polygon varies with variation in the arrangement of axes.
2Takes less space as compared to othersRadar charts are harder to plot.
3Circles inside the chart can be used as grid lines for measurement.These charts are limited to a certain type of data.
4Radar charts are good at showing variation in dataToo many variable crowds up the chart and makes it unreadable.
Advantages and Disadvantages of Radar Chart

That’s all for now, will connect again with something new.

You can further read about Radar Chart Here

Leave a Comment