EXCEL如何插入南丁玫瑰格拉图怎么制作图表设置

1、输入要做图表的数据，

2、建立格拉图框架设计，我们设置为36个维度，也就是将一个圆形设置为36个每个10度

3、将部门的数据折合为总数36个的占比，就是生产部几个格子，质量部几个格子

4、建立图表区域，36行，列为数据类型

5、将图表区首列设置为空，而后输入公式共36行：B2生产部公式：=IF(($K$9颍骈城茇-ROW(A1))>-1,$K$4,"")C2质量部公式=IF(AND((COUNT朐袁噙岿IF($B$2:$B$37,">0")-1-ROW(A1))<1,(COUNTIF($B$2:$B$37,">0")-1-ROW(A1))>(-1-$L$9)),$L$4,"")D2销售部公式=IF(AND((COUNTIF($B$2:$C$37,">0")-1-ROW(A1))<2,(COUNTIF($B$2:$C$37,">0")-1-ROW(A1))>(0-$M$9)),$M$4,"")E2品质部公式=IF(AND((COUNTIF($B$2:$C$37,">0")-1-ROW(A1))<2,(COUNTIF($B$2:$C$37,">0")-1-ROW(A1))>(0-$M$9)),$M$4,"")5，F2采购部公式=IF(AND((COUNTIF($B$2:$E$37,">0")-1-ROW(A1))<4,(COUNTIF($B$2:$E$37,">0")-1-ROW(A1))>(2-$O$9)),$O$4,"")G2后勤部公式=IF(AND((COUNTIF($B$2:$F$37,">0")-1-ROW(A1))<5,(COUNTIF($B$2:$F$37,">0")-1-ROW(A1))>(3-$P$9)),$P$4,"")H2=IF(AND((COUNTIF($B$2:$G$37,">0")-1-ROW(A1))<6,(COUNTIF($B$2:$G$37,">0")-1-ROW(A1))>(4-$Q$9)),$Q$4,"")I2食堂公式=IF(AND((COUNTIF($B$2:$H$37,">0")-1-ROW(A1))<7,(COUNTIF($B$2:$H$37,">0")-1-ROW(A1))>(5-$R$9)),$R$4,"")而后公式全部下拉到37行，

6、将B37设置为何B2一样的值

7、选择A2：J37，插图雷达图，带填充雷达图

8、最终效果