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.
A new chart will like below image.
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.
S.N. | Advantage | Disadvantage |
1 | Excellent in comparing different variable easily | Area of the polygon varies with variation in the arrangement of axes. |
2 | Takes less space as compared to others | Radar charts are harder to plot. |
3 | Circles inside the chart can be used as grid lines for measurement. | These charts are limited to a certain type of data. |
4 | Radar charts are good at showing variation in data | Too many variable crowds up the chart and makes it unreadable. |
That’s all for now, will connect again with something new.
You can further read about Radar Chart Here