1以y=1/(1+x)为例,新建一个Excel文件。打开,找到其中的一个列,比如A列,在第一单元格中输入变量值,如A1中输入x。在A2~A10单元格中输入变量的取值1,2,3,4……10。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/caef76094b36acaf4e4aac8f7bd98d1001e99c1e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2在后一列,B1中输入因变量y。然后在B列B2~B10与A列对应的单元格中输入分别输入=1/(1+0),=1/(1+1)……=1/(1+10)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3b87e950352ac65c593c4300fcf2b21193138a83?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3然后按住shift键或者使用ctrl键选取这两列,找到插入->散点图,选择下面的所有图表类型,打开。找到xy散点图确定。Excel就会生成上面的图了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8773912b31bb0510b1c965b317adab44aede08d?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/48540923dd54564e1e5fc14ab4de9c82d1584f8e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)