绘制钻孔柱状图是凿井工作中的一项重要内容。传统手工绘制柱状图费时、费力、容易出错,使用商业绘图软件往往需要大量的软件授权费。文章探讨利用Excel-VBA编制程序,将在Microsoft Excel中输入的凿井地质数据快速生成深水井柱状图,在提高绘制钻孔柱状图效率的同时节省大量财力。 Drawing Drilling Histograms is an important part of a sinking job. Traditional hand-drawn histograms are time-consuming, labor-intensive, error-prone, and often require significant software licensing fees for using commercial mapping software. This article explores the use of Excel-VBA programming to quickly generate deepwater well histograms of sinkhole geological data entered in Microsoft Excel, saving a lot of money while increasing the efficiency of drawing a borehole histogram.