第一步,先处理数据,如下
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b58f8c5494eef01fc2d9a267eefe9925bd317d47?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第二步,插入这两个形状,设置长8cm,宽0.5cm
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7a899e510fb30f24088f56a1c695d143ad4b037e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第三步,把矩形框,设置无边框,白色填充;圆角矩形,拖动小黄点,使两端变圆。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b999a9014c086e069ce89ae90c087bf40bd1cbd4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第四步,按住Ctrl选择矩形框和圆角矩形框,水平对齐和垂直对齐,然后复制粘贴为图片
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2fdda3cc7cd98d10da75a8932f3fb80e7aec90eb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a4656b92f9b6563f6246a60affd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第五步,选择粘贴后形成的图片,选择图片格式-颜色-设置透明色,然后在蓝色区域点一下。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/42166d224f4a20a4dc159b659e529822720ed00d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第六步,把第一步的数据,插入图表,辅助1是主坐标轴,条形图;辅助2和百分比是次坐标,堆积条形图。
第七步,复制第五步设置好的图片,点击辅助1的柱形图,粘贴。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9922720e0cf3d7cadb5299d4fc1fbe096a63a9e8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第八步,图表美化一下,不需要都去掉。然后使用按住Alt拖动图表,锚定在单元格内,最终效果如图
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/78310a55b319ebc4ed69d73b8c26cffc1e17167a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)