利用excel做柱状图表,并且数值从高到低排序,需要先对数据进行排序再插入柱状图表。
方法步骤如下:
1、打开相关Excel表格,选中需要排序的单元格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/37d12f2eb9389b50921b4c4f8b35e5dde6116ec3?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/9922720e0cf3d7cae117936bfc1fbe096a63a9ce?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/09fa513d269759eeb1bdccd6bcfb43166d22df3a?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/4a36acaf2edda3ccacab173d0fe93901213f9264?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/8694a4c27d1ed21b258281f8a36eddc451da3f67?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、返回Excel表格,发现已经成功插入了按数值高低排序的柱状图表,可根据需要点击上方的“图标布局”选择喜欢的布局。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a1ec08fa513d2697d375a7405bfbb2fb4316d80d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)