A radar diagram compares the values of three or more variables to a central point. It is useful when you cannot directly compare the variables and is particularly good for visualization of performance analysis or survey data.
Here's a radar chart, so you can see what we're talking about. It is likely that you have run over them before, even if you didn't know it was what they were.
Creating radar charts in Excel is easy. In this article we show you how to create two types of radar maps: a common chart (as above) and a filled chart (as below, which fills in areas instead of just showing the outlines).
Let's first take a look at the sample data we will use for our examples.
We have three trainers: Graham, Barbara and Keith. We have evaluated them in five different categories (Knowledge, Delivery, etc.) And our Excel table contains these values.
Creating a radar chart in Excel
In this first example, we will create a radar chart showing the assessment of all three trainers.
Select all cells, including the line containing the names and column containing the assessment titles. Switch to the "Insert" tab and then click on the "Waterfall Map" button.
You can choose from three Radar charts that you want to select. Select the first Radar Chart option for this example. (The second option only adds markers in the values of the rows, the third option fills in the chart and we look at it a little later.)
 Now that you have inserted the chart into the worksheet You can start making some improvements.
Enter a table title
Select chart title and then enter a new title. When writing, the text writes the text in the form field.
When you press Enter, your chart will have a new title.
Move the legend
For another change, we can move the legend from above the diagram to the right.
When the chart is selected, four buttons are displayed floating at the top right. Click the "Chart Elements" button at the top, and turn the mouse over the "Legend" option. You see an arrow to the right. Click on it and then click on the "Right" option in the menu that appears.
Changing the radar diagram axis
In order to give our Radar chart greater influence and more clarity, we will change the axis to begin with three instead of zero.
Click the "Chart Elements" button again, turn over the "Axes" option, click the arrow that appears next to it, and then select "More Options".
The format axis box is shown on the right. We want to edit the setting "Minimum" under the section "Bounds", then click on that field and type "3" there.
The update of the radar plane immediately and now that we have increased the minimum Bounds value, you can more clearly see the differences in the assessments of the three trainers.
This example gives us a nice view of which trainers distinguish themselves on what qualities and how rounded their skills are.
Creating a full radar map
For a second example, we will create a filled radar plan for just one of the trainers. We will use Keith for this example.
First select the number of cells you need. In our example, we want the interval
A1: A6 and the interval
D1: D6 as shown below. To do this, hold the Ctrl key while selecting each additional cell you want to add to your selection.
Head now to insert> Waterfall> Filled Radar.
When creating a radar plane with only one data series, the axis is not started from zero as it did in our previous example. Instead, the smallest interface will be the lowest number within the number of cells you selected. In our case, the minimum tie is 4,4-a field under Keith's smallest score.
This chart helps you visualize how strong Keith is in each of the rated properties.
Please note that if we created more than one radar diagram (like saying, we wanted to show a separate chart for each of our trainers) we would like to make sure that the axis areas are consistent so that the data presentation is not misleading. So, for example, we would put the smallest tied to being a little below the lowest ranking of any coach and the maximum tied to being a little higher than the highest ranking of any coach. You can even remove the axle itself to reduce the disturbance on the chart.
Creating radar plans in Excel is easy, but getting the most out of them can require some extra attention. They can be a useful addition to your Excel reports in the future.