How to Create Excel Radar Chart with Different Scales

If you are looking for ways to plot an Excel Radar Chart with different scales, then this is the right article for you. You may know the Radar Chart as the Spider Chart or the Polar Chart. We can easily visualize the performance in this type of graph. This graph is ideal for two sets of variables. Moreover, we can compare forecasted and actual values in this chart. This different scales Radar Chart is also known as the dual Axis Radar Chart. We will show you 2 easy methods to make an Excel Radar Chart with different scales.


Download Practice Workbook


2 Handy Approaches to Create Excel Radar Chart with Different Scales

To demonstrate our methods, we have selected a dataset with 3 columns: “Courses”, “Students”, and “Passed”. Basically, our dataset tells the story of an educational institution, where the number of students enrolled and the percentage of students passing are shown for five subjects. Additionally, one scale will be from 80 to 100 for the “number of students enrolled” variable, and another scale will be from 30% to 70% for the percentage of the “students passed” variable. Moreover, we have shown a Radar Chart with different scales, and it will be the final output of this article.

Excel Radar Chart with Different Scales


1. Using Insert Charts Feature to Plot Excel Radar Chart with Different Scales

In this section, we will use the Insert Charts feature to bring up a basic Radar Chart. Then, we will use the plot on the Secondary Axis option for the “percentage passed” variable. After that, we will change the formatting of the graph to make the viewing experience better for the audience.

Steps:

  • At first, select the cell range B4:D9.
  • Then, from the Insert tab → Insert Waterfall, Funnel, Stock, Surface, or Radar chart group → select Radar.

Excel Radar Chart with Different Scales 2

  • So, a basic Radar Chart will pop up with 2 variables on the same scale.
  • Next, we will use a different scale for the percentage passed variable.
  • Hence, double-click on the Orange dot (i.e. the Passed variable).

Excel Radar Chart with Different Scales 3

  • After doing so, it will bring up the Format Data Series box.
  • Then, deselect Category Labels.
  • After that, from the Plot Series On option → select Secondary Axis.

Excel Radar Chart with Different Scales 4

  • Then, we will see the second variable is on a different scale in the Excel Radar Chart.
  • However, both of the Axis Labels are in the same location. This will make it hard to read. By using some tricks, we can make it look better.
  • Firstly, select the Axis Labels for the first variable.

Excel Radar Chart with Different Scales 5

  • Secondly, increase the font size to your satisfaction.
  • Then, we can easily see the second variable’s Axis Labels.
  • Thirdly, double-click on it.

Excel Radar Chart with Different Scales 6

  • Next, the Format Axis box will pop up.
  • Then, we set the Minimum Bound to 0.3. After doing so, this will automatically change the Maximum Bound and Major Unit. However, if it does not change then modify it manually.

Excel Radar Chart with Different Scales 7

  • Our steps will yield a result similar to this.

Excel Radar Chart with Different Scales 8

  • Lastly, we have added a Chart Title, changed the font colors, moved the Legend, added background colors, and resized the Radar Chart to make it easier to read.

Excel Radar Chart with Different Scales 9


2. Applying VBA to Create Excel Radar Chart with Different Scales

For the last method, we are going to apply an Excel VBA Macro to show Radar Chart with different scales.

Steps:

  • To begin with, press ALT+F11 to bring up the VBA window.
  • Alternatively, we can do it by selecting Visual Basic from the Developer tab.
  • Then, from Insert → select Module. We’ll type our code here.

Excel Radar Chart with Different Scales 10

  • Then, type the following code.
Sub Radar_Chart_Different_Scales()
    ActiveSheet.Shapes.AddChart2(317, xlRadar).Select
    With ActiveChart
        .SetSourceData Source:=Range("VBA!$B$4:$D$9")
        .FullSeriesCollection(2).AxisGroup = 2
        .ChartGroups(2).HasRadarAxisLabels = False
        .HasTitle = True
        .ChartTitle.Text = "Applying VBA"
        .Axes(xlValue, xlSecondary).MinimumScale = 0.3
        .Axes(xlValue, xlSecondary).MaximumScale = 0.7
        .Axes(xlValue).TickLabels.Font.Size = 28
        .FullSeriesCollection(2).AxisGroup = 1
        .FullSeriesCollection(2).AxisGroup = 2
        .Axes(xlValue, xlSecondary).MinimumScale = 0.3
        .Axes(xlValue).MajorUnit = 5
        .Axes(xlValue).MinimumScale = 80
    End With
End Sub

VBA Code

VBA Code Breakdown

  • First, we are calling our Sub procedure  Radar_Chart_Different_Scales.
  • Next, we insert a Chart in the Active Sheet.
  • Then, we use the VBA With statement to set the properties of the Chart.
  • Here, our data range is B4:D9, you need to change it according to your needs.
  • After that, we add a Title to the Chart.
  • Thus, this code works to create a Radar Chart with different scales.
  • Afterward, Save the Module.
  • Then, put the cursor inside the first Sub procedure and press Run.

VBA Code Run

  • So, our code will execute and it will create a Radar Chart with different scales.

VBA Code Output

  • Finally, we can enlarge the graph to make it better.

Enlarge Output


Practice Section

We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.

Practice Dataset


Conclusion

We have shown you 2 handy approaches to how to plot the Excel Radar Chart with different scales. If you face any problems regarding these methods or have any feedback for me, feel free to comment below. Moreover, you can visit our site ExcelDemy for more Excel-related articles. Thanks for reading, keep excelling!

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I am passionate about all things related to data and MS Excel is my favorite application. I want to make people's life easier by writing easy-to-follow and in-depth guides here at Exceldemy.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo