Dot pitch chart automatic generation method and system

The invention provides a dot pitch chart automatic generation method and system. The dot pitch chart automatic generation method comprises the steps: setting a data storage area, a temporary area and a dot pitch chart area in an Excel page in advance; inputting the acquired data into a table based on the row and column names of the data storage area; reading data in a data storage area by using a VBA code, copying a column where the name is located and a column where the data is located in the data storage area to a temporary area, calculating equal division values based on the data, and determining the size of the equal division values in the temporary area; and based on the temporary region data, generating a dot pitch chart by using a VBA code in a manner of combining a histogram and a scatter diagram. 本公开提供了一种点距图表自动化生成方法及系统，包括：预先在Excel页面中设置数据存储区域、临时区域以及点距图表区域；基于数据存储区域的行列名称将获取的数据输入表格中；利用VBA代码读取数据存储区域的数据，将所述数据存储区域中的名称所在列和数据所在列拷贝至临时区域，并基于所述数据进行等分数值的计算，确定临时区域中等分数值的大小；基于所述临时区域数据，采用柱状图和散点图相结合的方式，利用VBA代码生成点距图表。