Blog of Calc LLC

Suppose there are 5 academic subjects in a class which are English, math, science, music and art. You have the scores of Alice and Bob like below. You can use radar chart to compare their academic performance. The data is below. 1. Select the data. Click Insert > Charts . It automatically generates a bubble chart. Ignore it. Under Chart type , scroll down and select Radar chart. 2. Now you see a radar chart. However, the chart reading starts from 0, which makes the difference between Alice and Bob not big enough. Next, we make the chart reading starting from 50. We need to adjust the vertical axis.  3. Right click the chart, click Axis > Vertical axi s. 4. Set the Min of vertical axis to 50.  5. Now the difference between Alice and Bob looks bigger. Alice is blue and Bob is red. It can be easily seen that Alice is better in English and Music, while Bob is better in Math and Science. Their art scores are almost same.

Radar chart is typically used to display values relative to a center point. For example, suppose we have score of 5 subjects of two students. We can plot a radar chart to show their academic performance. 1. Select the data. Then click Insert > Charts > Other Charts > Radar . We select Radar chart with markers . 2. Now you see a radar chart. Alice is blue and Bob is orange on the chart. It is easy to tell that Alice is better in math and science, while Bob is better in reading and writing. Their art scores are very close.