How to Make a Radar Chart in Excel

This Excel tutorial guides you through the process of inserting and formatting a Radar Chart, also known as a Spider Chart or Web Chart.

Your data might resemble a simple sales table, containing categories such as phones, online, email, office, and shop.


Inserting a Spider Chart

Select all the data cells. In this example, we’ll choose cells from A3 to E8.

marked data

Find and click on the radar chart symbol. Then, choose one of the radar chart types that suits your data.

ribbon insert radar chart

Our Radar Chart:

radar chart example

How to read a Spider Chart?

A Radar Chart differs from regular Excel charts, so it’s crucial to understand how to interpret a spider chart.

  • each corner of the spider chart represents different category of sells
  • webs (lines) represent weekly values
  • the further from the center of the chart the higher sales

Creating Radar Charts in VBA

Radar charts in Excel can be customized and created dynamically using VBA, providing you with powerful tools for data visualization.

Below is a sample VBA code that demonstrates how to create a radar chart based on data in Excel:

Sub CreateRadarChart()
    Dim Chart As ChartObject
    Dim DataRange As Range
    Dim ChartRange As Range
    Dim RadarChart As ChartObject

    ' Define the data range
    Set DataRange = ThisWorkbook.Sheets("Sheet1").Range("A1:E6") ' Adjust the sheet and range as needed

    ' Create a radar chart
    Set RadarChart = ThisWorkbook.Sheets("Sheet1").ChartObjects.Add(Left:=100, Width:=375, Top:=75, Height:=225) ' Adjust the position and size

    ' Set the data range for the radar chart
    Set ChartRange = DataRange

    ' Create the radar chart
    ActiveSheet.Shapes.AddChart2(251, xlRadarMarkers).Select
    Set Chart = ActiveChart.Parent
    Chart.Top = RadarChart.Top
    Chart.Left = RadarChart.Left
    Chart.Width = RadarChart.Width
    Chart.Height = RadarChart.Height

    ' Format the radar chart as needed
    With ActiveChart
        .ChartTitle.Text = "Radar Chart Example"
        ' Add other formatting options here
    End With
End Sub

This code will create a radar chart on your Excel sheet based on the specified data range. You can modify the code to fit your specific data and formatting requirements.

See also  How to make 3 axis graph

With VBA, you have the flexibility to create radar charts dynamically, automate chart generation, and make your data visualization tasks more efficient and customized to your needs.

Advantages of Radar Chart

There are a few exceptional advantages of radar charts which you may concider during the data type choise for your data:

  • radar chart is excellent to compare two different webs of values (eg. features of two different products)
  • can show many information for 2-4 different categories and still remain informative
  • this is very well chart to make the decision between two-four different set of values

An Example: I used to play managerial computer games and remember using radar charts to decide which football player to buy. In this scenario, the green web appears much better. His Defending, Speed, Vision, and Attacking skills surpass those in the blue web. You might only consider the skills of the blue footballer if you need Aerial skills or for other factors not visible in the chart (e.g., price, age, etc.).sprider chart footballer skills

Similarly, when comparing products for advertising, companies for mergers, or employees for promotion using a Spider Chart, these advantages can help you make informed decisions.