Pinterest Pixel

Create an Excel Radar Chart For Performance Reviews

Excel Radar Charts can be used to compare multiple variables to a central point and show the... read more

Download Excel Workbook
Bryan
Posted on

Overview

Create an Excel Radar Chart For Performance Reviews | MyExcelOnline Create an Excel Radar Chart For Performance Reviews | MyExcelOnline

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

 

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

  • Radar with Markers – This is a Radar Chart that displays markers on the data points.
    Create an Excel Radar Chart For Performance Reviews
  • Filled Chart – In this Radar Chart, the entire radar is filled with a color.
See also  How to Create Excel Radar Chart - Step by Step Guide

Create an Excel Radar Chart For Performance Reviews

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

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 workbookRadar-Chart.xlsx

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

Create an Excel Radar Chart For Performance Reviews

 

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

Create an Excel Radar Chart For Performance Reviews

 

STEP 3: Now you have your Radar Chart.

Create an Excel Radar Chart For Performance Reviews

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:

See also  How to add Trendline in Excel Charts

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

Create an Excel Radar Chart For Performance Reviews

STEP 2: Select Fill Icon and then Select Marker.

Create an Excel Radar Chart For Performance Reviews

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

Create an Excel Radar Chart For Performance Reviews

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

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

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

Your Excel Radar Chart will be ready.

Create an Excel Radar Chart For Performance Reviews

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

STEP 2: Go to Chart Design > Change Chart Type

Create an Excel Radar Chart For Performance Reviews

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

See also  Win/Loss Sparklines

Create an Excel Radar Chart For Performance Reviews

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

Create an Excel Radar Chart For Performance Reviews

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

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

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

Insert > Other Charts (Excel 2007 & 2010)

Create an Excel Radar Chart For Performance Reviews

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

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

Create an Excel Radar Chart For Performance Reviews

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.
See also  Draw a Logo with a Scatter Chart in Excel

 

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

If you like this Excel tip, please share it
Create an Excel Radar Chart For Performance Reviews | MyExcelOnline Create an Excel Radar Chart For Performance Reviews | MyExcelOnline
Create an Excel Radar Chart For Performance Reviews | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...