1、打开excel,输入图表的源数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9dcd100baa1cd112c561f3db612c8fcc2ce2dce?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/72f082025aafa40fc2bea2c0a464034f78f019b6?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/77094b36acaf2eddaca325f4821001e939019358?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/bf096b63f6246b60ec5bde69e4f81a4c510fa252?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/6c224f4a20a44623da92c97f9722720e0cf3d757?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、然后选择“系列”下方的“分类(X)轴标志”,点击右边的按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ca1349540923dd546c56cb75de09b3de9c824881?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、在弹出的页面中选择第一列数据,点击红框中的按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7a899e510fb30f243cc0831ec795d143ad4b0350?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、这时回到源数据页面,点击“下一步”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/203fb80e7bec54e721577503b6389b504fc26a77?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
9、这时可以根据自己的需要设置“标题”、“坐标轴”、“数据标志”等数据,设置好点击“完成”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6609c93d70cf3bc7c71ca1f1de00baa1cd112a8a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
10、这样excel中的折线图就做好了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/35a85edf8db1cb137f3e530ed254564e92584b53?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)