EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Charts Radar Chart in Excel
 

Radar Chart in Excel

Udiksha Sable
Article byUdiksha Sable
Madhuri Thakur
Reviewed byMadhuri Thakur

What is a Radar Chart in Excel?

A radar chart in Excel is a graph that has several axes (lines) starting from a single point in the middle. Each line shows data from a separate data column, and the data points connect in a circular manner. Because of its appearance, it is also called a spider, polar, star, or web chart.

It’s useful for comparing multiple variables and their values in a single chart, making it easy to identify patterns and variations among the data points.

 

 

Table of Contents
  • What is a Radar Chart in Excel?
  • How to Read & Interpret It?
  • Types
  • How to Make a Radar Chart in Excel?
    • Simple Chart
    • Chart with Markers
    • Chart with Fills
  • How to Edit the Chart?
  • How to Change the Chart Design?
    • Overall Chart Design
    • Line Color
    • Marker Color
    • Chart Color
    • Font Color

How to Read a Radar Chart?

Let’s say you want to compare the top 5 products your electronics company sells. In this example, we use the sales data from the second quarter of 2023 to create a radar chart in Excel, where:

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

  • Each line will represent one of the products
  • The dot on each line is the sales amount for that particular product.

chart 1

#1: Interpreting Radar Chart with a Single Data Point

Since we only have one data point for sales, we can read the radar chart in Excel as follows:

  • If the dot is closer to the center (origin), the lesser the sales.
  • If the dot is farther from the center, the higher the sales.

So, the data point that is farthest from the center will be your best-selling product. In this case, the smartphone is your highest-selling product. This way, you can see the products that are already doing good and the products that you need to focus on.

#2: Interpreting Radar Chart with Multiple Data Points

In the earlier example, we only had one data point (sales), but we can also use it to study multiple data points.

Imagine you are choosing a top-rated tourist spot for a trip. You create a spider chart where each axis represents a specific tourist place. The points on the lines show ratings for Sightseeing, Food, History, and Transportation at each place.

Chart 2

We can interpret each data point individually, as follows:

  • Switzerland stands out in Sightseeing, followed by Italy
  • Italy stands out in History, followed by Paris
  • Paris excels in Food, while Italy comes second
  • Dubai and New York have higher ratings in Transportation.

We can also compare all the metrics together to know which tourist spot has the highest rating in all aspects. We can see that the best place to visit will be Paris, as it has the overall highest rating (all its data points are equal to or above 4).

Types of Radar Charts in Excel

Excel has 3 types of radar charts, depending on how we present the data. We can use lines only, lines with markers, or even filled areas to present the information.

1. Simple Radar Chart

It is the simplest radar chart in Excel, where only lines connect the data points.

Ice Cream Flavour Ratings-1

2. Radar Chart with Markers

In addition to lines, this spider chart uses dots (markers) to show the data points on the axes.

Ice Cream Flavour Ratings-2

3. Radar Chart with Fills

This type of web chart doesn’t use lines or dots; instead, it fills the space between the data points completely.

Ice Cream Flavour Ratings-3

How to Make a Radar Chart in Excel?

Let’s assume the box office earnings of three movie franchises (Marvel, Star Wars, and Jurassic Park) over five years. To visualize their performance, we will create three types of Radar Charts: Simple, with Markers, and with Fills.

You can download this Radar Chart Excel Template here – Radar Chart Excel Template

Given:

Example 1

Solution:

A) Simple Radar Chart

Step 1: Select the data, including the years and earnings for each franchise.

Simple Radar Chart Step 1

Step 2: After that,

  • Go to the Insert tab in the Excel ribbon
  • Click on Recommended Charts.

Simple Radar Chart Step 2

Step 3: Then,

  • Select Radar from the All Charts list
  • Choose the first chart type to create a basic radar chart in Excel.

Simple Radar Chart Step 3

Step 4: Select any Chart Pattern from the options and click OK

Simple Radar Chart Step 4

The resulting web chart is given below, named Radar Chart.

Box Office Collection 1

B) Radar Chart with Markers

Step 1: Follow the first 2 steps from the above example of Basic Radar Chart.

Step 2: Select the second chart type to create a Radar Chart with Markers.

Radar Chart with Markers 1

The result is displayed below, named Radar Chart with Markers.

Simple Radar Chart Step 5

C) Radar Chart with Fills

Step 1: Follow the first 2 steps from the above example of Basic Radar Chart.

Step 2: Select the third chart type to create a Radar Chart with Fills.

Radar Chart with Markers 1

Below is the resulting spider chart, named Radar Chart with Fills.

Radar Chart in Excel-Box Office Collection 2

The above spider charts compare the box office earnings of different movie franchises over five years, with the option to add markers and fill for easy understanding.

How to Edit a Radar Chart in Excel?

Suppose you made a radar chart in Excel but accidentally forgot to select some data points from the source. In such cases, you can easily edit the chart using the following methods.

Let’s say we have the following data and we create the given chart:

How to Edit -1

Radar Chart in Excel-How to Edit Chart

However, if you pay attention, you will see that the chart does not have data about Aquaman, meaning that we did not select the complete data.

How to Edit Given

Solution:

To add data for Aquaman, we can edit the chart as follows,

  • Select the created chart
  • Click on Select Data present in the Chart Design tab.

How to Edit Given Solution Chart

  • The Select Data Source dialog box will appear, as shown below.

Radar Chart in Excel-How to Edit Given Solution Chart 2

A) Method 1 to Add Data

Change the data range in the Chart Data Range text box. Here we will change =Sheet5!$B$2:$B$8 to =Sheet5!$B$2:$B$9 to select the whole data.

Method 1

Once you click Ok, you can see the new complete chart.

Method 1-1

B) Method 2 to Add Data

Step 1: Do the following when the Select Data Source dialog box appears:

  • Select Edit from Horizontal (Category) Axis Labels
  • Enter the Axis label range as =Sheet5!$B$2:$B$9 instead of =Sheet5!$B$2:$B$8
  • Click on Ok in the Axis Labels dialog box.

Radar Chart in Excel-Method 2-1

Step 2: After that,

  • Select Strength from Legend Entries (Series)
  • Select Edit in the Legend Entries (Series)
  • A new dialog box will appear, where you can enter the Series values as =Sheet5!$B$2:$B$9 instead of =Sheet5!$B$2:$B$8.

Method 2-2

Step 3: Repeat the second step for all the other attributes (Speed, Intelligence, Power, and Technique).

Result:
This method will add Aquaman’s strength, speed, intelligence, and all other performance aspects to the chart, as shown below.

Radar Chart in Excel-Method 2-2

How to Change the Chart Design?

To make the chart more presentable, you can change the chart design, the background colors, and the markers (dots) color.

For instance, let us start with the chart below and make its appearance changes.

How to Change

1. Chart Design

To use a different design style,

  • Select the chart
  • Go to the Chart Design tab
  • Select any design from the Chart Styles group

Result:
The selected design will automatically apply to the chart.

Radar Chart in Excel-Chart Design

2. Line Color

To color the lines,

  • Click on the chart and then click on the Chart ElementPlus Sign
  • Select Axes → Select More Options.
  • Select the line from the chart that you want to change the color. The Format Data Series dialog box opens
  • Select the Fill icon Fill Signand then click on the Line option
  • Choose the desired color from the option named “Color.”

Line Color

Result:
You can see the changes in the color of the line “Power” from yellow to blue.

Line Color 2

3. Marker Color

To add new colors to your markers, do the following,

  • Double-click on the chart and the Format Data Series box will appear
  • Select the marker you want to change the color for
  • Choose the Marker option from the dialog box
  • Choose a new color as per your needs from the Color
Note: Make sure you have created a web chart with markers; otherwise, you won’t be able to see the necessary options.

Radar Chart in Excel-Marker Color

Result:
The marker color for the Intelligence aspect turns from Grey to Orange.

Marker Color 2

4. Chart Color

To fill in the chart,

  • Double-click on the chart, and the Format Chart Area dialog box will appear
  • Open the Fill dropdown list
  • Select the color as per your requirement from the Color option in the list.

Result:
The color of the overall chart changes from black to sandal (light yellow).

Radar Chart in Excel-Chart Color

5. Font Color

Follow the below-given steps to change the font color in the chart design,

  • Click on the Chart
  • Go to the Format tab
  • Select the required section on the chart, such as Chart Title, Legend, Category Labels, etc.
  • Choose a style from the WordArt Styles

Font Color

Overall Result:
After applying all the formatting, including the font color, your chart will finally look like this.

Radar Chart in Excel-Font Color 2

Frequently Asked Questions (FAQs)

Q1. When to use radar charts?

Answer: Radar charts offer several benefits that make them useful for visualizing and comparing data:

  • Comparing Multiple Data Sets: You can easily compare multiple data at the same time.
  • Better Visual Appeal & Easy Pattern Recognition: The chart design makes it simple to find any patterns and makes the chart more engaging and easier to understand.
  • Identifying Outliers & Inconsistencies: These web charts make it easy to see which data points are very different from others as well as find any areas that need attention or improvement.
  • Helps in Decision-Making: It simplifies complex data, making it easier to make informed decisions and communicate insights to others.
Q2. Name some radar chart alternatives.

Answer: We can use several charts and graphs instead of spider charts in Excel. Some of the most appropriate are pie charts, line charts, bar graphs, and histograms. However, if you need more advanced charts, you can use conditional formatting data bars, sparklines, heatmaps, and area charts.

Q3. What alternative tool can we use besides Excel to create a radar chart?

Answer: Excel is the best tool you can use to create radar charts. As an equally simpler alternative, you can use google sheets. However, there are several other tools like Tableau and Power BI that can help you create radar charts.

Recommended Articles

This article explains the meaning of radar chart in Excel. We have added steps on how to create as well as edit a spider chart. We have added several easy examples for your understanding. You can refer to the following articles to learn about more Excel-related topics.

    1. Comparison Chart in Excel
    2. Pie Chart in Excel
    3. Column Chart in Excel
    4. Excel Formulas

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Radar Chart Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Radar Chart Excel Template

EDUCBA

डाउनलोड Radar Chart Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW