CN113505170A - Graph display method, computer device, and computer-readable medium - Google Patents
Graph display method, computer device, and computer-readable medium Download PDFInfo
- Publication number
- CN113505170A CN113505170A CN202110739516.8A CN202110739516A CN113505170A CN 113505170 A CN113505170 A CN 113505170A CN 202110739516 A CN202110739516 A CN 202110739516A CN 113505170 A CN113505170 A CN 113505170A
- Authority
- CN
- China
- Prior art keywords
- reference line
- data
- graph
- display method
- items
- 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.)
- Withdrawn
Links
- 238000000034 method Methods 0.000 title claims abstract description 27
- 230000006870 function Effects 0.000 claims description 8
- 238000010586 diagram Methods 0.000 description 10
- 239000003086 colorant Substances 0.000 description 4
- 230000000694 effects Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention provides a graph display method, a computer device and a computer readable medium. The graph display method includes: providing a data table; generating a data graph based on the data table; and calling a reference line establishing tool after the data graph is selected so as to add a reference line in the data graph. Thus, the reference line can be added at will when the chart is realized, so that the chart display is richer.
Description
Technical Field
The present invention relates to the field of document processing, and in particular, to a method and a computer apparatus for displaying a chart, and a computer readable medium.
Background
Office software is currently in common use. The existing table processing program (Excel) generally supports a graph display function, and table data can be graphically displayed under the function, however, all display contents of the existing graph display are derived from original data, additional annotation information cannot be added, and the display contents are not rich enough.
Therefore, there is a need for an improved solution to overcome the above problems.
Disclosure of Invention
The invention aims to provide a chart display method, a computer device and a computer readable medium, which can further add a reference line when table data is graphically displayed so as to facilitate the reference comparison of a user.
According to another aspect of the present invention, there is provided a chart display method including: providing a data table; generating a data graph based on the data table; and calling a reference line establishing tool after the data graph is selected so as to add a reference line in the data graph.
Further, the data table includes a plurality of items and data corresponding to each item, and the data table is calculated from the source data.
Further, the items are divided into a row type item and a column type item, and each data corresponds to one row type item and one column type item.
Further, the data graph is one of a bar graph, a line graph, an area graph and a scatter diagram.
Further, a line type and/or a color of the reference line is selected in the reference line creation tool.
Further, filling the reference line label in the reference line establishing tool, or leaving the reference line label empty.
Further, the reference line establishing tool is filled with a reference line value, or a function formula of the reference line value is filled in the reference line establishing tool.
Further, the function formula takes partial data of the source data as variables.
According to another aspect of the present invention, there is provided a computing device comprising a processor and a memory, the memory having stored therein program instructions that are executable by the processor to implement the above-described graph display method.
According to another aspect of the present invention, there is provided a computer readable medium having stored therein program instructions that are executed to implement the above-described graph display method.
Compared with the prior art, the method and the device have the advantage that the reference line is further added when the table data is displayed graphically, so that the user can conveniently perform reference comparison.
Drawings
FIG. 1 is a schematic flow chart diagram illustrating a method of graphically displaying a graphical representation of the present invention in one embodiment;
FIG. 2 is an example of a data source;
FIG. 3 is an example of a data table formed based on the data sources shown in FIG. 2;
FIG. 4 is an example of a data graph generated based on the data table shown in FIG. 3;
FIG. 5 is an exemplary diagram of adding a reference line using a reference line creation tool;
FIG. 6 is an example of adding the reference lines shown in FIG. 5 to the data graph shown in FIG. 4;
FIG. 7 is an exemplary diagram of the addition of another reference line using a reference line creation tool;
FIG. 8 is an example of adding the reference lines shown in FIG. 7 to the data graph shown in FIG. 4;
FIG. 9 is a schematic diagram of a line type for selecting a reference line using a reference line creation tool;
FIG. 10 is a schematic diagram of selecting a color of a reference line using a reference line creation tool;
FIG. 11 is an example of setting the values of a reference line using a reference line creation tool; and
FIG. 12 is another example of setting the values of a reference line using a reference line creation tool.
Detailed Description
To further explain the technical means and effects of the present invention adopted to achieve the predetermined objects, the following detailed description of the embodiments, structures, features and effects according to the present invention will be given with reference to the accompanying drawings and preferred embodiments.
The invention provides a chart display method, which is convenient for a user to compare by adding a reference line when table data is graphically displayed.
FIG. 1 is a flow chart illustrating a method 100 of the present invention in one embodiment. As shown in fig. 1, the method 100 includes the following steps.
At step 110, a data table is provided.
In one embodiment, the data table may include a plurality of items and data corresponding to each item. Specifically, the data table is calculated from the source data. The items are divided into row-class items and column-class items, and each data corresponds to one row-class item and one column-class item.
FIG. 2 is an example of a data source. FIG. 3 is an example of a data table formed based on the data sources shown in FIG. 2. As shown in fig. 3, the data includes a plurality of items, such as office items, furniture items, science and technology items, east, south, west, and middle, wherein the office items, furniture items, science and technology items are row items, and east, south, west, and middle are column items. Of course, in other embodiments, there may be only one type of item. The data table in fig. 3 may be automatically calculated from the data source or manually counted based on the data items.
In one embodiment, the method 100 is implemented based on a table handler, and the source data and the table data are both recorded in a table handler file.
And 120, generating a data graph based on the data table.
In one embodiment, the data graph is one of a bar graph, a line graph, an area graph, and a scatter plot. Fig. 4 is an example of a data graph generated based on the data table shown in fig. 3, in which the data graph is a histogram. The data table can be displayed graphically more intuitively through the book data graph.
And step 130, calling a reference line establishing tool after the data graph is selected so as to add a reference line in the data graph.
In one embodiment, the line type and/or color of the reference line may be selected in the reference line creation tool; the label of the reference line can be filled in the reference line establishing tool, or the label of the reference line is empty; the reference line establishing tool may be filled with a reference line value, or a function formula of the reference line value. The function formula may take partial data of the source data as variables.
Fig. 9 is a schematic diagram of a line type for selecting a reference line by using a reference line creation tool, as shown in fig. 9, the line type has a plurality of types, and a user can select one of the types according to his or her needs. Fig. 10 is a schematic diagram of selecting colors of reference lines by using a reference line creation tool, as shown in fig. 10, the colors are various, and a user can select one of the colors according to his or her needs. As shown in fig. 9, the reference line value may be written directly in the column of the value by using the reference line creation tool, or the fx button next to the reference line value may be clicked to bring up the editing interface of the value. Fig. 11 is an example of setting a value of a reference line using a reference line creation tool, and in this example, "═ 650" is written directly in an editing interface of the value. Fig. 12 is another example of setting a value of a reference line, where "═ avg (profit)" is directly written in an editing interface of the value, which is equal to an average value of profits, using a reference line creation tool. Of course, the values may also be obtained from other functional formulas.
FIG. 5 is an exemplary diagram of the addition of a reference line using the reference line creation tool, in this example, the reference line color has been selected to be red, the reference line type is a short dashed line, the reference line value is 65000, and the reference line label is 65000. Fig. 6 is an example of adding the reference line shown in fig. 5 to the data graph shown in fig. 4, and it can be seen that one more reference line is added to the histogram, the ordinate of the reference line is the value 65000 of the reference line, and the upper right side of the reference line has its label "65000".
Fig. 7 is an exemplary diagram of the addition of another reference line using the reference line creation tool, in this example, the reference line color has been selected to be green, the line type of the reference line is a long and short dashed line, the value of the reference line is 747936, and the label of the reference line is the reference line. Fig. 8 is an example of adding the reference line shown in fig. 7 to the data graph shown in fig. 4, and it can be seen that one more reference line is added to the histogram, the ordinate of the reference line is the value 747936 of the reference line, and the upper right side of the reference line has the label "reference line".
Through the newly added reference line, the user can compare the bar-shaped bars of the bar-shaped graph based on the reference line so as to more quickly know much information, such as which are higher than the reference line, how much each bar-shaped bar is higher, which are lower than the reference line, how much each bar-shaped bar is lower, and the like. In the prior art, when the chart is displayed, all graphs are derived from original data, and a mark which is not the original data cannot be added, but a reference line can be added, so that the reference comparison of a user is facilitated.
The number of the reference lines may be 1 or more. When a new reference line is needed, after clicking the new reference line, filling or selecting labels, values, line types and colors. If the user does not make a selection, one line type and one color will be defaulted.
According to another aspect of the present invention, a computer readable medium is provided, in which program instructions are stored, the program instructions being executed by a processor to implement the graph display method 100 described above.
According to another aspect of the present invention, a computing device is provided that includes a processor and a memory having stored therein program instructions that are executed by the processor to implement the graphical display method 100 described above.
As used herein, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, including not only those elements listed, but also other elements not expressly listed.
In this document, the terms front, back, upper and lower are used to define the components in the drawings and the positions of the components relative to each other, and are used for clarity and convenience of the technical solution. It is to be understood that the use of the directional terms should not be taken to limit the scope of the claims.
The features of the embodiments and embodiments described herein above may be combined with each other without conflict.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (10)
1. A method of displaying a chart, comprising:
providing a data table;
generating a data graph based on the data table; and
and calling a reference line establishing tool after the data graph is selected so as to add a reference line in the data graph.
2. The chart displaying method according to claim 1, wherein said data table includes a plurality of items and data corresponding to each item,
the data table is calculated from the source data.
3. A chart display method according to claim 2, wherein said plurality of items are divided into row class items and column class items, one row class item and one column class item for each data.
4. The method of chart display according to claim 1 wherein the data graphic is one of a bar graph, a line graph, an area graph, and a scatter graph.
5. A method as claimed in claim 1, characterized by selecting the line type and/or the colour of the reference line in said reference line creation means.
6. A chart display method according to claim 1, wherein the reference line building tool is filled with or emptied of the labels of the reference lines.
7. A chart display method as claimed in claim 1, wherein a reference line value is filled in said reference line creation tool, or,
and filling a function formula of the value of the reference line in the reference line establishing tool.
8. A chart display method as set forth in claim 7 wherein said function formula takes partial data of said source data as variables.
9. A computing device comprising a processor and a memory, said memory having stored therein program instructions that are executable by the processor to implement the graphical display method of any of claims 1 to 8.
10. A computer-readable medium having stored therein program instructions that are executed to implement the graphical display method of any of claims 1-8.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110739516.8A CN113505170A (en) | 2021-06-30 | 2021-06-30 | Graph display method, computer device, and computer-readable medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110739516.8A CN113505170A (en) | 2021-06-30 | 2021-06-30 | Graph display method, computer device, and computer-readable medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN113505170A true CN113505170A (en) | 2021-10-15 |
Family
ID=78009519
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110739516.8A Withdrawn CN113505170A (en) | 2021-06-30 | 2021-06-30 | Graph display method, computer device, and computer-readable medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113505170A (en) |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CA2795183A1 (en) * | 2010-04-30 | 2011-11-03 | Microsoft Corporation | Temporary formatting and charting of selected data |
CN109146998A (en) * | 2018-08-15 | 2019-01-04 | 广州盖特软件有限公司 | The offscale design line shearing method for drafting of computer based on WEB |
CN112748917A (en) * | 2019-10-29 | 2021-05-04 | 北京国双科技有限公司 | Chart display method and device |
-
2021
- 2021-06-30 CN CN202110739516.8A patent/CN113505170A/en not_active Withdrawn
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CA2795183A1 (en) * | 2010-04-30 | 2011-11-03 | Microsoft Corporation | Temporary formatting and charting of selected data |
CN102870106A (en) * | 2010-04-30 | 2013-01-09 | 微软公司 | Temporary formatting and charting of selected data |
CN109146998A (en) * | 2018-08-15 | 2019-01-04 | 广州盖特软件有限公司 | The offscale design line shearing method for drafting of computer based on WEB |
CN112748917A (en) * | 2019-10-29 | 2021-05-04 | 北京国双科技有限公司 | Chart display method and device |
Non-Patent Citations (1)
Title |
---|
亦心EXCEL: "Excel答粉丝问:折线图如何添加参考线?", Retrieved from the Internet <URL:https://blog.csdn.net/zhulianfang1991/article/details/113097429> * |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11561996B2 (en) | Continuously scrollable calendar user interface | |
KR102546913B1 (en) | Graphics-enhanced template-based calendar events | |
CN109614424B (en) | Page layout generation method, device, computing equipment and medium | |
KR101794373B1 (en) | Temporary formatting and charting of selected data | |
CN106033471B (en) | A kind of method and apparatus handling list | |
CN107229474B (en) | Method and device for rapidly configuring Java interface and chart service based on visual interface | |
US20070050697A1 (en) | Integrated spreadsheet expanding table with collapsable columns | |
CN111259644A (en) | Rich text processing method, editor, equipment and storage medium | |
US10558745B2 (en) | Information processing apparatus and non-transitory computer readable medium | |
CN109783782B (en) | Method, equipment, storage medium and device for generating electronic contract template | |
CN110853721A (en) | Ultrasonic report display method and device, ultrasonic equipment and storage medium | |
US20060036477A1 (en) | System and method for providing information about an operation's applicability to an item | |
US10289388B2 (en) | Process visualization toolkit | |
CN112417830B (en) | Document page management method and device, electronic equipment and storage medium | |
CN115270737B (en) | Method and device for modifying format of target object | |
CN113505170A (en) | Graph display method, computer device, and computer-readable medium | |
CN114997126A (en) | Electronic form display method and device, electronic equipment and storage medium | |
CN110795922B (en) | Form information display method and device for PDF document and electronic equipment | |
CN112434500A (en) | Resume generation method, device, client, server and storage medium | |
CN114780084B (en) | Configuration system for collaborative multi-type interactive interface design | |
CN109033051A (en) | A kind of data lead-in method, device and computer-readable medium | |
CN113655934B (en) | Electronic file display method, electronic file display device, computing equipment and computer storage medium | |
CN116402038B (en) | Report generation method, report generation device, electronic equipment and storage medium | |
WO2024000111A1 (en) | Desktop display method, electronic device, display apparatus and computer-readable storage medium | |
CN115268884A (en) | Mobile terminal visual page configuration and rendering method based on aPaaS platform |
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 | ||
WW01 | Invention patent application withdrawn after publication |
Application publication date: 20211015 |
|
WW01 | Invention patent application withdrawn after publication |