# Excel Radar Charts

## Radar Charts

Radar charts show multivariate data as values relative to a center point.

Note: Multivariate data has more than one variables. For example, a dataset containing age and height is multivariate because it has two variables.

Radar charts can only show data that can be ordered from low to high.

Note: Data which can be placed in an order, from low to high, like numbers and letter grades from A to F are called ordinal data. You can read more about ordinal data at Statistics - Measurement Levels.

Radar charts are suited for showing similarities and outliers in the data.

Note: An outlier is a data point that has unusually large/small values compared to the rest of the data.

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

Radar charts show data as as vertices on a polygon.

The relevant distance from the center of the polygon shows the value of the data point.

### Example

Let's compare the stats for Bulbasaur, Charmander and Squirtle.

Copy the values to follow along:

1. Select the range `A1:G4`

Note: This menu is accessed by expanding the ribbon.

1. Click on the Insert menu, then click on the Other Charts menu () and choose Radar () from the drop-down menu

You should get the chart below:

The chart gives a visual overview for the Pokemon stats.

Bulbasaur is shown in blue, Charmander in orange and Squirtle in gray.

The chart shows that Charmander has the highest speed and lowest special defense. Squirtle has the highest defense and lowest special attack. The three Pokemon have similar HP and attack stats.

## Radar With Markers

Radar with Markers is similar to radar chart. The only difference is that the data points are highlighted with markers.

### Example

Let's compare the stats for Bulbasaur evolutions to Ivysaur and Venusaur.

Copy the values to follow along:

1. Select the range `A1:G4`

Note: This menu is accessed by expanding the ribbon.

1. Click on the Insert menu, then click on the Other Charts menu () and choose Radar with Markers () from the drop-down menu

You should get the chart below:

The chart gives a visual overview for the Pokemon stats.

Bulbasaur is shown in blue, Ivysaur in orange and Venusaur in gray.

The chart shows that with each evolution, the stats increase in a similar manner.

## Filled Radar

Filled radar is similar to radar chart. The only difference is that inside the charts are filled with color.

### Example

Let's compare the stats for Bulbasaur, Charmander and Squirtle.

Copy the values to follow along:

1. Select the range `A1:G4`

Note: This menu is accessed by expanding the ribbon.

1. Click on the Insert menu, then click on the Other Charts menu () and choose Radar () from the drop-down menu

You should get the chart below:

The chart gives a visual overview for the Pokemon stats.

Bulbasaur is shown in blue, Charmander in orange and Squirtle in gray.

The chart shows that Charmander has the highest speed.

Note that since the charts are overshadowing each other, the chart cannot give any more information.

Caution: It's better to avoid using filled radar charts with multiple data columns because some data columns can overshadow others.

### Example (The Extreme Case)

Let's compare the stats for Bulbasaur evolutions to Ivysaur and Venusaur.

Copy the values to follow along:

1. Select the range `A1:G4`

Note: This menu is accessed by expanding the ribbon.

1. Click on the Insert menu, then click on the Other Charts menu () and choose Radar with Markers () from the drop-down menu

You should get the chart below:

In this chart, Venusaur, which is shown in gray, overshadows all the other Pokemon.

The only information this chart gives is that Venusaur has larger or equal stat values than both Bulbasaur and Ivysaur.

×

## Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com

## Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookie and privacy policy.

Copyright 1999-2024 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.