将excel图表中曲线交点的坐标标示出来的方法具体如下:
1. 打开Excel表格,选中需要插入图表的数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b7fd5266d0160924d6d1c4b4da0735fae7cd34ac?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/e4dde71190ef76c68ab79e849316fdfaaf516733?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3.进入插表页面后,点击XY(散光图)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/35a85edf8db1cb13743c5dbcd354564e93584bc3?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/4bed2e738bd4b31c3006ec1489d6277f9e2ff863?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5.然后我们就看到Excel表格中出现两个序列的图表。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0d338744ebf81a4cbbd98d66d92a6059242da6b2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6.点击该图表,然后在图表右侧出现五个选项,点击第一个选项添加元素,并选择快速布局下面的布局7.
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b812c8fcc3cec3fd9444c7dad888d43f87942722?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7.然后我们就看到图表中出现所有点的坐标,包括两条曲线的交点坐标(3,30)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/810a19d8bc3eb1357850d714a81ea8d3fc1f448d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)