loading

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.

Radar Charts -

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 Charts -)
  • Radar with markers (Radar Charts -)
  • Filled radar (Radar Charts -)

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:

Radar Charts -
  1. Choose the range. A1:G4

Note: To access this menu, expand the ribbon.

2. Select Radar (Radar Charts -) from the drop-down menu after selecting the Insert menu and then the Other Charts menu (Radar Charts -).

Radar Charts -

You should get the chart below:

Radar Charts -

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:

Radar Charts -
  1. Choose the range. A1:G4

Note: To access this menu, expand the ribbon.

2. After selecting the Other Charts menu (Radar Charts -) by clicking on the Insert menu, select Radar with Markers (Radar Charts -) from the drop-down menu.

Radar Charts -

You should get the chart below:

Radar Charts -

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:

Radar Charts -
  1. Choose the range. A1:G4

Note: To access this menu, expand the ribbon.

2. Select Radar Radar Charts - from the drop-down menu after selecting the Insert menu and then the Other Charts menu (Radar Charts -).

Radar Charts -

You should get the chart below:

Radar Charts -

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:

Radar Charts -
  1. Choose the range. A1:G4

Note: To access this menu, expand the ribbon.

2. After selecting the Other Charts menu (Radar Charts -) by clicking on the Insert menu, select Radar with Markers (Radar Charts -) from the drop-down menu.

Radar Charts -

You should get the chart below:

Radar Charts -

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.

Share this Doc

Radar Charts

Or copy link

Explore Topic