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.
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.
- 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).
- 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.
- 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.
- Secondly, increase the font size to your satisfaction.
- Then, we can easily see the second variable’s Axis Labels.
- Thirdly, double-click on it.
- 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.
- Our steps will yield a result similar to this.
- 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.
Read More: Color Rings on Radar Chart in Excel (4 Suitable Examples)
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.
- 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 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.
- So, our code will execute and it will create a Radar Chart with different scales.
- Finally, we can enlarge the graph to make it better.
Read More: What Is a Radar Chart in Excel? (with Chart Types & Formation)
Practice Section
We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.
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!