方法/步骤
根据数据制作好表格后面有些网格线,多个柱形图加折线图时就会感觉背景多余,那么如何去掉横线显得更加好看呢?我们接下来看下几种简便的方法。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3801213fb80e7becab2c44ee212eb9389a506bcf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
最简单的就是我们选中网格线,此图有4条网格线,右键选择删除即可。同时也可以选中后按DELETE键删除;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b812c8fcc3cec3fdb615e17ad888d43f87942791?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/d1a20cf431adcbef85c23909a2af2edda2cc9fcf?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/0d338744ebf81a4c9dedabc6d92a6059242da6e6?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/d6ca7bcb0a46f21f7aeb195cf8246b600d33aee6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
去除网格线之后背景一篇空白,在某种场景下更加的直观美观,可以应用到ppt或者word中试试看吧。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6159252dd42a2834e76a710455b5c9ea14cebff5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳