如何利用excel自动生成施工进度计划横道图

如题所述

1、首先将分部工程的内容和月进度报表的日期编辑好。
/iknow-pic.cdn.bcebos.com/314e251f95cad1c8217fecca713e6709c83d5112"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/314e251f95cad1c8217fecca713e6709c83d5112?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/314e251f95cad1c8217fecca713e6709c83d5112"/>
2、完成后整体加入格子,并将全部文字居中排版。
/iknow-pic.cdn.bcebos.com/d439b6003af33a87c00b13f7c85c10385243b5fc"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d439b6003af33a87c00b13f7c85c10385243b5fc?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/d439b6003af33a87c00b13f7c85c10385243b5fc"/>

3、侧面长按鼠标框选需要调整的区域,设置行高,上部框选区域设置列宽。
/iknow-pic.cdn.bcebos.com/b58f8c5494eef01f5b720b28eefe9925bd317dfc"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b58f8c5494eef01f5b720b28eefe9925bd317dfc?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/b58f8c5494eef01f5b720b28eefe9925bd317dfc"/>

4、将日期和分部工程的文字分别排版在右侧和左侧,然后插入直线形状,中间交叉分隔。
/iknow-pic.cdn.bcebos.com/f3d3572c11dfa9ec7ff745fa6cd0f703908fc106"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f3d3572c11dfa9ec7ff745fa6cd0f703908fc106?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/f3d3572c11dfa9ec7ff745fa6cd0f703908fc106"/>

5、全部内容完成后,预览页面,将页面设置成横向,将排版布满整张纸。
/iknow-pic.cdn.bcebos.com/9a504fc2d5628535b63cc1cc9eef76c6a6ef637a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/9a504fc2d5628535b63cc1cc9eef76c6a6ef637a?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/9a504fc2d5628535b63cc1cc9eef76c6a6ef637a"/>
6、开始插入直线形状,作为进度线条。
/iknow-pic.cdn.bcebos.com/0eb30f2442a7d9337e6ff49ea34bd11372f00113"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0eb30f2442a7d9337e6ff49ea34bd11372f00113?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/0eb30f2442a7d9337e6ff49ea34bd11372f00113"/>
7、选中了插入的线条会跳出绘图工具,将线条轮廓设置成6磅。
/iknow-pic.cdn.bcebos.com/dbb44aed2e738bd46de6a2dcaf8b87d6267ff91c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/dbb44aed2e738bd46de6a2dcaf8b87d6267ff91c?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/dbb44aed2e738bd46de6a2dcaf8b87d6267ff91c"/>
8、添加全部进度条,就完成横道图。

/iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef4bb9e8bb3d3c451da80cb3eec"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef4bb9e8bb3d3c451da80cb3eec?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/a5c27d1ed21b0ef4bb9e8bb3d3c451da80cb3eec"/>
温馨提示:答案为网友推荐,仅供参考
相似回答