1、首先我们需要打开一个空白的EXCEL表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b21bb051f8198618a45bb1a145ed2e738bd4e6f3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、需要将温度数据统计进EXCEL表格,当然很多温度测量仪器是不需要我们自己输入数据,会自动保存数据并自动保存为EXCEL格式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8d5494eef01f3a2931c48beb9625bc315c607c82?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/1f178a82b9014a907df21998a6773912b21beec3?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/72f082025aafa40f3cd190f8a464034f78f019fb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、这时会弹出图表向导,你需要点选标准类型,折线图,同时选择子图表类型。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f7246b600c3387443bb271595e0fd9f9d72aa0a4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、温度曲线图出来了,这时你要是对曲线不满意,认为温度值太空旷。可以双击左侧温度值,会弹出坐标轴格式,你可以点选刻度,再在里面的最小值,最大值进行更改,必如最小值改为20。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f603918fa0ec08fae7464d8256ee3d6d55fbda55?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)