How to Create a Radar Chart in Excel

Excel logo

A radar chart compares the values of three or more variables relative to a central point. It’s useful when you cannot directly compare the variables and is especially great for visualizing performance analysis or survey data.

Here’s a sample radar chart, so you can see what we’re talking about. It’s likely you’ve run across them before, even if you didn’t know that’s what they were.

Completed Radar chart

Creating Radar Charts in Excel is straightforward. In this article, we’ll show you how to create two types of Radar Chart: a regular chart (like the one above) and a filled chart (like the one below, which fills in the areas instead of just showing the outlines).

Radar Chart with one data series

The Sample Data

Let’s first take a look at the sample data we’ll be using for our examples.

Performance analysis data for our Radar Chart

We have three trainers: Graham, Barbara, and Keith. We’ve assessed them in five different categories (Knowledge, Delivery, and so on) and our Excel table contains those ratings.

Create a Radar Chart in Excel

Read the remaining 33 paragraphs

Comments

Post a Comment

Popular posts from this blog

What is Microsoft Flow?

Image
As part of Microsoft’s push towards cloud and mobile apps, they’ve invested in several cloud-only additions to the old familiar Office apps. One of these is Flow, a trigger-based system for creating automated workflows. What Does Flow Do? If you’re the kind of person who reads How-To Geek regularly, you’re probably aware of the drive for personal productivity that’s been raging for pretty much the whole millennium. Flow is Microsoft’s attempt at giving you the kind of automation for notifications, alerts, data gathering, and communication that will help you spend less time on boring but necessary admin work and more time on interesting (and productive) things. Think of Flow as IFTTT , but with a slant towards the office rather than IoT or hardware. Flow allows you to create “flows” (short for “workflows”) that are based on trigger events. For example, you could create a flow that would download the responses to a Microsoft Forms questionnaire to Dropbox regularly, or post a messa...
Read more