How to Make a Radar Chart in Excel (2 Easy Methods)

If you want to make a Radar chart in Excel, this article is for you. Here, we will demonstrate to you 2 methods to make the Radar chart effortlessly.

Download Practice Workbook


What Is a Radar Chart?

A Radar chart, also known as a “Spider chart” or “Polar chart” helps to compare the data of 3 or more than 3 variables correlative to a lead point. It is very much effective at the time of a direct comparison of the variables and is great for visualizing data. It also points out and shows the strength and weaknesses of the values. In Excel, you will get 3 varieties of Radar charts, these are a normal Radar, a Radar with Markers, and a Filled Radar chart.


2 Methods to Make Radar Chart in Excel

The following table has Month, Shop 1, Shop 2, and Profit columns. Using this table, we will make Radar chart in Excel. To do so, we will go through 2 easy methods. Here, we used Excel 365. You can use any available Excel version.

How to Make a Radar Chart in Excel


1. Using Radar Chart Feature to Make a Radar Chart in Excel

In this method, we want to make a Radar chart with markers. To do so, we will select data to make a Radar chart and after that, we will format the chart to make it more presentable.

Step-1: Inserting Radar Chart with Markers

Here, we will insert a Radar chart after selecting data from a table.

  • First of all, we will select the entire data table.
  • After that, we will go to the Insert tab.
  • Then, click on Insert Waterfall, Funnel, Stock, Surface, or Radar chart group, which is marked with a Red color box.
  • Next, from the Radar chart group >> select Radar with Markers, which is marked with a Red color box.

At this point, you can see the Radar chart with markers.

How to Make a Radar Chart in Excel

Step-2: Formatting Radar Chart with Markers

In this step, we will format and customize our Radar chart with markers.

  • First, we will click on the Chart Title and will edit the title.

  • Moreover, we will click on the chart >> go to the Chart Design tab.
  • Along with that, we will select a Chart Design.

Here, you can select a Chart Design according to your preference.

Therefore, you can see the Radar chart with Chart Design.

Now, we want to change the color of the series of the Radar Chart.

  • To do so, we click on the first line series, which is the series for Shop 2.
  • Afterward, we go to the Format tab.
  • Then, select the Shape Styles option.
  • Next, from Shape Outline >> we selected a color.

Here, you can choose any color according to your preference.

How to Make a Radar Chart in Excel

  • In a similar way, we changed the series color for Profit.

Finally, you can see the complete Radar chart.


2. Using Select Data Option to Make a Filled Radar Chart in Excel

In this method, we want to make a Filled Radar chart. Along with that, in the chart, we want to see only the Month and Profit column. To do so, we will first insert a Filled Radar chart, and after that, we will select the Data range for the Chart.

Step-1: Inserting Filled Radar Chart

  • First, go to the Insert tab.
  • After that, click on Insert Waterfall, Funnel, Stock, Surface, or Radar chart group, which is marked with a Red color box.
  • Next, from the Radar chart group >> select Filled Radar chart, which is marked with a Red color box.

How to Make a Radar Chart in Excel

  • Later, you will see a chart box has been created.
  • At this point, we will right-click on the chart box.
  • Afterward, we will click on Select Data from the Context Menu.

A Select Data Source dialog box will appear.

  • After that, we will click on Add to add the Month column’s data.

Next, an Edit Series dialog box will appear.

  • Afterward, we will select cell B4 as the Series name.
  • Along with that,  in the Series values box, we will select from cells B5 to B9.
  • Then, click OK.

How to Make a Radar Chart in Excel

Now, in the Select Data Source dialog box, you can see under the Edit box, the number is showing instead of the Month name.

  • Later,  to add the Month name to the Radar chart, we will click on the Edit box.

An Axis Labels dialog box will appear.

  • Next, in the Axis labels range box select from cells B5 to B9. This will add the Month name to the Radar chart.
  • Afterward, click OK.

  • After that, you can see the Month under the Legend Entries (Series), along with that, you can see the Month name under the Edit box.
  • Then, we will click on Add to add the Profit column’s data.

How to Make a Radar Chart in Excel

An Edit Series dialog box will appear.

  • Afterward, we will select cell E4 as the Series name.
  • Along with that,  in the Series values box, we will select from cells E5 to E9.
  • Then, click OK.

Therefore, you can see the Month and Profit under the Legend Entries (Series).

  • Next, click OK.

As a result, you can see the Filled Radar chart representing the Profit and Month columns.

Step-2: Formatting Filled Radar Chart

In this step, we will format and customize our Filled Radar chart to make it more presentable.

  • To do so, we followed Step-2 of Method-1.

Finally, we can see the Filled Radar chart.

How to Make a Radar Chart in Excel


Practice Section

You can download the above Excel file to practice the explained methods.


Conclusion

Here, we tried to show you 2 methods to make a Radar chart in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below. Please visit our website Exceldemy to explore more.

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo