How to Create Excel Radar Chart with Different Scales

Get FREE Advanced Excel Exercises with Solutions!

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


Create Excel Radar Chart with Different Scales: 2 Handy Approaches

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

  • Finally, 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

Read More: Color Rings on Radar Chart in Excel 


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 a 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

Read More: What Is a Radar Chart in Excel? 


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


Download Practice Workbook


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.


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.
Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo