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/6a600c338744ebf8996793ecdff9d72a6159a7cb?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/e61190ef76c6a7ef0b8c5cf5fbfaaf51f2de66bf?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/8b13632762d0f703f7eb610f0efa513d2797c58c?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/5ab5c9ea15ce36d347e977e33cf33a87e850b170?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)