1、首先,打开目标EXCEL表格,显示需要操作的数据,我们先来建立一个柱状图,选择单元格数据,点击插入图表。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b17eca8065380cd751e80c3aaf44ad3458828177?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/63d0f703918fa0ec8df8cdda289759ee3d6ddb2e?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/bf096b63f6246b6093c01ca3e5f81a4c500fa21f?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/7af40ad162d9f2d32a9a8a38a7ec8a136227cc5a?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/faf2b2119313b07e774bfedf02d7912396dd8c77?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)