找三个相邻单元格,输入下列公式,统计大于5%、大于10%、大于15%的数据个数。=COUNTIF(A$1:A$100,">0.05")-COUNTIF(A$1:A$100,">0.10")=COUNTIF(A$1:A$100,">0.10")-COUNTIF(A$1:A$100,">0.15")=COUNTIF(A$1:A$100,">0.15")之后用图表向导,为这几个统计数据做饼形图。