Abstract: In order to improve the efficiency of drawing groundwater monitoring well comprehensive histogram, a drawing tool is developed based on Excel and AutoCAD. This drawing tool is composed of three parts, namely data storage module, drawing module and drawing program. Excel is the secondary development platform and data storage module. AutoCAD is the graphics drawing module. Drawing program written by VBA language is the data processing module. Data classification input design of monitoring wells in Excel drawing workbook is helpful for structured data entry and data checking. The partition design of AutoCAD drawing template makes drawing normalization. By using this drawing tool, automatic and standardized drawing of groundwater monitoring well comprehensive histogram could be realized.