1. 首先将甲组的平均数、标准差数据输入在excel中,或者可以直接从原始数据计算得出。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/86d6277f9e2f070808daede9ef24b899a801f278?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2. 用鼠标左键将系列甲和平均数的数据选中,如下图所示。然后选择插入二维柱形图,即可得到甲乙组的平均数柱形图。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b90e7bec54e736d1a7344ae19d504fc2d5626930?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3. 然后准备添加标准差的数据,首先用鼠标双击柱形图,柱形图为被选中状态。然后选择添加图标元素—>误差线—>其他误差线选择。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9c16fdfaaf51f3de2d6a7e8d92eef01f3b29797b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4. 出现如下对话框,首先先择‘正负偏差’,然后误差量选择‘自定义’,点击‘指定值’。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a50f4bfbfbedab64f8528b29f136afc379311e33?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5. 在选择指定值的‘正、负值’时均选择标准差即图片中的‘6.5’。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c8ea15ce36d3d539d75ec92a3c87e950342ab0fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6.最后点击‘确定’。得到包含平均数、标准差的柱形图。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9345d688d43f8794739d8ec7d41b0ef41ad53afd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)