excel散点图的制作步骤如下:
操作环境:联想拯救者Y7000、windows10、WPS Office11.1.0.11294等。
1、选中数据区域,先用鼠标,选中A1:B7单元格区域。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7af40ad162d9f2d3554a0377bbec8a136227ccca?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/e850352ac65c10386e25e95aa0119313b17e89ca?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/838ba61ea8d3fd1fce5285a2224e251f94ca5fca?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/34fae6cd7b899e51ced51d8c50a7d933c9950dca?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、切换至【图表工具】选项卡,选择合适的图表样式:【样式6】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/562c11dfa9ec8a1365407078e503918fa1ecc0cb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、最后,调整:合适的字体大小;单击【数据标签】,并右击鼠标选择【字体】,选择12号、加粗即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3119313b07eca80265f1e7f832397dda04483cb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)