In this article, you will learn how to create a radar chart in Microsoft Excel. With a radar chart, you can quickly compare the values of three or more variables in relation to a center point. There are three types of radar charts in Excel. These include a simple radar chart, a radar chart with markers, and a radar chart with fillings. These types of charts are ideal for showing outliers and common points between variables on the same scale.
Radar charts typically compare multiple variables in a two-dimensional plane with all axes equally distributed. Here’s how to set up charts and why they’re useful.
How to Create a Radar (Radial) Chart in Excel
For this exercise, we are going to complete the radar charts using two sample data sets. The first shows and compares different aspects of two new smartphones, including the screen, the camera, the battery life and the color options. The second looks at two employees and how they differ on key skill sets such as punctuality, meeting deadlines, friendliness, and problem solving.
To get started:
- Open Excel on your computer.
- Then highlight the rows and columns that contain the data you want to use in your chart.
- Choose Insert.
- Select drop down menu Graphics.
- Lastly, scroll down to the section Others and choose the type of Radar (Radial) chart you want to use. Options are radial, radial with markers, or radial filled.
This is an example of a normal radial graph using data from a smartphone:
This is another example of a normal radial chart. Compare the ratings of two employees.
The same data as above is shown below in a radial chart with markers, and one with a filled radial, respectively:
That is all. Creating radar or radial charts in Microsoft Excel requires only a few steps.
Resize and move a chart
As with other charts in Excel, you can easily resize or move them. For example, you can drag it in or out from a corner or edge to resize a radar chart. Meanwhile, to move the chart, choose it and use the four-sided arrow to drag it to a new place on the sheet.
To move a pie chart, select it and use the four-sided arrow to drag it to its new place on the sheet.
Customize the pie chart and display its data
To make your graphic even better and unique, you can edit it to include a title, different fonts and sizes, and more. Double-click on a word in the graph and make your changes to get started. As you can see in the following examples, the chart titles and fonts are changed.