设置的方法如下:
1、打开一个excel表格,里面有三组数据,然后用鼠标选中所有数据:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f703738da97739123dbedb4af7198618367ae205?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/728da9773912b31b3ffa93028918367adab4e103?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/4e4a20a4462309f7529cf3397d0e0cf3d7cad62e?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/728da9773912b31b3fec93028918367adab4e11d?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/dcc451da81cb39dbe9cc3e7ddf160924ab183088?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、然后就会变成三个坐标轴了:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a686c9177f3e670980a115d434c79f3df8dc5573?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/0eb30f2442a7d933a694bd58a24bd11373f001d8?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/d788d43f8794a4c22b43be0001f41bd5ad6e39bc?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/a9d3fd1f4134970a0a2c49049acad1c8a7865db9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)