قالب وردپرس درنا توس
Home / Tips and Tricks / How to Create a Radar Chart in Excel

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.

Here's a sample radar chart, so you can see what we're talking about.

 Completed radar chart

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

 Radar Chart

The Sample Data

Performance Analysis data for our Radar Chart ” width=”640″ height=”271″ src=”/pagespeed_static/1.JiBnMqyl6S.gif” onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);” onerror=”this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);”/>

We have three trainers: Graham, Barbara, and Keith.

Create a Radar Chart in Excel

In this first example, we will create a Radar Chart that shows the assessment of all three trainers.

Select all the cells. Switch to the "Insert" tab and then click the "Waterfall Chart" button.

You can choose from three radar charts from which to pick. Choose the first Radar Chart option for this example.

 Create a Radar Chart [19659003

 First Radar chart example

Enter a Chart Title

Select the title and then type a new title.

 Entering a title

 Radar Chart with title

Move the Legend

For another change,

When the chart is selected, you'll see four buttons hovering at its top right. Click the "Chart Elements" button at the top, and then hover your mouse over the "Legend" option. You'll see arrow to the right. Click that and then click the "Right" option on the menu that appears.

Modify the Radar Chart Axis

Click the "Chart Elements" button again, to give our radar chart a greater impact, and more data clarity. hover over the "Axes" option, click the arrow that appears next to it, and then select "More Options."

 Accessing the axis options

The Format Axis pane appears on the right. We want to edit the "Minimum" setting under the "Bounds" section, so click this field and type "3" there.

 Setting the minimum bound for the axis

The radar chart updates

 Completed Radar chart

This example gives us a nice view of which trainers excel at which qualities, and so how well their skill sets are.

Create a Filled Radar Chart

For a second example, we will create a filled radar chart for just one of the trainers. We want to use Keith for this example.

First, select the range of cells that you need. In our example, we want the range A1: A6 and the range D1: D6 as shown below.

 Selecting ranges for a filled Radar chart

Now head to Insert> Waterfall Chart> Filled Radar.

 Create a filled radar chart

When you create a radar chart using only one data series, it does not work in our previous example. Instead, the minimum bound will be the lowest number in the range of cells you selected. In our case, the minimum bound is 4.4-one tick below Keith's minimum score.

 Radar Chart

Keith is in each of the assessed qualities .

Note that we have more than one radar chart (like, say, we wanted to show a separate chart for each of our trainers) is not misleading. Thus, for example, we would set the minimum bound to the highest ranking of any trainer and the maximum to be higher than the highest ranking of any trainer.


Creating radar charts in Excel is simple, but getting the most out of them can require some extra attention. They may be useful addition to your Excel reports in the future.


Source link