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.
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).
The Sample Data
Let’s first take a look at the sample data we’ll be using for our examples.
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
In this first example, we will create a Radar Chart that shows the assessment of all three trainers.
Select all the cells, including the row that contains the names and the column that contains the assessment titles. 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. (The second option just adds markers to the values on the lines; the third option fills the chart, and we’ll be looking at that one a bit later.)
Now that you’ve inserted the chart into the worksheet, you can begin to make some improvements to it.
Enter a Chart Title
Select the chart title and then type a new title. As you type, the text will appear in the Formula Bar.
When you press Enter, your chart will have a new title.
Move the Legend
For another change, we could move the legend from above the chart to the right.
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 an arrow to the right. Click that and then click the “Right” option on the menu that appears.
Modify the Radar Chart Axis
To give our Radar chart a greater impact, and more data clarity, we will modify the axis to begin at three instead of zero.
Click the “Chart Elements” button again, hover over the “Axes” option, click the arrow that appears next to it, and then select “More Options.”
The Format Axis pane appears on the right. We want to edit the “Minimum” setting under the “Bounds” section, so click that field and type “3” there.
The radar chart updates immediately and now that we’ve 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 excel at which qualities, and also how rounded 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 will 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. To do this, hold the Ctrl key while you select each additional cell you want to add to your selection.
Now head to Insert > Waterfall Chart > Filled Radar.
When you create a radar chart using only one data series, the axis does not start from zero the way it did 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.
This chart helps you visualize how strong Keith is in each of the assessed qualities.
Note that if we were creating more than one radar chart (like, say, we wanted to show a separate chart for each of our trainers), we would want to make sure the axis ranges are consistent so that the data presentation is not misleading. So, for example, we would set the minimum bound to be a bit below the lowest ranking of any trainer and the maximum bound to be a bit higher than the highest ranking of any trainer. You could even remove the axis itself to reduce clutter on the chart.
Creating radar charts in Excel is simple, 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.
- Excel Tips
- Excel Functions
- Excel Formulas
- Word Tips
- Outlook Tips
How to create radar chart/spider chart in Excel?
There are various charts in Excel, and every type of chart has its own superiority. However, for better and more quickly to analyze the benefit and stability of a department, I think the radar chart can be a good choice. Now this tutorial will talk about creating a radar chart which is also named spider chart in Excel.
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools : Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools : Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color ; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment.
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Create radar chart in Excel
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
It is easy to create a simple radar chart in Excel.
1. Select the data range you need to show in the chart. See screenshot:
2. Click Insert > Other Charts > Radar, and select the radar chart type you like, here I select Radar with Markers. See screenshot:
Tip: In Excel 2013, click Insert > Insert Stock, Surface or Radar Chart > Radar. See screenshot:
Now the radar chart is created with the axis labels.
If you just want to view the benefit or stability of the each department, you can delete the axis labels for clearly viewing.
3. Right click at the axis, and select Format Axis from the context menu. See screenshot:
4. In the Format Axis dialog, select None in Axis labels drop down list, and close this dialog. See screenshot:
Tip: In Excel 2013, click on LABELS to expand its option in the Format Axis pane, then select None in the Label Position list. See screenshot:
Now you can see the radar chart as show below:
Radar charts are a great way to visualize two-dimensional data and show the differences between sub-groups. Think of them as a line chart that’s been wrapped around a central point, where the y-axis of the line chart starts from the central point and extends upwards. The lines will also wrap around the central point and meet up again where the “end” of the line chart meets the “beginning”. I’ll show you a super-easy way to make them in Excel.
Though, don’t forget you can easily create a radar chart using Displayr’s free online radar chart maker!
We’ll need some data.
First thing’s first – we can’t create a chart without some data. I’ve got some aggregated data in a table already that shows what people’s preferred cola is by age categories. Here’s what it looks like:
Some differences are noticeable already in the table (Diet Pepsi doesn’t seem to be doing too well!), but other differences are not so easy to spot.
. to make our radar chart
To turn this into a radar chart, all I need to do is select the data on the work-sheet (i.e. from A1 to G7), and in the ribbon, click the radar chart drop-down in the Insert > Charts part of the menu. This will create a basic radar chart in the spreadsheet for you.
Customizing your radar chart.
This chart isn’t particularly pretty, and there’s a few things we can do to improve its appearance. First, let’s make it a little bigger, and move the legend to the side. To increase the size, simply select the whole chart, and click-and-drag one of the circular nodes along the outer edge of the chart itself. Next, go to Chart Tools > Design > Add Chart Element > Legend > Right. This will move the legend to the right of the chart, so that the good stuff takes up the maximum amount of space inside the overall chart container.
. and making it pretty
We can make it even easier to read: let’s reduce the decimal points down to none. Select the same data that you selected before we created the radar chart again. Then, in the ribbon, go to Home > Number and click the button with the blue arrow pointing towards a 0 on the right-hand side. This reduces the number of decimals that show in your input data, which updates the chart directly.
The middle of the chart is still a little messy though, and the scale points (percentages) overlap with a lot of my data series. Let’s simplify these even further by double-clicking the column of percentage points in the chart. The Format Axis pane will open on the right, and I can specify the number of units I would like to use here. Under Axis Options > Units > Major I’ll use 0.2 instead of 0.1. The chart will update with the percentage points set at intervals of 20. After these steps, here’s what I have:
I can do one more thing to make the chart easier to understand. Let’s tie in the series in the chart with the brand colors. Most likely your chart will have data about something completely different, but do consider common color associations. Off-set color choice with ease of reading the chart. You don’t want too many colors that look similar to one another to avoid confusion.
To change the color of one of the series in my chart, click the line itself to select it, then over on the right, under Format Data Series select the fill bucket icon, then Line > Color. In the Colors dialogue select the color you want to use or type its RGB values. I ran into trouble here, because the color palettes of Coca Cola and Pepsi are quiet similar, so some inspiration was gathered from the cherry-flavored variety of Pepsi. Here’s the final product:
Filled radar charts
There are more options in Excel to experiment with. For example, we can turn our radar chart into a filled radar chart. This will only work if you have a few series of data, and your colors are set to have a high level of transparency. Because of overlapping series, it quickly becomes difficult to read. Here’s the same chart again, including all the same series from before, but presented as a filled radar chart with a color transparency of 85%:
As you can see, it becomes difficult to distinguish the smaller central series from the others, and so the more series you have, the less useful this sort of chart becomes. Best to stick to three or fewer series to make this easily read.
Ready to move beyond Excel? There are other ways to create visualizations that offer more advanced options and flexibility. Check out more visualization ideas!
By Tepring Crocker | –> December 10, 2015
Categories: Charts, Excel® Tags: how to make a radar chart
Pie charts, bar charts and line charts are familiar friends to Excel users. But there’s a less well-known chart out there that can pack a lot of information into a single, visually powerful image. The Radar Chart, also sometimes called a spider or star chart, lets you compare multiple items against multiple criteria. You could use it to see how temperatures change in multiple locations over the course of a year, or quickly compare products in several different areas.
We are going to create a chart that will help us choose a new phone system for our office. We have gathered information from three different vendors and given each a performance score of 1-100 in eight areas that are important to us such as reliability and maintenance costs. Our table conveys the information, but doesn’t really help us understand which vendor might perform best overall, if any do.
To follow using our example, download Create a Radar Chart.xlsx This article applies to Excel 2007 and later versions. Images were taken using Excel 2013 on Windows 7.
Create a Radar Chart
- Select the data that you want to use for the chart.
- On the Insert tab, click the Stock, Surface or RadarChart button and select an option from the Radar A preview of your chart will be displayed to help you choose.
Note: In Excel 2010, the Radar charts are located under the Other Charts button.
There are three default Radar charts you can choose from: Basic Radar, Radar with Markers, and Filled Radar.
Once your chart is created, you can customize the colors, labels, and text as you would any chart. Click on the Design and Format tabs in the Chart Tools contextual tab to find Chart styles and other editing tools.
The radar chart is one of those “love it or hate it” tools. This is probably because there is some data that it works really well for, and for some it merely creates confusion and annoyance. The trick is to use it sparingly, and only on those specific tasks to which it is most suited.
A Radar chart is a graphical method of displaying multivariate data in the form of a two-dimensional chart. It is one of the built-in chart types in MS Excel. This chart has many names such as spider chart, radial chart, or web chart. In the radar chart, each variable has its own axis, all axes are joined in the center of the figure. In this post, we will see how to Create a Radar Chart in Excel Office 365.
To know more different types of Excel Charts , refer to this link.
- Insert a Radar Chart
- Pros and Cons
Insert a Radar Chart:
- Primarily, you need to select the data range that you want to create a chart.
- On the Insert Tab, select the Radar Chart drop-down list under the Charts section.
- Then, you need to click the Radar Chart option.
Select the Radar Chart option
- Finally, you will get the output as shown in the below image.
Pros and Cons:
- Uses Compact space.
- It can handle more than one data series.
- It is difficult to read.
- This chart may confuse users because of its unusual type.
In this post, you can clearly understand the steps to Create a Radar Chart in Excel Office 365. Kindly, share your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!
CHARTS are the graphic representation of any data . EXCEL provide us a number of visualization options in the form of different charts and graphs etc.
EXCEL gives us a variety of charts which are beautiful, colorful, more customizable and more powerful.
In this article we are going to discuss one particular type of the charts which are known as RADAR CHART.
A RADAR CHART IS A SPECIAL TYPE OF CHART IN THE SHAPE OF A STAR WITH DIFFERENT VARIABLES OR PARAMETERS REPRESENTED ON THE AXES ARISING FROM THE SAME CENTER AND VALUES ARE PUT ON THE AXES.
In RADAR CHARTS, the values are shown on different axes.
We’ll discuss in detail, the information about the RADAR CHART and the way to create one in EXCEL.
WHAT IS A RADAR CHART
A RADAR CHART is a chart in the form of a star or a polygon with different parameters plotted on the axes which arise from a center and the values are shown on the axes. The values are then joined to the adjacent axes with the simple lines.
A sample RADAR CHART is shown below.
[LOOK AT THE PICTURE ABOVE]
A RADAR CHART has the different axes arising from a single point as it is clear in the chart above, all the axes are arising from 0.
The variable which are the height, weight and chest are marked for each and every student on respective axes.
After marking, all the values are joined together to form a polygon.
The radar chart is known by many other names such as
STAR CHART, STAR PLOT, COBWEB CHART, POLYGON CHART, POLAR CHART AND KIVIAT DIAGRAM ETC.
In the next section, we take a look upon the different apt situations where we can make use of RADAR CHARTS.
One star represent the variation among different series.
WHEN DO WE NEED RADAR CHARTS
A RADAR CHARTS should be used when
- We want to represent a data with multiple variables. For example , the details of students’ height, weight and chest as shown in the picture above.
- When we want to visually know the contribution of a parameter in a glance for every reading.
- We want to represent the PERFORMANCE METRICS showing the strengths and weaknesses.
- For Quality Control programs.
BUTTON LOCATION FOR INSERTING A RADAR CHART IN EXCEL
The RADAR CHART can be inserted through the INSERT MENU > CHART and choosing RADAR chart or by directly choosing the CHART BUTTON on the toolbar and then choosing the RADAR chart.
RADAR CHART BUTTON ON TOOLBAR
- The chart button is situated on the right portion.
- Click the button. Chart Editor will open. 
- Choose the RADAR CHART from the CHART TYPE DROP DOWN.
- Click the RADAR CHART option.
STEPS TO SET UP THE DATA FOR RADAR CHARTS
It is always easy to create a chart if we lay down the data properly.
Similarly, for the RADAR CHARTS it is important to know the layout of the data for the perfect chart , as we require.
The FIRST COLUMN can be used to provide the LABELS. These will form axes.
The FIRST ROW will contain the CATEGORIES. These will be plotted on the axes and joined with each other to form a radar chart.
OTHER COLUMNS can be used to enter values.
A sample of the table and the radar chart for the table are shown below.
The RADAR CHART for the data is shown below. The steps to create the chart are discussed in the next section.
The radar chart is known by many other names such as
STAR CHART, STAR PLOT, COBWEB CHART, POLYGON CHART, POLAR CHART AND KIVIAT DIAGRAM ETC.
In the next section, we take a look upon the different apt situations where we can make use of RADAR CHARTS.
STEPS TO INSERT A RADAR CHART IN EXCEL
We can demonstrate the chart using an example. We are taking the example of a class where we see the variation of height, weight and chest of students. [ The example is just for the learning purpose. It may not represent an apt situation to use radar chart. Refer to the section WHEN DO WE NEED RADAR CHARTS for learning the situations where we can use RADAR CHARTS.
The procedure to insert a RADAR chart are as follows:
We can use a Radar chart or spider chart to show ratings or visible concentrations of strength and weaknesses in our data. We can also use the radar chart to do performance analysis of an employee, student, satisfaction of a customer and many other rating conditions across multiple categories. In this tutorial, we will illustrate how to create a spider or radar chart.
Figure 1 – Creating a spider chart
How to Make a Radar Chart for Multiple categories
- We will create a data sheet (table) as displayed below.
Figure 2 – Spider chart data
- We will go to the Insert tab, select Other Charts and select Radar with Marker Chart. If we are using Excel 2016, we can find Radar with Marker under the Waterfall group in the Insert tab
Figure 3 – Making a spider chart
- This will create a blank Radar chart in our sheet.
Figure 4 – Creating a blank radar chart
- We will right-click on our chart and click on Select data
Figure 5 – Making a spider graph
- We will click on the Add button and click on Cell B3 to enter the series name for 1 st Quarter. Next, we will highlight Cells B4:B12 to enter the values for our series. Then we will click OK.
Figure 6- Using a radar chart
- We will repeat the procedure for all the quarters.
Figure 7 – Spider web chart range
- We will click OK.
Figure 8 – Radar charts using four categories
- Now, we will enter the data for the Horizontal category.
- We will click on Edit under the Horizontal Category Axis labels. Next, we will highlight Cell A4:A12 to enter the range.
Figure 9 – Spider charts axis labels
- Finally, we will click OK to go back to the Select Data Source window.
Figure 10 – How to make a radar chart
- Now, we will click OK to view our chart.
Figure 11 – Making a radar chart
Formatting the Radar Chart
We can always format our chart to display what we want.
- To add a chart title, we will go to the Design tab and select the Add Chart Element button. Next, we will enter the name for our chart.
Figure 12 – Spider web chart
- We can also format the marker lines. We will right-click on each line, click Format Data and then select No Line (or solid line as we wish).
Figure 13 – Formatting data series
Like the column chart or other 2-dimensional charts, we also have an X and Y axis in the Radar chart. But in the radar chart, the X-axis is positioned at the end of the spider while the Y-axis is positioned at each step. The zero points of the radar chart begin from the center of the wheel and the closer the spike to the end of the spike, the higher the value.
Therefore, in our radar chart, the years we see at the ends of the charts is the X-axis while the Y-axis is represented by the numbers 0 to 3,000.
Figure 14 – How to make web chart
Instant Connection to an Excel Expert
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.
with data like below
I’m trying to create a radar chart in excel – I get the following chart – however since the values are very close the results from the three tests are overlapping each other. How do I adjust the axis limits such that the differences are displayed in the chart ? I was able to change it only for one axis – the one corresponding to metricA.
6 Answers 6
To compare the three tests without fiddling with the axis scales, you can try some sort of standardization – I got an OK result with subtracting the difference between a test score and the mean average of the test scores for that metric e.g. =B2-AVERAGE($B2:$D2)
So if your test data is in B2:D7 like this:
Then put that formula in and copy across and down to get:
Gives this chart:
Other formulas I tried with:
=(B2-MIN($B2:$D2))/(MAX($B2:$D2)-MIN($B2:$D2)) which is a normalization giving a number between 0 and 1
=STANDARDIZE(B2,AVERAGE($B2:$D2),STDEV.P($B2:$D2)) which leverages Excel’s STANDARDIZE function.
You didn’t specify the application domain, so I don’t know what these numbers mean.
The first best solution is what others also wrote: to change the range of values.
A) Differences instead of absolute values (if the essential question is their difference).
B) Ratios. In other cases their ratio to each other or to the average of the group or to an external standard value is more important, like the industry standard is -85, so test1 is at 102% – this differences will not be bigger but all metrics will have the same data range, so the scale can be adjusted to show the differences better.
C) Compare to an industry average and a standard deviation (e.g. test1 is 2.5 sigma from the standard regarding metricA)
The second best solution is to use a clustered column chart or multiple charts.
The third best solution is to improve somehow this radar thing, and make visible that all the three are essentially at the same place. For this, you can change the thickness and style of the lines (as below) or of the markers.
It is not possible to change the axis scale for different angles on a radar chart. However, we can create a scatter plot that recreates a radar chart where you can specify the range of values for each angle, essentially allowing you to specify the axes limits as per your question.
We’ll create a scatter series for each test. For each metric, you’ll specify the axis range you want. We’ll place each score along the axis range you specify, and then point the values at different angles based on the metric, simulating a radar chart. Each series will then loop back to metricA again to close the loop.
Setting up the data:
Angle (360 degrees split up into 5 angles):
- metricA: 0
- metricB: =2*PI()/5
- metricC: =2*2*PI()/5
- metricD: =3*2*PI()/5
- metricE: =4*2*PI()/5
Scale lower and Scale upper: Freely set the axis range for each metric
x1: (x-coordinate for each scatter point)
In cell F2: =SIN($B2)*(E2-$C2)/($D2-$C2)
y1: (y-coordinate for each scatter point)
In cell G2: =COS($B2)*(E2-$C2)/($D2-$C2)
The formulas for x and y can be filled down for all metrics, and then copied across for each test.
Finally, duplicate metricA in the bottom row: In cell A7: =A2 And fill this across all columns
Then, create a scatter plot with lines between the points:
- Add each series one at a time
- Set the x and y axes to fixed ranges from -1 to 1
- Resize the plot area to be square-shaped
- Hide the major gridlines, tick marks and axis labels to make the scatter plot look more like a radar chart
You manually enter any values you want for scale lower and scale upper values. For my chart, I set the lower limit of each metric as being the lowest value minus 10% of the difference between highest and lowest value, and I set the upper limit as being the highest value plus 10% of the difference between highest and lowest value. This result in all lowest points being the same distance from the middle and all highest points being the same distance from the middle. The middle value for each metric is scaled based on it’s value compared to the highest and lowest values.
Scale lower: =MIN(E2,H2,K2)-(MAX(E2,H2,K2)-MIN(E2,H2,K2))/10
Scale upper: =MAX(E2,H2,K2)+(MAX(E2,H2,K2)-MIN(E2,H2,K2))/10
If you needed, it would also be possible to add pseudo axes and gridlines to make the scatter plot look even more like a radar chart. It would just be necessary to add additional series to plot the axes and gridlines and format them as thin gray lines to mimic normal axes and gridlines.
- LinkBack URL
- About LinkBacks
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Linear Mode
- Switch to Hybrid Mode
- Switch to Threaded Mode
Adding Secondary Axes to Radar Charts
I’ve recently made some radar charts comparing manufactures based on their scorecards. They look good, but I would like to take it a step further and add different weightings to the score categories to give more meaning for mgmt review.
After doing some research, I read that use of multiple scales (axes) are possible with radar charts if you have the right software. (See excerpt from reading in excel attachment)
I’m attempting to create a radar chart with an axis for each category, much like the one from Figure 3 in the reading so that the weightings are identified in the chart and so that the weightings are not disfiguring the chart itself.
Does anyone know if this is possible to do only through Excel 2016, or if I need an additional add-in or extension software to make this possible?
If you do know how to add extra axes to a radar chart, please share.
Re: Adding Secondary Axes to Radar Charts
The only way to create that type of chart is to draw it yourself using xy-scatter.
That means calculating and rescaling all the data points along with some trig formula to get the correct xy positions. Finally you would need to use custom data labels in order to build each axis