1、首先打开excel文档,输入要展示的数据信息。
![](https://iknow-pic.cdn.bcebos.com/738b4710b912c8fcb5a38795f3039245d6882111?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选中要展示的数据区域内容,然后点击工具栏上的插入按钮,点击“柱形图”按钮。
![](https://iknow-pic.cdn.bcebos.com/279759ee3d6d55fb5092077e62224f4a20a4dd16?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后在展示出来的柱形图上,选择一个柱形图,进行添加。
![](https://iknow-pic.cdn.bcebos.com/72f082025aafa40fd5d8bf85a464034f78f0194f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后右键点击红色图案区域,图中以“净利润同比增长率”为例,在弹出的菜单选项中点击“设置数据系列格式”.
![](https://iknow-pic.cdn.bcebos.com/7e3e6709c93d70cf57e3db55f7dcd100baa12b48?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在弹出的界面中,选中次坐标轴选项。
![](https://iknow-pic.cdn.bcebos.com/91529822720e0cf33aee3fa30546f21fbe09aa49?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、右键点击图中红色区域,在弹出的菜单中,点击“更改系列图表类型”选项,然后在展示的图表中,点击折线图,然后选择一个折线图样式,然后点击确定。
![](https://iknow-pic.cdn.bcebos.com/2e2eb9389b504fc2e747c15deadde71190ef6d49?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、就能得到效果图了,当然在每个图上右键点击,在菜单中选择“添加数据标签”选项,可以添加标签信息。
![](https://iknow-pic.cdn.bcebos.com/50da81cb39dbb6fdda43947e0624ab18972b3749?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)