Unlock instant, AI-driven research and patent intelligence for your innovation.
VBA-based matrix chart generation method and system
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
A technology for generating systems and charts, applied in the field of data visualization, can solve problems such as no functional modules, cumbersome, and inability to complete, and achieve the effects of strong scalability, high flexibility, and high applicability
Inactive Publication Date: 2021-09-21
SHANDONG NORMAL UNIV
View PDF5 Cites 0 Cited by
Summary
Abstract
Description
Claims
Application Information
AI Technical Summary
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
Problems solved by technology
[0004] However, the inventors have found that the generation function of matrix charts is usually embedded in some advanced business data analysis platforms and software (these platform software are usually only open to some professional paid users), and for general software systems (such as Excel ) does not have corresponding functional modules, and using manual or other chart modification methods to generate matrix charts is extremely cumbersome and almost impossible to complete when the amount of data is large
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more
Image
Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
Examples
Experimental program
Comparison scheme
Effect test
Embodiment 1
[0039] The purpose of this embodiment is to provide a method for generating matrix charts based on VBA.
[0040] A method for generating matrix charts based on VBA, comprising:
[0041] Obtain the data to be processed, and set the data storage area and matrix chart area respectively in the Excel page;
[0042] Enter the obtained data into the table according to the row and column attributes of the data storage area;
[0043] Use VBA code to read the data in the form, and calculate the relevant attribute value of the matrix chart position corresponding to each cell data in the form;
[0044] inserting VBA related codes for calculating the related attribute values into the corresponding positions of the matrix chart area; obtaining the generated matrix chart.
[0045] Specifically, for ease of understanding, the solutions described in the present disclosure will be described in detail below in conjunction with the accompanying drawings:
[0046] Step 1: Prepare two-dimensio...
Embodiment 2
[0093] The purpose of this embodiment is to provide a VBA-based system for generating matrix charts.
[0094] A VBA-based matrix chart generation system, including:
[0095] a data acquisition unit, which is used to acquire data to be processed;
[0096] configuration unit, which is used to respectively set the data storage area and the matrix chart area in the Excel page;
[0097] A data entry unit, which is used to enter the acquired data into the form according to the row and column attributes of the data storage area;
[0098] A matrix chart attribute value calculation unit, which is used to read the data in the form using VBA code, and calculate the relevant attribute value of the matrix chart position corresponding to each cell data in the form;
[0099] A matrix chart generation unit, which is used to insert the VBA related codes for calculating the relevant attribute values into corresponding positions in the matrix chart area; and obtain the generated matrix chart...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More
PUM
Login to View More
Abstract
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.
Description
technical field [0001] The disclosure belongs to the technical field of data visualization, and in particular relates to a method and system for generating matrix charts based on VBA. Background technique [0002] The statements in this section merely provide background information related to the present disclosure and do not necessarily constitute prior art. [0003] A two-dimensional table consisting of rows and columns is the most common form of organization in tables. Whether it is a relational database or a spreadsheet system or other flat data display, two-dimensional tables are the most common and important data carrying methods. The visualization of two-dimensional table data has always been an important application field of data visualization technology. Matrix chart (also known as marimekko chart, mosaic chart) is a commonly used and advanced chart that presents two-dimensional data. The main feature of this chart is that it can use the size of the graph to disp...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More
Application Information
Patent Timeline
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to View More 
Login to View More