如何在excel中将两个柱子并成一个柱子?
发布网友
发布时间：2024-09-30 07:16
共1个回答
热心网友
时间：2024-10-18 10:11
我们需要准备的材料分别是：电脑、Excel表格。
1、首先我们打开需要编辑的Excel表格，点击要设置的柱状图。
/iknow-pic.cdn.bcebos.com/fc1f4134970a304e4633d04adfc8a786c9175c68"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/fc1f4134970a304e4633d04adfc8a786c9175c68?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/fc1f4134970a304e4633d04adfc8a786c9175c68"/>
2、然后我们右键单击圆柱，选择打开“设置数据系列格式”。
/iknow-pic.cdn.bcebos.com/cc11728b4710b912bddf864ecdfdfc0392452267"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/cc11728b4710b912bddf864ecdfdfc0392452267?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/cc11728b4710b912bddf864ecdfdfc0392452267"/>
3、然后我们在弹出来的窗口中点击“分类间距”下面的拖动按钮，拉到无间距即可。
/iknow-pic.cdn.bcebos.com/279759ee3d6d55fb509e069663224f4a20a4dd22"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/279759ee3d6d55fb509e069663224f4a20a4dd22?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/279759ee3d6d55fb509e069663224f4a20a4dd22"/>
