Site icon Best Excel Tutorial

How to Make a Radar Chart in Excel

This Excel tutorial guides you through the process of inserting and formatting a Radar Chart, also known as a Spider Chart or Web Chart.

Your data might resemble a simple sales table, containing categories such as phones, online, email, office, and shop.

Inserting a Spider Chart

Select all the data cells. In this example, we’ll choose cells from A3 to E8.

Find and click on the radar chart symbol. Then, choose one of the radar chart types that suits your data.

Our Radar Chart:

How to read a Spider Chart?

A Radar Chart differs from regular Excel charts, so it’s crucial to understand how to interpret a spider chart.

Advantages of Radar Chart

There are a few exceptional advantages of radar charts which you may concider during the data type choise for your data:

An Example: I used to play managerial computer games and remember using radar charts to decide which football player to buy. In this scenario, the green web appears much better. His Defending, Speed, Vision, and Attacking skills surpass those in the blue web. You might only consider the skills of the blue footballer if you need Aerial skills or for other factors not visible in the chart (e.g., price, age, etc.).

Similarly, when comparing products for advertising, companies for mergers, or employees for promotion using a Spider Chart, these advantages can help you make informed decisions.

Exit mobile version