1、打开电脑,然后点击打开excel软件,在页面上方中选中数据,然后点击插入,选择条形图,选二维条形图中的第一个簇状条形图;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/08f790529822720eacc5464b75cb0a46f21fab7c?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/a8ec8a13632762d07a6f000eaeec08fa513dc62a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在excel软件上方的菜单栏中找到数据图选项,点击数据图选项,然后选择并点击添加数据标签选项;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef42ea23cefd3c451da81cb3e3c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、删除掉背景网格线,系列标识、X轴,然后将纵轴的刻度线设置为无,将颜色也设置为无,点击关闭;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9358d109b3de9c82d9285d3e6281800a19d84335?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/35a85edf8db1cb13492698a2d354564e92584b37?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)