使用Excel图表的”误差线“选项可以制作误差棒。误差棒是以被测量的算术平均值为中点,在表示测量值大小的方向上画出的一个线段。因此,为了画出”误差棒“,还需要提供误差数据。下面以Excel 2010为例,演示误差线的绘制:
假定已经得到了测量数据及每个测量点的误差,那么根据测量数据可以绘制如下所示的散点图
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/472309f79052982244b10f3bd2ca7bcb0b46d443?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
接下来需要将测量误差显示在测量点上,选择曲线后,如图显示误差线
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3801213fb80e7bec230535192a2eb9389a506b6e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
下图同时显示了水平和竖直误差线,一般不需要水平误差线,因此选中水平误差线后,按DELETE键将其删除
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15ce78d1d0f1b3003af33a87b20e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
然后,选中垂直误差线,右击鼠标,选择”设置错误栏格式“
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cefc1e178a82b901b3bdf3cb768da9773912ef32?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
如下图指定误差
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6a63f6246b600c33b9f9ed301f4c510fd8f9a141?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
最终效果为
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d4628535e5dde711eed4700ea2efce1b9c1661c7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)