The invention relates to an Excel-based method for drawing an oblique
rose diagram of a geologic body and geologic elements. An Excel template file for drawing the oblique
rose diagram is created by using Microsoft Excel2010
software. According to the technical scheme, the method comprises the steps of 1, making an Excel form: inputting
original data of measured inclination of the geologic body into the form;
processing the
original data, performing grouping statistics on an inclination direction and an inclination angle, and converting the inclination direction and the inclination angle into
azimuth angle coordinates; and describing an
azimuth angle coordinate
system and calculating circle coordinates and
azimuth angle scale line coordinates; and 2, drawing the oblique
rose diagram: drawing the oblique rose diagram in the form of a scatter diagram by the circle coordinates, the azimuth angle scale line coordinates and the coordinates of the inclination direction and the inclination angle, obtained by
processing. The method has the advantages that data statistics and
processing can be automatically carried out and the diagram can be formed only by inputting the
original data; and the method is simple, easy to operate, flexible, high in adaptability, large in data volume, high in accuracy and attractive in maps or drawings, so that the drawing time of the oblique rose diagram is greatly shortened and the working efficiency is improved.