步骤1
新建一个excel文档,可以将它命名为自己想要的名称。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6c224f4a20a44623e933db1c8822720e0df3d7d7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
END
步骤2
双击打开excel文档,在表格中输入需要分析统计的数据。如某地每月旅游人数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4e4a20a4462309f77196d36c620e0cf3d6cad6d7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
END
步骤3
将自己需要统计的数据选中,点击上方的“插入——图表”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/91529822720e0cf3320e30851a46f21fbf09aad7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
END
步骤4
点击之后会出现如下图界面,根据自己的需求选择不同的图表。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/472309f79052982291ca47bdc7ca7bcb0b46d4d7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
END
步骤5
选择好之后点击“确定”,在表格中就会出现一个图表。如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/21a4462309f790527ae639401cf3d7ca7acbd5d7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
END
步骤6
通过图表右边的四个图标可以设置更改图表的标题,图例,样式,颜色等,使图表更简单明了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/08f790529822720ee8379c846bcb0a46f31fabd7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述