How to Create a Circular Radar Chart in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

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.

overview picture of a circular radar chart in excel


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.

Sample image of a circular radar chart in excel


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.

making dataset to create a radar chart in excel

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.

selecting radar with markers

  • As a result, a blank radar chart will be generated.

created blank radar chart in excel

  • Now, just Right-click on your mouse while selecting the chart.
  • Then, go to the Select Data option.

selecting select data option to create a radar chart in excel

  • After clicking Select Data, a Select Data Source dialog box will appear.
  • Now, click on the Add option.

clicking add option to insert values

  • Instantly, an Edit Series dialog box will appear.

generating edit series dialog box

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

selecting radar chart values

  • Now, for Item 2 select cell D4 as a Series name and select D5:D15 as Series values.
  • Then, click OK to proceed.

selecting values for radar chart in excel

  • Lastly, for Item 3 select cell E4 as a Series name and select E5:E15 as Series values.
  • Then, click OK to proceed.

selecting values to create radar chart in excel

  • However, to edit Horizontal Axis Labels, click on Edit.

editing horizontal axis labels

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

editing axis label range to create radar chart in excel

  • At this point, the Select Data Source dialog box will look like this.
  • Finally, click OK.

editing select data source dialog box

  • At this stage, you will get your circular radar chart without formatting.

circular radar chart in excel without formatting

Read More: How to Create Radar Chart with Radial Lines in Excel


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.

editing radar chart design in excel

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

inserting chart title to make circular radar chart representable

  • Now, give a Chart Title according to your dataset. We have given “Yearly Sales Items Comparison” as a Chart Title.

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

editing color of radar radar line

  • In this way, you can change each line color of this radar chart.

changing color of radar chart line

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

adding legend to the right

  • As a result, Legend will be added on the right side of your chart.

legend added in the circular radar chart

  • At this point, you can format the font size, color, and theme color as you wish. I have formatted mine at my convenience.

formatting font size, color of circular radar chart in excel

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

Adding Gridlines

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

editing format major gridlines dialog box

  • As a result, you will have a Circular Radar Chart like below.

circular radar chart with gridlines in excel

Read More: Color Rings on Radar Chart in Excel


Practice Section

You can use the following dataset to practice by yourself. Hope it will help you to learn more.

dataset for creating radar chart in excel


Download Practice Workbook

You can download the practice workbook from here:


Conclusion

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.


Related Articles


<< Go Back To Excel Radar ChartExcel ChartsLearn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Nujat Tasnim
Nujat Tasnim

Nujat Tasnim, BSc in Computer Science and Engineering from American International University-Bangladesh, has a year-long tenure with ExcelDemy. Initially a Content Developer at SOFTEKO, she transitioned to the Software Team as Junior Software Quality Assurance Engineer. Currently serving as a Junior SQA Engineer at SOFTEKO, she excels in SDLC, STLC, and requirement analysis and possesses profound insights into OOP-related software development processes. Nujat is also proficient in design software like Photoshop and Illustrator, contributing diverse skills to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo