Excel Radar Charts can be used to compare multiple variables to a central point and show the difference between sub-groups.

Radar Chart in Excel is very handy to show a rating on several performance areas.

It is useful when analyzing results from a survey, compare target vs actual values, performance review, etc.

In this article, you will be provided with a detailed guide on:

 

What is an Excel Radar Chart?

Excel Radar Charts are used to show a multi-variate comparison in a 2-dimensional form.

It is a graphical representation of data that can be used to display a lot of information into a single image.

It is sometimes called a spider or star chart. Each spike in the chart represents a data and the length of the spike is the magnitude of that data point.

A Radar Chart has three main sections in it: Plot Area, Chart Title, and Legend. A Plot Area

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

 

Types of Excel Radar Charts

Radar Charts are of 3 types – Radar, Radar with markers, and Filled Radar.

  • Radar Chart – This is a basic radar chart and it displays values that are relative to the central point.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

  • Radar with Markers – This is a Radar Chart that displays markers on the data points.
    Create an Excel Radar Chart For Performance Reviews | MyExcelOnline
  • Filled Chart – In this Radar Chart, the entire radar is filled with a color.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

Let’s look at the detailed tutorial on How to create a Radar Chart in Excel!

 

Examples of Excel Radar Charts

Example 1: Performance Chart

When I had to give out performance reviews, it was a very helpful snapshot for me to show to my colleagues how their performance was compared to last year!

Here is an example of a table with several ratings:

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

In this example, I show you how easy it is to insert a Radar Chart using Excel.

 

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

Follow the step-by-step tutorial on how to create Excel Radar Charts and make sure to download the Excel Workbook to follow along:

DOWNLOAD EXCEL WORKBOOK

STEP 1: Highlight your table and go to:

Insert > Recommended Charts (Excel 2013 & above)

Insert > Other Charts (Excel 2007 & 2010)

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

 

STEP 2: Select All Charts > Radar > Radar with Markers > OK

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

 

STEP 3: Now you have your Radar Chart.

Excel Radar Chart

Now you can use your radar chart to convince your own boss that your performance has skyrocketed this year!

You can even change the shape and size of the marker displayed on the line. To do that, follow the steps below:

STEP 1: Select the line and Press Ctrl +1 to open the Format Series dialog box.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

STEP 2: Select Fill Icon and then Select Marker.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

STEP 3: Under Built-in option, select type and size that you want.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

Let’s try to use this chart with another example!

Example 2: Competitive Analysis

A survey was conducted regarding the comparison of 3 different Mobile Phone Brands and the results were combined in the data table.

In the table below, you have a survey data that compares 3 mobile company brands based on various categories.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

Looking at this data in one glance, it will be difficult to judge which brand is preferred by the customers. So, let’s create an Excel Radar Chart using this data.

STEP 1: Select the table containing the data.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

STEP 2: Go to Insert > Waterfall, Funnel, Stock, Surface or Radar Chart > Radar Chart (In Excel 2019)

Go to Insert > Stock, Surface or Radar Chart > Radar Chart (In Excel 2013)

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

Your Excel Radar Chart will be ready.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

To change the type to Radar with markers or filled Radar Chart:

STEP 1: Select the existing chart

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

STEP 2: Go to Chart Design > Change Chart Type

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

STEP 3: In the Change Chart Type dialog box, select the desired chart you want to change to and then Press OK.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

If you select Filled Radar Chart, this is how your chart will look like.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

From the chart, you can easily infer that based on the survey result, Brand B is preferred over the other two.

 

Example 3: Sales Analysis

The below data shows weekly sales performance (in $ ‘000) of various products sold in a supermarket:

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

You can use this data to create a Radar Chart in Excel.

STEP 1: Select the Data Table

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

STEP 2: Go to Insert > Recommended Chart (Excel 2013 & Above)

Insert > Other Charts (Excel 2007 & 2010)

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

STEP 3: In the Insert Chart dialog box, Go to All Charts > Radar Charts and then Press OK.

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

This is how your Sales Analysis Excel Radar Chart will look like:

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

In the Radar Chart, the weekly sales figure for various products are shown with the axes varying from 0 to 600.

Sales for each product are easily comparable on their own axis and the overall difference is visible based on the size and shape of the polygon formed.

Let’s discuss in detail the merits and limitations of using a Radar Chart!

 

Advantages and Disadvantages of Excel Radar Charts

Advantages:

  • It is useful to show a lot of information in a single image.
  • It is more useful when you want to know the overall picture, not an exact value.
  • It is useful when values or categories are not directly comparable.

 

Limitations:

  • The more the number of webs in the chart, the more complicated it gets and harder to analyze.
  • Too much data makes the chart crowded and harder to interpret.
  • It is not ideal for making a trade-off decision.

 

Conclusion

In this article, you have learned in-depth about the Radar Chart Excel, its types, steps to create a chart in excel, and its advantages and disadvantages.

Excel provides a plethora of charts to choose the right one for your data. To take a look at them, click here.

 

HELPFUL RESOURCE:

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline