VBA-based matrix chart generation method and system

The invention provides a VBA-based matrix chart generation method which comprises the following steps: obtaining to-be-processed data, and respectively setting a data storage area and a matrix chart area in an Excel page; inputting the acquired data into a table according to the row and column attributes of the data storage area; reading data in the table by using the VBA code, and calculating a related attribute value of a matrix chart position corresponding to each cell data in the table; inserting a VBA related code for calculating the related attribute value into a corresponding position of the matrix chart area; and obtaining a generated matrix chart. 本公开提供了一种基于VBA的矩阵图表生成方法，包括：获取待处理的数据，并在Excel页面中分别设置数据存储区域和矩阵图表区域；根据数据存储区域的行列属性将获取的数据录入到表格中；利用VBA代码对表格内的数据进行读取，并计算所述表格中每个单元格数据所对应矩阵图表位置的相关属性值；将计算所述相关属性值的VBA相关代码插入所述矩阵图表区域的相应位置；获得生成的矩阵图表。