Data visualization: use Excel to make radar chart

summary

The radar chart can easily show the values of multiple dimensions , It is very convenient for multi-attribute comparison . You must have seen JoJo Are you familiar with .

Raw data

Chart effect

Operation steps

After the table is selected , choice 【 Insert 】, And then choose 【 Recommended charts 】

choice 【 All charts 】, And then in Toc Choose from 【 Radar map 】

After mapping , choice 【 style 】 It can be configured

The maximum value used in the figure is the maximum value of the coordinate axis , So for a beautiful picture , You can preprocess the data first , Treat the value as an integer interval . for example ;0,1,2,3,4,5.

（ After normalization , Multiply by the maximum you expect , And round it up ）