1、输入要做图表的数据，
2、建立格拉图框架设计，我们设置为36个维度，也就是将一个圆形设置为36个每个10度
3、将部门的数据折合为总数36个的占比，就是生产部几个格子，质量部几个格子
4、建立图表区域，36行，列为数据类型
5、将图表区首列设置为空，而后输入公式
共36行：B2生产部公式：=IF(($K$9-ROW(A1))>-1,$K$4,"")
C2质量部公式=IF(AND((COUNTIF($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、最终效果
