因为图表来源表格源数据,源数据如何,生成的图表排序就如何。解决方法如下:
1、打开excel表格,选中学号及总分两列数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/241f95cad1c8a786f5aa11727709c93d71cf50cd?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/a5c27d1ed21b0ef44d68c322cdc451da80cb3ecd?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/7a899e510fb30f242b1ab77fd895d143ac4b03cd?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/f636afc379310a55cfa48588a74543a9832610cd?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/cefc1e178a82b901cf2d984f638da9773812efce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、最后在"图表向导"选项卡中设置,选择作为其中的对象插入:Sheet1,然后点击"完成"。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/060828381f30e9242524c74d5c086e061c95f7ce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、图标设置就完成了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0bd162d9f2d3572cb862c7a09a13632763d0c3ce?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)