Radar Chart in Excel – Components, Insertion, Formatting

A radar chart in Excel is also known by the name of Spider Chart or a Web Chart. This chart is quite useful in representing a two-dimensional form of data. Let us see how it works.

What is a Radar Chart in Excel?

A Radar Chart in Excel contains lines that are joined to form a web of a spider. The following are the components of a Radar Chart.

  • X Axis – It represents the Categories. The axis is at the perimeter boundary of the web.
  • Y Axis – It is the scale for representing the data series. It is formed by joining the inner points that form the web.
  • Data Series – The Data Series is in the form of Cobweb.
components of a radar chart in excel

The highlighted lines in Blue color at the outer side of the web are the Category Axis and the Purple Boxes containing years are the Category Axis Labels.

The Orange arrow from the center of the web to its outline is the Y-Axis and the Numerical Values on it are the Vertical Axis Labels.

From the above chart, we can infer that sales of 2022 are the highest since the data point is closest to the border of the web. The sales are minimum for 2023 since the data point is closest to the center of the web.

The lines forming this web are the gridlines. So in case, if we remove the Gridlines, the chart looks like:-

radar chart in excel without the gridlines

Example 1 – Inserting a Radar Chart with One Data Series

We will start learning the usage of this chart by plotting only one data series. Let us say here we have the sales data of three regions of the country as follows:-

inserting a radar chart source data

To insert the Radar Chart from this Data:-

  • Select the range of cells A1:B4.
  • Click on Recommended Charts button in the Charts Group of Insert tab on ribbon.
  • Select the Radar Chart from the list and choose the first radar chart type.
inserting a radar chart step 2

Consequently, this will insert the chart as shown in the preview of the Insert Chart dialog box. We can change the chart style from the chart options at the top right corner of the chart.

changing the chart style of a radar chart in excel
infographics Radar Chart in Excel

Example 2 – Radar Chart in Excel with 2D Data

By two-dimensional data, we mean that there are multiple Data Series as well as Data Categories. Let us consider we have the Quarterly Sales of a company for ten years.

inserting a Radar Chart in Excel with multiple data series and categories

We can insert the chart from this range A1:E12 by using the steps mentioned in Example 1 as follows:-

radar chart in excel insertion result

Cleaning the Radar Chart

We can remove some of the chart elements so that this web could expand itself in the same area. To do so, select the chart and from the + icon at the top right corner of the chart, unmark the Chart Title and Legends for now.

cleaning the radar chart to make it easy to read

Changing the Scale of Vertical Axis

As you can see that the Vertical Axis now starts from zero and the maximum value it can represent is 100000 which is automatic. The length of each interval is 20000. Increasing the Length of each interval will let us visualize the chart perfectly.

To do so:-

  • Double Click on the Vertical Axis Labels.
  • This opens the Format Axis Pane for the Vertical Axis.
  • From the Axis Options, set the Major unit to 10000.
changing the chart style of a radar chart in excel results

These major units will change the Vertical Axis Labels intervals. Now Drag the Chart corners to expand it so that the added intervals could be visible like this:-

Formatting and Adding Markers to the Data Series

There are four data series for each of the Four Quarters of the year. To format the data series, double click on any one data series on the chart. ( The first click will select the data series and the second click will open the Format Data Series pane. )

formatting the data series of the chart

From the Fill and Line tab, set the Line as Solid. Select the color of the line and you can reduce the width of the line from there. After this, navigate to the Marker tab next to the Line tab.

formatting the markers in a chart in excel

Select the Marker Type and Size. Set the Marker Fill to a shade darker than that of the solid line for this data series.

Repeat the same steps for the rest of the three data series. The resultant chart is as follows.

formatting the data series of the chart result

Formatting the Web

The web of the chart is made up of vertical axis and gridlines.

We need to add the Solid Line corresponding to the Vertical Axis and this will complete the web. To do so, double click on the axis representing the scale for years and then mark a solid line from the Fill and Line tab. Set the color.

formatting the web of radar chart in excel

Similarly, we can click on the Gridlines and match them with the color of the Vertical Axis. This formats the entire chart web as follows:-

formatting the web of radar chart in excel step 2

Changing the Chart Background

The Background of the Chart must be of a Soft Color as that increases the readability. To do so, double click on the chart and:-

Set the Solid Fill color from the Fill and Line tab. Add the legends from chart options and below are the final results.

From the chart, we can compare the sales of different quarters for each year. For example, in 2021, Sales of Q2 are maximum. The Sales of 2024 Q1 are highest since it is closest to the border of the web while the sales of Q3 for 2017 are the minimum sales.

This brings us to the end of the blog. Thank you for reading 8D

Leave a Comment