Radar Charts
Excel Radar Charts
Multivariate data is displayed as values on radar charts in relation to a central point.
Multiple variables are present in multivariate data. A dataset including age and height, for instance, has two variables, making it multivariate.
Only data that can be sorted from low to high can be displayed on radar charts.
Note: Ordinal data are those that may be arranged in a hierarchy, such as numerical values or letter grades ranging from A to F. Ordinal data is covered in more detail at Statistics – Measurement Levels.
Radar charts are useful for displaying data outliers and similarities.
A data point that exhibits unusually high or low values in relation to the rest of the data is called an outlier.
Excel has three types of radar charts:
- Radar (
) - Radar with markers ()
- Filled radar ()
Note: Radar chart is also known as web chart, spider chart and star chart.
Radar
Data is displayed on radar charts as vertices on a polygon.
The value of the data point is displayed by the pertinent distance from the polygon’s center.
Example
Let’s examine the stats of Charmander, Squirtle, and Bulbasaur.
To keep up, copy the values:
- Choose the range. A1:G4
Note: To access this menu, expand the ribbon.
2. Select Radar (
) from the drop-down menu after selecting the Insert menu and then the Other Charts menu (
).
You should get the chart below:
The graphic provides a summary of the Pokemon stats.
Charmander is depicted in orange, Squirtle in gray, and Bulbasaur in blue.
Charmander has the fastest speed and the lowest special defense, according to the chart. Squirtle has the lowest special attack and the highest defense. The attack and HP figures of the three Pokemon are comparable.
Radar With Markers
Radar map and radar with markers are comparable. The data points are marked with markers, which is the sole change.
Example
Let’s examine how the Bulbasaur evolved in relation to the Ivysaur and Venusaur.
To keep up, copy the values:
- Choose the range. A1:G4
Note: To access this menu, expand the ribbon.
2. After selecting the Other Charts menu () by clicking on the Insert menu, select Radar with Markers (
) from the drop-down menu.
You should get the chart below:
The graphic provides a summary of the Pokemon stats.
Venusaur is depicted in gray, Ivysaur in orange, and Bulbasaur in blue.
The graph demonstrates how the stats rise in a comparable way with each evolution.
Filled Radar
Radar charts and filled radar are comparable. The charts’ interiors are colored, which is the sole distinction.
Example
Let’s examine the stats of Charmander, Squirtle, and Bulbasaur.
To keep up, copy the values:
- Choose the range. A1:G4
Note: To access this menu, expand the ribbon.
2. Select Radar 
from the drop-down menu after selecting the Insert menu and then the Other Charts menu ().
You should get the chart below:
The graphic provides a summary of the Pokemon stats.
Charmander is depicted in orange, Squirtle in gray, and Bulbasaur in blue.
Charmander has the fastest speed on the leaderboard.
Keep in mind that the chart is unable to provide any additional information due to the charts overshadowing one another.
Use caution when utilizing filled radar maps with several data columns since some data columns may obscure others.
Example (The Extreme Case)
Let’s compare the stats for Bulbasaur evolutions to Ivysaur and Venusaur.
Copy the values to follow along:
- Choose the range. A1:G4
Note: To access this menu, expand the ribbon.
2. After selecting the Other Charts menu () by clicking on the Insert menu, select Radar with Markers () from the drop-down menu.
You should get the chart below:
The gray-colored Venusaur dominates the other Pokemon in this chart.
This chart solely indicates that Venusaur’s stat values are either greater than or equal to those of Bulbasaur and Ivysaur.
