1.当前表为类别1的前半部分和类别2的后半部分生成数据。所选数据如图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/83025aafa40f4bfba12e2328134f78f0f63618cb?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/43a7d933c895d143fe88595f63f082025baf07cb?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/0eb30f2442a7d9339956590fbd4bd11372f001cb?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/ac4bd11373f082020d6c2c435bfbfbedaa641bcb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4.我们想要的是把1月到6月的数据叠加在一个列上。在图像的空白区域,右击选择data。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c995d143ad4bd11326330a4e4aafa40f4afb05cb?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/e7cd7b899e510fb341e7caebc933c895d0430ccb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6.单击:切换行/列。您可以看到数据行和列是可互换的。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0e2442a7d933c89583802507c11373f0830200cb?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/d043ad4bd11373f0d4c1d2e3b40f4bfbfaed04cb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)