Microsoft Excel has some built-in charts. The Radar Chart is one of them which is also known as the spider chart, polar chart, web chart, and star chart. Various types of data can be plotted, including the performance of employees, athletes, products, and companies. Throughout this article, I am going to demonstrate each and every step of creating a circular radar chart in Excel easily.
In the following image, you can see the overview to create a Circular Radar Chart in Excel. Continue reading the full article.
What Is a Radar Chart in Excel?
A radar chart also known as a spider chart is mostly used for showing anomalies or outliers in your data. It is an excellent way to visualize the comparison of more than one or two variables. Radar charts enable you to exhibit the results in a geometric shape that displays “at-a-glance” success in all areas. In addition to visualizing performance, it allows you to identify strengths and weaknesses according to their concentrations.
There are a total of 3 types of Radar charts in Excel. They are Simple Radar Charts, Radar Charts with Markers, and Filled Radar Charts. We will use a Radar Chart with Markers in this case. A Radar Chart with Markers shows values relative to a center point. It is used when categories are not directly comparable. Here is a sample image of a Radar Chart.
Create a Circular Radar Chart in Excel: 3 Easy Steps
In this section, I will show you the steps that you should follow to create a circular Radar Chart in Excel. To show this we have taken a dataset of 12 rows and 4 columns which are Year, Item 1, Item 2, and Item 3. We are going to use the Excel 365 version in this article. You can use any other available version of Excel as well. Let’s follow the below steps carefully.
Now, let’s move to the main part of this article.
Step-1: Creating Dataset to Make a Circular Radar Chart
First, I will show you how you simply create a dataset for a Circular Radar Chart in Excel.
- Create a dataset in the following format. Try to take a long-winded dataset that has several years of data. It will help to make the radar chart more circular.
- In this dataset, we have 12 rows and 4 columns of Year, Item 1, Item 2, and Item 3. These data show the total sales units of Item 1, Item 2, and Item 3 from 2010 to 2020.
Read More: How to Make a Radar Chart in Excel
Step-2: Employing Radar Chart Option
In this section, I will discuss each and every step of creating a radar chart based on our above dataset. Stay tuned and follow the below steps.
- First, go to the Insert tab.
- Then, choose Radar with Markers from Others Charts.
- As a result, a blank radar chart will be generated.
- Now, just Right-click on your mouse while selecting the chart.
- Then, go to the Select Data option.
- After clicking Select Data, a Select Data Source dialog box will appear.
- Now, click on the Add option.
- Instantly, an Edit Series dialog box will appear.
- At this point, select cell C4 which is Item 1 as a Series name, and select C5:C15 as Series values.
- Then, click OK to proceed.
- Now, for Item 2 select cell D4 as a Series name and select D5:D15 as Series values.
- Then, click OK to proceed.
- Lastly, for Item 3 select cell E4 as a Series name and select E5:E15 as Series values.
- Then, click OK to proceed.
- However, to edit Horizontal Axis Labels, click on Edit.
- As a result, an Axis Labels dialog box will appear.
- Then select the Year column (B5:B15) as the Axis label range and click OK to proceed further.
- At this point, the Select Data Source dialog box will look like this.
- Finally, click OK.
- At this stage, you will get your circular radar chart without formatting.
Step-3: Formatting Radar Chart
Now in this step, I will show how you can make your Circular Radar Chart more attractive and presentable. To do so follow the below steps.
- First, you can change the Chart Design as per your choice. To do that, go to the Chart Design tab. Select your preferred Chart Design I have selected Style 7 in this case.
- Now, it’s time to give a Chart Title to our chart. To do so, click on the chart and then click on the plus symbol which is Chart Elements.
- Then click on the arrow sign (>) beside Chart Title.
- Next, click on the Above Chart.
- Now, give a Chart Title according to your dataset. We have given “Yearly Sales Items Comparison” as a Chart Title.
- However, you can change the color of each radar line. Just Right-click on your mouse.
- Go to Outline and select your preferred color.
- In this way, you can change each line color of this radar chart.
- At this point, we have to add Legend. To do so, click on the chart and then click on the plus symbol which is Chart Elements.
- Then click on the arrow sign (>) beside Legend.
- Next, click on the Right option.
- As a result, Legend will be added on the right side of your chart.
- At this point, you can format the font size, color, and theme color as you wish. I have formatted mine at my convenience.
- Now, it’s time to edit Gridlines. You can edit Gridlines as well. To do so, click on the chart and then click on the plus symbol which is Chart Elements.
- Then click on the arrow sign (>) beside Gridlines.
- Next, click on More Options.
- After clicking More Options, you will get the Format Major Gridlines dialog box.
- Next, select the Gradient line.
- Then, close the Format Major Gridlines dialog box.
- As a result, you will have a Circular Radar Chart like below.
Read More: Color Rings on Radar Chart in Excel
You can use the following dataset to practice by yourself. Hope it will help you to learn more.
Download Practice Workbook
You can download the practice workbook from here:
So the main purpose of this article is to make you clear how to create a Circular Radar Chart in Excel in some easy steps. I hope now you can create this type of chart easily. If you have any suggestions or queries please leave a comment below.
- What Is Radar Chart in Excel
- How to Include Standard Deviation in Excel Radar Chart
- How to Create Excel Radar Chart with Different Scales
- How to Create Excel Radar Chart Max Value
- How to Create Radar Chart and Fill Area in Excel
- How to Create Pie Radar Chart in Excel
- How to Create Polar Area Chart in Excel
- How to Make a Wind Rose in Excel