CN113420536A - Automatic point-distance chart generation method and system - Google Patents
Automatic point-distance chart generation method and system Download PDFInfo
- Publication number
- CN113420536A CN113420536A CN202110626766.0A CN202110626766A CN113420536A CN 113420536 A CN113420536 A CN 113420536A CN 202110626766 A CN202110626766 A CN 202110626766A CN 113420536 A CN113420536 A CN 113420536A
- Authority
- CN
- China
- Prior art keywords
- data
- chart
- area
- column
- temporary
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000013500 data storage Methods 0.000 claims abstract description 40
- 238000010586 diagram Methods 0.000 claims description 30
- 238000004364 calculation method Methods 0.000 claims description 6
- 238000007781 pre-processing Methods 0.000 claims description 6
- 238000004590 computer program Methods 0.000 claims description 4
- 238000013479 data entry Methods 0.000 claims description 3
- 239000011159 matrix material Substances 0.000 claims description 2
- 230000006870 function Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000013079 data visualisation Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T11/00—2D [Two Dimensional] image generation
- G06T11/20—Drawing from basic elements, e.g. lines or circles
- G06T11/206—Drawing of charts or graphs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Processing Or Creating Images (AREA)
Abstract
The present disclosure provides a method and a system for automatically generating a dot pitch chart, including: 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 a name is located in the data storage area and a column where the data is located to a temporary area, calculating an equal score value based on the data, and determining the size of the equal score value in the temporary area; and generating a dot pitch chart by using VBA codes based on the temporary region data in a mode of combining a histogram and a scatter chart.
Description
Technical Field
The disclosure belongs to the technical field of data visualization, and particularly relates to a method and a system for automatically generating a point distance chart.
Background
The statements in this section merely provide background information related to the present disclosure and may not necessarily constitute prior art.
The presentation of data contrast is a common application in data visualization. When comparing multiple data values, one typically uses a histogram, pie chart, or other chart. In such a graph, one would also use a position of the use point to express a value of the data size. This type of chart does not have a uniform name and is referred to herein as a dot-space chart. The point distance graph resembles a histogram, i.e., the magnitude of the values is represented using the origin at the endpoints of the histogram rather than using a bar. The graph can better convey numerical information because the point is located from the point used by the graph rather than the length of the column or the angle of the pie chart. The point-to-point diagram has fewer graphic elements, can make the diagram more sparse and concise, and can leave more space compared with the histogram, so that people can read and understand the diagram more easily. And because the space left by the dot-space graph is more, the graph is more suitable for expressing multi-series data. Thus, the dot pitch graph is a more flexible and efficient numerical comparison graph in addition to the histogram.
The inventor finds that, because the diagram is not a basic diagram type, no direct method and corresponding functional module exist for making and generating the diagram, most of the cases can only be made in a manual mode, and the process is complex.
Disclosure of Invention
In order to solve the problems, the invention provides a method and a system for automatically generating a point distance chart.
According to a first aspect of the embodiments of the present disclosure, there is provided a method for automatically generating a dot pitch chart, including:
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 a name is located in the data storage area and a column where the data is located to a temporary area, calculating an equal score value based on the data, and determining the size of the equal score value in the temporary area;
and generating a dot pitch chart by using VBA codes based on the temporary region data in a mode of combining a histogram and a scatter chart.
Further, the generating of the point distance chart by using the VBA code in a manner of combining the histogram and the scatter diagram specifically includes: based on the temporary region data, firstly, generating a horizontal histogram in the dot-space chart region, deleting vertical grid lines of the histogram, and displaying horizontal grid lines; next, a scatter plot is generated at the point from the plot area.
Further, the scatter diagram is generated by adopting the following settings: the horizontal axis of the scatter diagram is set as a data storage column of the temporary area data, and the vertical axis is set as an equant numerical value storage column of the temporary area data.
Further, the vertical axis of the horizontal histogram is set as a name storage column of the temporary area data, and the horizontal axis is set as a numerical value storage column.
Further, the numerical value in the bisector number storage column in the temporary area simulates the height average score of the elements in the data storage column in the dot pitch chart, so that each data can be uniformly distributed in the longitudinal axis direction of the dot pitch chart.
According to a second aspect of the embodiments of the present disclosure, there is provided a VBA-based matrix chart generation system, including:
the system comprises a preprocessing unit, a data storage area, a temporary area and a dot pitch chart area, wherein the preprocessing unit is used for setting the data storage area, the temporary area and the dot pitch chart area in an Excel page in advance;
the data entry unit is used for inputting the acquired data into a table based on the row and column names of the data storage area;
the device comprises a uniform score value calculation unit, a data storage area and a temporary area, wherein the uniform score value calculation unit is used for reading data of the data storage area by using VBA codes, copying a column where a name is located in the data storage area and a column where the data is located to the temporary area, calculating a uniform score value based on the data and determining the size of the uniform score value in the temporary area;
and the dot pitch chart generating unit is used for generating a dot pitch chart by using VBA codes in a mode of combining a histogram and a scatter chart based on the temporary area data.
According to a third aspect of the embodiments of the present disclosure, there is provided an electronic device, including a memory, a processor, and a computer program stored in the memory and running on the memory, where the processor implements the method for automatically generating a dot pitch chart when executing the program.
According to a fourth aspect of the embodiments of the present disclosure, there is provided a non-transitory computer-readable storage medium having stored thereon a computer program, which when executed by a processor implements the method for automatically generating a dot pitch chart.
Compared with the prior art, the beneficial effect of this disclosure is:
(1) the scheme disclosed by the disclosure is based on Excel office software, combines with a VBA macro programming language, and automatically generates a point distance chart by combining the characteristics of a histogram and a scatter diagram in a mode of combining various charts; meanwhile, since the Excel software is one of the most common and most available spreadsheet software at present, the system has strong universality and practicability.
(2) The scheme disclosed by the invention can fully automatically generate the dot pitch chart, and only basic data and the domain name of the cell area need to be provided by a user, and the scheme has no requirement on a VBA script programming language for the user; the scheme is realized based on a self-contained graph generation function in Excel software, so that different elements can be directly adjusted, added or deleted in a picture for a final result, and the scheme has higher flexibility.
(3) The scheme disclosed by the disclosure has certain expansibility for a user with a certain VBA program basis, the user can modify corresponding steps in the code according to requirements, and the automation or semi-automation of key steps is realized.
Advantages of additional aspects of the disclosure will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the disclosure.
Drawings
The accompanying drawings, which are included to provide a further understanding of the disclosure, illustrate embodiments of the disclosure and together with the description serve to explain the disclosure and are not to limit the disclosure.
Fig. 1 is a schematic diagram of raw data according to a first embodiment of the disclosure;
FIG. 2 is a graph of dot pitch generated based on the raw data of FIG. 1 using the method of the present disclosure according to a first embodiment of the present disclosure;
fig. 3 is a schematic diagram of temporary data according to a first embodiment of the disclosure;
fig. 4 is a schematic diagram of original data under a condition of a large amount of data according to a first embodiment of the disclosure;
FIG. 5 is a graph of dot-space generated based on the data shown in FIG. 4 using the solution of the present disclosure as described in the first embodiment of the present disclosure;
FIG. 6 is a graph illustrating the results of the sorting based on the dot-space diagram of FIG. 5 according to an embodiment of the present disclosure;
fig. 7 is a flowchart of an automated dot pitch chart generation method according to a first embodiment of the disclosure.
Detailed Description
The present disclosure is further described with reference to the following drawings and examples.
It should be noted that the following detailed description is exemplary and is intended to provide further explanation of the disclosure. Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this disclosure belongs.
It is noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of example embodiments according to the present disclosure. As used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, and it should be understood that when the terms "comprises" and/or "comprising" are used in this specification, they specify the presence of stated features, steps, operations, devices, components, and/or combinations thereof, unless the context clearly indicates otherwise.
The embodiments and features of the embodiments in the present disclosure may be combined with each other without conflict.
The first embodiment is as follows:
the embodiment aims to provide an automatic point distance chart generation method.
A method for automatically generating a point distance chart comprises the following 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 a name is located in the data storage area and a column where the data is located to a temporary area, calculating an equal score value based on the data, and determining the size of the equal score value in the temporary area;
and generating a dot pitch chart by using VBA codes based on the temporary region data in a mode of combining a histogram and a scatter chart.
Specifically, for ease of understanding, the embodiments of the present disclosure are described in detail below with reference to the accompanying drawings:
in order to better illustrate the generation idea of the invention, a description of the diagram and the implementation principle of the key steps are given first:
as shown in fig. 1, is raw data; fig. 2 is a graph of dot pitch finally generated by the scheme of the present disclosure, and fig. 3 is temporary data in the generation process of the method of the present disclosure. The temporary data can be deleted or saved in other pages by using a program after the chart generation is completed. For ease of description, the temporary data in FIG. 3 uses X, Y, and Z to identify three columns, respectively. Where X and Y are listed in the original data (i.e., FIG. 1) in the "name" column and the "value" column, which are identical. The data of Z is the position value obtained by dividing the value 1 by n. For example, if the original data is 10 lines of data in total, 1 needs to be divided into 11 equal parts, so that the value of each small segment is 1/11-0.090909. Thus, the Z columns are 0.090909 larger for the first row than 0 and 0.090909 larger for the second row than the first row. By analogy, the difference between the last row and 1 is also 0.090909. The function of Z will be described with reference to fig. 2.
The main idea of the solution described in the present disclosure is a method of using two charts to be presented in the same area. The first graph is a lateral histogram based on X and Y columns. It can be seen from fig. 2 that the size of each datum corresponds to the distance from the right black dot to the left graph boundary. And the columnar elements in the histogram are hidden here. The purpose of the chart is to concatenate the data names into values, i.e., if the original data appears to be out of order, the end result will be adjusted in real time. The second graph is a scatter diagram, and the data on the horizontal axis of the scatter diagram is the Y column, i.e. the raw data. The vertical axis of the scatter plot is Z column data. Since the values of the Z column data simulate the highly averaged distribution of the graph, the distribution is averaged along the vertical axis of the graph. For example, if only the data in the Y and Z columns of FIG. 3 are viewed, the data corresponds to the position of the scatter plot in FIG. 2. That is, X columns are horizontal axis positions of the black dots, and Y columns are vertical axis positions of the black dots.
Based on the above description, the scheme disclosed by the present disclosure includes the following specific steps:
step 1: enabling generation of auxiliary data in VBA according to data area
Assume that the area name of the column in fig. 1 where the name of the original data is located is DataName, and the area where the data is located is DataValue. To generate the temporary data in fig. 3. Firstly, a temporary area is created and named according to the size of an original data area, and the VBA code of the temporary area is as follows: in the code, nameRng is used to represent the X column area, dataRng is used to represent the Y column, and dotDataRng is used to represent the Z column in FIG. 3. And copied using a copy function. The new area is 3 units to the right of the original area. The number of area lines is enlarged for convenience of the later n division for calculating 1.
---------------------------
Set nameRng＝Range("DataName").Resize(Range("DataName")._
Rows.Count+2).Offset(-1,4)
Set dataRng＝Range("DataValue").Resize(Range("DataValue")._
Rows.Count+2).Offset(-1,3)
Set dotDataRng＝dataRng.Offset(0,1)
Range("DataName").Copy nameRng.Offset(1,0)
Range("DataValue").Copy dataRng.Offset(1,0)
---------------------------
Next, continuing to calculate the equal score value and fill the Z column, specifically using the following codes: the number of aliquots is first calculated, the variable tNum. The size of each segment, i.e. the value of the variable u, is then calculated. The Z column is then filled in using a loop.
---------------------------
tNum＝dotDataRng.Rows.Count-1
u＝(1/tNum)
For i＝0To dotDataRng.Rows.Count-1
dotDataRng.Cells(i+1,1)＝i*u
Next i
---------------------------
Step 2: generating a histogram and a scatter plot in the VBA;
the first chart, the histogram, is generated using the code, and the vertical grid lines are deleted and the horizontal grid lines are displayed. The following codes are mainly adopted, specifically, Union (nameRng, dataRng) combines X and Y columns. The first two sentences of the code are used for generating charts, and the last two sentences are used for setting grid lines. After the setting is performed, a boundary may be added to the drawing area in the diagram and a grid line format may be set. For example, the horizontal grid lines in fig. 2 are dashed lines. Such steps may be performed during the final adjustment and are therefore not described in further detail.
---------------------------
ActiveSheet.Shapes.AddChart2(216,xlBarClustered).Select
ActiveChart.SetSourceData Source:＝Union(nameRng,dataRng)
ActiveChart.SetElement(msoElementPrimaryValueGridLinesNone)
ActiveChart.Axes(xlCategory).HasMajorGridlines＝True
---------------------------
Generating the scatter plot specifically employs code that specifically steps adding a new series and setting the series as the scatter plot.
---------------------------
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection.NewSeries
ActiveChart.FullSeriesCollection(2).Select
ActiveChart.FullSeriesCollection(2).ChartType＝xlXYScatter
---------------------------
And step 3: adjusting the data source and the setting of the table number axis in the table in the VBA;
the code for setting the horizontal axis of the scatter plot as a Y column and the vertical axis as Z, and placing the chart elements on the axes instead of in the axes is as follows. The first two rows of the code are to set the horizontal axis data as Y columns. The next two rows are with the vertical axis set to Z columns. The latter two rows are for placing the chart elements on the axes.
---------------------------
ActiveChart.FullSeriesCollection(2).XValues＝_
dataRng.Resize(dataRng.Rows.Count-2).Offset(1,0)
ActiveChart.FullSeriesCollection(2).Values＝_
dotDataRng.Resize(dotDataRng.Rows.Count-2).Offset(1,0)
ActiveChart.Axes(xlCategory).Select
ActiveChart.Axes(xlCategory).AxisBetweenCategories＝False
---------------------------
And 4, step 4: and further adjusting and setting the generated graph.
In this step, other elements of the diagram may be added and deleted or existing elements may be set, for example, using the following statements:
ActiveChart.SetElement(msoElementSecondaryCategoryAxisShow)
the values on the horizontal axis of the graph may be displayed, i.e., the lowest value label in fig. 2.
Further, in order to prove the effectiveness of the method of the present disclosure, in this embodiment, an example of generating a point distance chart is given:
FIG. 4 is a diagram illustrating the original data in the case of a large amount of data; FIG. 5 is a graph of dot pitch generated based on the data shown in FIG. 4 using the solution of the present disclosure; FIG. 6 is a graph illustrating the results sorted based on the dot spacing chart of FIG. 5; in connection with the graph it can be found that the point distance graph resembles a histogram, i.e. the value size is represented using the origin at the end points of the histogram instead of using a bar. The graph can better convey numerical information because the point is located from the point used by the graph rather than the length of the column or the angle of the pie chart. The point-to-point diagram has fewer graphic elements, can make the diagram more sparse and concise, and can leave more space compared with the histogram, so that people can read and understand the diagram more easily. And because the space left by the dot-space graph is more, the graph is more suitable for expressing multi-series data. Thus, the dot pitch graph is a more flexible and efficient numerical comparison graph in addition to the histogram.
Example two:
the purpose of this embodiment is to provide a dot pitch chart automated generation system.
A dot pitch chart automated generation system, comprising:
the system comprises a preprocessing unit, a data storage area, a temporary area and a dot pitch chart area, wherein the preprocessing unit is used for setting the data storage area, the temporary area and the dot pitch chart area in an Excel page in advance;
the data entry unit is used for inputting the acquired data into a table based on the row and column names of the data storage area;
the device comprises a uniform score value calculation unit, a data storage area and a temporary area, wherein the uniform score value calculation unit is used for reading data of the data storage area by using VBA codes, copying a column where a name is located in the data storage area and a column where the data is located to the temporary area, calculating a uniform score value based on the data and determining the size of the uniform score value in the temporary area;
and the dot pitch chart generating unit is used for generating a dot pitch chart by using VBA codes in a mode of combining a histogram and a scatter chart based on the temporary area data.
Further, the generating of the point distance chart by using the VBA code in a manner of combining the histogram and the scatter diagram specifically includes: based on the temporary region data, firstly, generating a horizontal histogram in the dot-space chart region, deleting vertical grid lines of the histogram, and displaying horizontal grid lines; next, a scatter plot is generated at the point from the plot area.
Further, the scatter diagram is generated by adopting the following settings: the horizontal axis of the scatter diagram is set as a data storage column of the temporary area data, the vertical axis is set as an equant numerical value storage column of the temporary area data, and chart elements are placed on the axis.
In further embodiments, there is also provided:
an electronic device comprising a memory and a processor, and computer instructions stored on the memory and executed on the processor, the computer instructions when executed by the processor performing the method of embodiment one. For brevity, no further description is provided herein.
It should be understood that in this embodiment, the processor may be a central processing unit CPU, and the processor may also be other general purpose processors, digital signal processors DSP, application specific integrated circuits ASIC, off-the-shelf programmable gate arrays FPGA or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, and so on. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory may include both read-only memory and random access memory, and may provide instructions and data to the processor, and a portion of the memory may also include non-volatile random access memory. For example, the memory may also store device type information.
A computer readable storage medium storing computer instructions which, when executed by a processor, perform the method of embodiment one.
The method in the first embodiment may be directly implemented by a hardware processor, or may be implemented by a combination of hardware and software modules in the processor. The software modules may be located in ram, flash, rom, prom, or eprom, registers, among other storage media as is well known in the art. The storage medium is located in a memory, and a processor reads information in the memory and completes the steps of the method in combination with hardware of the processor. To avoid repetition, it is not described in detail here.
Those of ordinary skill in the art will appreciate that the various illustrative elements, i.e., algorithm steps, described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
The point distance chart automatic generation method and system provided by the embodiment can be realized, and have a wide application prospect.
The above description is only a preferred embodiment of the present disclosure and is not intended to limit the present disclosure, and various modifications and changes may be made to the present disclosure by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present disclosure should be included in the protection scope of the present disclosure.
Although the present disclosure has been described with reference to specific embodiments, it should be understood that the scope of the present disclosure is not limited thereto, and those skilled in the art will appreciate that various modifications and changes can be made without departing from the spirit and scope of the present disclosure.
Claims (10)
1. An automatic generation method of a point distance chart is characterized by comprising the following 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 a name is located in the data storage area and a column where the data is located to a temporary area, calculating an equal score value based on the data, and determining the size of the equal score value in the temporary area;
and generating a dot pitch chart by using VBA codes based on the temporary region data in a mode of combining a histogram and a scatter chart.
2. The method for automatically generating the point distance chart according to claim 1, wherein the point distance chart is generated by using VBA codes in a mode of combining a histogram and a scatter diagram, and specifically comprises the following steps: based on the temporary region data, firstly, generating a horizontal histogram in the dot-space chart region, deleting vertical grid lines of the histogram, and displaying horizontal grid lines; next, a scatter plot is generated at the point from the plot area.
3. The method for automatically generating the dot pitch chart according to claim 1, wherein the generation of the scatter chart adopts the following settings: the horizontal axis of the scatter diagram is set as a data storage column of the temporary area data, and the vertical axis is set as an equant numerical value storage column of the temporary area data.
4. The method according to claim 1, wherein a vertical axis of the horizontal histogram is set as a name storage column of the temporary area data, and a horizontal axis is set as a numerical value storage column.
5. The method as claimed in claim 1, wherein the numerical value in the bisector number storage column in the temporary area simulates a high average score of the elements in the data storage column in the dot pitch chart, so that the data can be uniformly distributed in the longitudinal axis direction of the dot pitch chart.
6. A VBA-based matrix chart generation system, comprising:
the system comprises a preprocessing unit, a data storage area, a temporary area and a dot pitch chart area, wherein the preprocessing unit is used for setting the data storage area, the temporary area and the dot pitch chart area in an Excel page in advance;
the data entry unit is used for inputting the acquired data into a table based on the row and column names of the data storage area;
the device comprises a uniform score value calculation unit, a data storage area and a temporary area, wherein the uniform score value calculation unit is used for reading data of the data storage area by using VBA codes, copying a column where a name is located in the data storage area and a column where the data is located to the temporary area, calculating a uniform score value based on the data and determining the size of the uniform score value in the temporary area;
and the dot pitch chart generating unit is used for generating a dot pitch chart by using VBA codes in a mode of combining a histogram and a scatter chart based on the temporary area data.
7. The system for automatically generating a point distance chart according to claim 6, wherein the point distance chart is generated by using VBA codes in a manner of combining a histogram and a scatter diagram, and specifically comprises: based on the temporary region data, firstly, generating a horizontal histogram in the dot-space chart region, deleting vertical grid lines of the histogram, and displaying horizontal grid lines; next, a scatter plot is generated at the point from the plot area.
8. An automated dot-pitch chart generation system according to claim 6, wherein the scatter chart is generated by adopting the following settings: the horizontal axis of the scatter diagram is set as a data storage column of the temporary area data, the vertical axis is set as an equant numerical value storage column of the temporary area data, and chart elements are placed on the axis.
9. An electronic device comprising a memory, a processor and a computer program stored and executed on the memory, wherein the processor implements a method for automated dot pitch graph generation according to any of claims 1-5 when executing the program.
10. A non-transitory computer-readable storage medium, on which a computer program is stored, which, when executed by a processor, implements a method for automated generation of a plot of distances according to any of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110626766.0A CN113420536A (en) | 2021-06-04 | 2021-06-04 | Automatic point-distance chart generation method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110626766.0A CN113420536A (en) | 2021-06-04 | 2021-06-04 | Automatic point-distance chart generation method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113420536A true CN113420536A (en) | 2021-09-21 |
Family
ID=77713916
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110626766.0A Pending CN113420536A (en) | 2021-06-04 | 2021-06-04 | Automatic point-distance chart generation method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113420536A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2018174365A1 (en) * | 2017-03-20 | 2018-09-27 | 주식회사 뉴스젤리 | Method for visualizing chart of data table |
| CN109491722A (en) * | 2018-11-05 | 2019-03-19 | 四川长虹电器股份有限公司 | Histogram chart plug-in system and its implementation based on wechat small routine |
| CN112269828A (en) * | 2020-11-18 | 2021-01-26 | 网易（杭州）网络有限公司 | Data generation method and device and electronic equipment |
| CN112686982A (en) * | 2020-12-31 | 2021-04-20 | 山东师范大学 | VBA-based multi-dimensional data scatter diagram generation method and system |
| CN112837565A (en) * | 2021-01-20 | 2021-05-25 | 山东师范大学 | Multi-label teaching demonstration system and method for scatter diagram |
-
2021
- 2021-06-04 CN CN202110626766.0A patent/CN113420536A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2018174365A1 (en) * | 2017-03-20 | 2018-09-27 | 주식회사 뉴스젤리 | Method for visualizing chart of data table |
| CN109491722A (en) * | 2018-11-05 | 2019-03-19 | 四川长虹电器股份有限公司 | Histogram chart plug-in system and its implementation based on wechat small routine |
| CN112269828A (en) * | 2020-11-18 | 2021-01-26 | 网易（杭州）网络有限公司 | Data generation method and device and electronic equipment |
| CN112686982A (en) * | 2020-12-31 | 2021-04-20 | 山东师范大学 | VBA-based multi-dimensional data scatter diagram generation method and system |
| CN112837565A (en) * | 2021-01-20 | 2021-05-25 | 山东师范大学 | Multi-label teaching demonstration system and method for scatter diagram |
Non-Patent Citations (2)
| Title |
|---|
| 欣宇521心愿: "ExcelVBA教程：自动生成散点图", 《百度经验》 * |
| 艾月1898: "Excel图表制作一条形图与散点图相结合", 《百度经验》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10650559B2 (en) | Methods and systems for simplified graphical depictions of bipartite graphs | |
| DE102016109517A1 (en) | Reduced storage of strokes in documents | |
| CN103177709A (en) | Method and device for displaying characters | |
| KR20160025519A (en) | Selecting and editing visual elements with attribute groups | |
| EP2002352B1 (en) | Applying effects to a merged text path | |
| DE102007018622A1 (en) | Layout cells, layout cell array, method for generating a layout cell, method for generating a layout cell array, computer program products | |
| CN116644729A (en) | Table file processing method, apparatus, computer device and storage medium | |
| US10402484B2 (en) | Aligning annotation of fields of documents | |
| CN110377559B (en) | PDF file data extraction method, device and storage medium | |
| CN113420536A (en) | Automatic point-distance chart generation method and system | |
| CN112269828A (en) | Data generation method and device and electronic equipment | |
| KR920000978B1 (en) | Block processing method for text editor | |
| CN116630468A (en) | Two-dimensional drawing generation method and device, storage medium and electronic equipment | |
| JP3307498B2 (en) | Graphic drawing apparatus and method | |
| US10740539B2 (en) | Page structure adjustments | |
| CN112765256A (en) | Parallel coordinate axis data visualization method and system | |
| JP6108105B2 (en) | Article image reconstruction device | |
| JPH0692153B2 (en) | Method for clearing mathematical formulas in document processing system | |
| CN101093472A (en) | Method for calculating expression in WEB dynamic line type report forms | |
| CN112926286B (en) | Dynamic form generation method and system | |
| JPH05258073A (en) | Graphic painting-out device | |
| JP2969925B2 (en) | Document processing device | |
| US11600028B1 (en) | Semantic resizing of line charts | |
| CN109697275A (en) | Character library generation method and device | |
| CN109344373B (en) | Report generation method based on intelligent matching and terminal equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210921 |