قالب وردپرس درنا توس
Home / Tips and Tricks / How to create a line map in Excel

How to create a line map in Excel



  Excel Logo

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.

 Completed Radar Chart

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).

 Radar diagram with a data series

Test data

Let's first take a look at the sample data we will use for our examples.

 Performance analysis data for our Radar Chart

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.)

 Create a radar chart [19659003] Now that you have inserted the chart into the worksheet You can start making some improvements.

 Example of first radar map

Enter a table title

Select chart title and then enter a new title. When writing, the text writes the text in the form field.

 Enter a map title

When you press Enter, your chart will have a new title.

 Radar chart with chart 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".

 Access to the axis 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.

 Set the minimum limit for the shaft

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.

 Completed radar map

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.

 Selection of interval for a filled radar diagram

Head now to insert> Waterfall> Filled Radar.

 Creating a Filled Radar Chart

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.

 Radar Chart with a Data Series

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.


Source link