当前位置：网站首页>Data visualization: use Excel to make radar chart

Data visualization: use Excel to make radar chart

2022-04-23 09:00:00 【iuhsihsow】

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

Insert picture description here

Chart effect

Insert picture description here

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 】
Insert picture description here
After mapping , choice 【 style 】 It can be configured
Insert picture description here
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 ）

版权声明
本文为[iuhsihsow]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230729536858.html

边栏推荐

猜你喜欢

随机推荐