1、首先打开EXCEL2010,调整下单元格的大小。鼠标选中行标,然后点击鼠标右键,选择行高命令,设置数值为6.9 。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/fc1f4134970a304e9e8479addec8a786c8175cc7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后选择列标题,鼠标右键选择列宽命令,设置数值为0.7左右,使单元格呈现小正方形。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/34fae6cd7b899e51e528e3434da7d933c9950dc7?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/6c224f4a20a4462336d07d359722720e0cf3d74b?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/6a63f6246b600c33c9d8079f154c510fd8f9a1c0?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/14ce36d3d539b6005a6fd6e0e650352ac75cb7c0?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/9825bc315c6034a8fef860d6c41349540923764b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)