The invention relates to a method for drawing an exploratory point planar graph on the basis of the Excel. The method comprises the following steps of: 1, setting an Excel template file, i.e. setting a corresponding worksheet, wherein the worksheet at least comprises a header, a column number acquisition region, a CAD (Computer Aided Design) batch command generating region for expressing graph blocks and characters of different exploration holes, a hole coordinate input regions of the exploration holes and an element input region; 2, setting a CAD template file, including steps of setting corresponding drawing layers and defining the graph blocks and graph block names as per the elements, and programming a small program of 'numbering and coordinate extracting.dvb'; and 3, by loading the small program of 'numbering and coordinate extracting. dvb', generating a corresponding Excel table, acquiring the coordinates of exploratory points so as to obtain the worksheet, starting a CAD batch command and drawing the exploratory point planar graph. The method has the advantages that the method is simple, is easy to operate, is flexible and changeful, has strong adaptability, is convenient to carry out batch regulation and modification and has large data capacity; the time of generating the exploratory point layout plan in the investigation project is greatly shortened; and the working efficiency is improved.