Excel中把条形和折线图放在一张表上,通过复制数据列,单独更改其中一列为折线图即可实现。
方法步骤如下:
1、打开需要操作的EXCEL表格,选中相关数据单元格,通过Ctrl+C复制,并在旁边空白列中通过“Ctrl+V”粘贴。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8014c086e061d95bed85c7375f40ad163d9cadb?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/dbb44aed2e738bd416b1d97aaf8b87d6267ff9ed?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/80cb39dbb6fd5266a0c6575fa518972bd507368f?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/0b55b319ebc4b745d3a4dd5dc1fc1e178a82154c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、返回EXCEL表格,发现在EXCEL表格上,成功把条形和折线图放在一张表上。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1e30e924b899a901fdf4307d13950a7b0308f5bc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)