在Excel中做复杂组合图表的方法及具体操作步骤如下,以wps中的EXCEl为例做演示。
1、在wps中找到需要制作复杂组合图的Excel表格,并将其打开。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8694a4c27d1ed21b18aeb5fba26eddc451da3f4c?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/8435e5dde71190efbb8609c1c11b9d16fdfa60ab?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/ac6eddc451da81cb25f618d35d66d0160924319f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、这时就可以看到表格当中就有了由所选数据制成的复杂的组合图表,如下图所示,即完成了Excel中做复杂组合图表的全部流程。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/54fbb2fb43166d2234678e8a492309f79052d298?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳