JPH10198749A - Data display method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To display data so as to easily comprehend their meaning by making data in a table into graph and displaying the table while overlapping it with the graph. SOLUTION: The table data shown in a figure are an example showing the average air temperature for every month in one year at the respective spots of the world and the average air temperature throughout the year, the items of spot names are described as row items on the most left side of table, and the items of January to December and year are described as column items on the top row of table. When a cursor is moved in such a table, the graph of column items corresponding to the row items of rows, where the cursor is positioned, is prepared and displayed while being overlapped on the table data. The spot name of row item is 'Tokyo' and the state of preparing and displaying the column items of monthly average air temperature from January to December in Tokyo and the average air temperature throughout the year as a bar graph is shown. When the cursor is moved to the other row, such a graph is displayed as a graph corresponding to that row.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data display method, and more particularly, to a method for displaying a large table on a display screen so that it is easy to see, and displaying a desired data portion of the displayed table in a graph. The present invention relates to a data display method capable of easily displaying the contents of a table.

[0002]

2. Description of the Related Art Conventionally, in a terminal device or a personal computer, when an operator performs a required task,
The data created in a tabular format is displayed on a display screen such as a display, and the processing is proceeding while viewing the tabular data displayed on the screen.

[0003] When the table format data displayed on the screen is large, the entire table cannot be displayed on one screen, and the operator must move the screen in the vertical direction or the horizontal direction. By scrolling the data displayed in, the part of the data you want to see is displayed in a position that is easy for you to see, and if the data is a numeric string, etc., compare the size of adjacent data and understand the contents of the table And

[0004]

In the data display method according to the prior art described above, a large table cannot be displayed on one screen, and the contents of the table are numerical data, and the size of the left and right data is small or large. When it is meaningful, it is necessary to understand the contents of the table while comparing the size of adjacent data, it is difficult to work, it takes a lot of time to understand the meaning of data, work efficiency And causes the operator to be tired.

[0005] In order to display the entire large table on one screen, there is also a method of reducing and displaying data. In this case, characters such as alphabets and numerals can be recognized, but there are many strokes such as kanji. There is a problem that character recognition becomes difficult.

SUMMARY OF THE INVENTION An object of the present invention is to solve the problems of the data display method according to the prior art, to enable a large table to be displayed on a display screen, to graph the data in the table, and to display the table and the graph. It is an object of the present invention to provide a data display method which makes it possible to superimpose and display the data and display the meaning of the data in an easily understandable manner.

[0007]

According to the present invention, there is provided a data display method for displaying tabular data on a display screen of a terminal device or a personal computer, wherein the tabular data displayed on the display screen is line-oriented. Is composed of a plurality of column items, and the data of the column items of the desired data row displayed in the table are graphed into a bar graph, a line graph or a pie graph, and the created graph is superimposed on the table. It is achieved by displaying.

The object is to display the entire table on the display screen by compressing characters in the table when the entire table of tabular data to be displayed on the display screen is too large to be displayed on the screen. This is achieved by displaying the characters to be compressed and displayed in gray scale or by performing processing according to the algorithm of Ancherias.

The object of the present invention is to create the graph in a data line where a cursor is located when a control cursor is present in a display screen, or when a cursor is clicked. Achieved by doing so for rows.

[0010] The object is to display an underline in a data line corresponding to the created graph when the created graph is a bar graph or a line graph, and to display the graph as a base line of the graph, Also, if the created graph is a pie graph, the column items in the row corresponding to the corresponding graph are displayed with different hatching or colors, and the corresponding items of the displayed pie graph are displayed in the corresponding column items. This is achieved by displaying the corresponding hatching or color.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, an embodiment of a data display method according to the present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing a configuration example of a processing apparatus for executing a data display method according to an embodiment of the present invention.
FIG. 2 is a flowchart illustrating a processing example of a data display method according to an embodiment of the present invention, and FIGS. 3 to 6 are diagrams illustrating examples of tables processed and displayed according to an embodiment of the present invention. In FIG. 1, 101 is a CPU, 102 is a display device, 103 is an input device, 104 is a hard disk device, 105 is an internal memory, and 106 is a floppy disk or CD-ROM disk drive.

As shown in FIG. 1, a processing apparatus for executing the present invention includes a CPU 101 for controlling the processing of the entire apparatus,
A display device 102 including an RT, a liquid crystal or the like, an input device 103 including a keyboard, a mouse, and the like, a hard disk device 104 for storing data and the like necessary for processing,
Stores OS, application programs, etc.
Internal memory 105 used for the processing operation of 101
And a floppy disk or CD-ROM for taking in data from outside or outputting data to outside
, And a disk drive 106.
This processing device can be constituted by a general-purpose personal computer, a work station or the like having a table data processing function.

In the table data displayed according to the embodiment of the present invention, column items are described in the top row of the table, and row items are described in the leftmost column of the table. A data cell is arranged and corresponding data is described. A detailed example will be described later.

Next, an example of the processing operation of the display method according to an embodiment of the present invention will be described with reference to the flow shown in FIG. 2 and the display examples shown in FIGS.

(1) When the processing device is started, a processing menu or the like is displayed on the display device 102 as an initial screen. The operator uses the input device 103 such as a mouse,
An application for table display processing is selected (steps 201 and 202).

(2) When the application for the table display processing is selected in step 202, the CPU 101
Reads out table data stored in the hard disk device 104 or table data stored in a floppy disk or CDROM set in the disk drive 106, and displays a menu by a table name or the like (step). 203).

(3) The operator selects a desired table name from the menu displayed in step 203 with a mouse or the like. With this selection, the selected table data is displayed on the display screen (steps 204 and 205).

(4) The operator indicates whether the displayed table is a part of the table displayed because the table is too large to be displayed on the screen, or the entire table is displayed. If the displayed table is a part of the table and the user wants to see the entire table, the "character compression display" of a function button (not shown) displayed at the top of the display screen or the like is displayed. Alternatively, "display of the entire table" is designated by a mouse or the like (step 206).

(5) When the display of the entire table is instructed in step 206, the character height, character width, or both of the characters in the table are compressed, and the entire table is displayed on the display screen. In the case of performing the character compression display, if pixels are simply decimated and displayed, alphabets, numerals, and the like can be recognized, but characters with many strokes are difficult to recognize. For this reason, in the embodiment of the present invention, when a character is displayed in black and white, the character is displayed including pixels of intermediate luminance by gray scale, and when the character is displayed in color, the character is displayed in ancheerian. Processing according to the algorithm is performed to display the image including the pixels of the intermediate color. This makes it easier to recognize the display character when the character is compressed (step 207).

(6) The operator moves the control cursor with the mouse or the like into the displayed table or the compressed table (step 208).

(7) The CPU 101 checks whether or not the cursor is in the table. If the cursor is outside the table, no processing is performed. A graph corresponding to a certain data row is created, and a graph created near the row is superimposed on the data and displayed. Such display is sequentially performed on the data line where the cursor is located, as described above, as the cursor is moved. An example of a table on which this graph is displayed will be described later (steps 210 and 21).
1).

(8) When the operator wants to stop displaying the displayed table data in the form of a graph, a function button (not shown) displayed at the top of the display screen or the like, such as "view another table" or "view other tables" The display of "processing end" is instructed by a mouse or the like. If the end of the process is instructed, the process is terminated, and if the user instructs to see another table, the display returns to the menu display of the table in step 203, and by selecting another table, another table is displayed in the same manner as described above. You can see the table. In this process, if the cursor is moved to the outside of the table in order to indicate a function button, the display of the graph superimposed on the display screen is not performed (step 212).

In the above-described processing example, it has been described that when the cursor is in the table, a graph is created for the data row where the cursor is located.
By placing the cursor on a desired data line and clicking the mouse, a graph for the data line can be created.

FIG. 3 shows a first example of tabular data in which a graph is superimposed and displayed in step 211 described above.
The table data shown in this example is an example showing monthly average temperatures and year-round average temperatures for one year in various parts of the world. In the leftmost part of the table, the item of the point name is described as a line item, and at the top of the table. In the row, items from January to December and the year are described as column items, and at the position where the row item and the column item intersect, the average temperature of the point at that point, which is data corresponding to both items, is described. .

When the cursor is moved in such a table, a graph of the column item corresponding to the line item of the line where the cursor is located is created and displayed over the table data. In the illustrated example, the column name of the line item is “Tokyo”, and a column item of the average temperature of each month from January to December in Tokyo and the average temperature of the whole year is created and displayed as a bar graph. ing. Such a graph is displayed as a graph of a monthly average temperature at a point corresponding to the row when the cursor is moved to another row.

In the above description, when the display screen is monochrome, processing such as hatching can be performed on the graph section so that the data superimposed on the graph can be easily seen. When the display screen is color, the graph section displays the data. It can be displayed in a different color from the character being displayed. Also, in order to indicate which line of data is displayed in a graph, an underline is displayed on the line, and the color of the data character on the line can be displayed differently from other data characters. . When an underline is displayed on the line, the underline can be used also as a base line of the graph. The display of the graph itself can be at any position in the table, regardless of the position of the corresponding row. In this case, it is necessary to perform the above-described processing for clarifying which row of data is displayed as a graph.

FIG. 4 shows a second example of the table data in which the graphs are superimposed and displayed in step 211 described above. The table data shown in this example is an example showing the average temperature for each month and the whole year for each year in various parts of Japan. As in the case of FIG. It is described as an item, and January to December and the year are described as column items in the top row of the table, and the month corresponding to both items at the position where the row item and the column item intersect is the month corresponding to both items. The average temperature is described.

When the cursor is moved in such a table, a graph of the column item corresponding to the line item of the row where the cursor is located is created and displayed over the table data. In the illustrated example, the point name of the line item is "Yamagata", and the column items of the average temperature of each month from January to December and the average temperature of the whole year in Yamagata are created and displayed as a line graph. Is shown. Such a graph is displayed as a graph of a monthly average temperature at a point corresponding to the row when the cursor is moved to another row.

In the above description, when the display screen is color,
The graph section can be displayed in a different color from the character displaying the data. In order to indicate which line of data is displayed in a graph, the line should be underlined, or the color of the data character on the line should be different from other data characters. Can be. When an underline is displayed on the line, the underline can be used also as a base line of the graph. The display of the graph itself can be at any position in the table, regardless of the position of the corresponding row. In this case, it is necessary to perform the above-described processing for clarifying which row of data is displayed as a graph.

FIG. 5 shows a third example of the tabular data in which the graph is superimposed and displayed in step 211 described above. The tabular data of the example shown in this example is the average number of days in which the weather conditions appear for each month in one year throughout Japan,
"Sunny", "Cloudy", "Unlit", "Snow", "Mist", "Thunder"
In the same way as in the case of FIG. 3, an item based on a spot name and weather is described as a row item on the leftmost side of the table, and an item from January to December is described in a column on the topmost row of the table, as in the case of FIG. At the position where the row item and the column item intersect, the average number of days in the month of the weather condition at that point, which is data corresponding to both items, is described.

When the cursor is moved in such a table, a graph of the column item corresponding to the line item of the line where the cursor is located is created by a mark indicating the weather condition and is displayed over the table data. Is done. In the illustrated example, the column name of the line item is "Gifu", the weather is "sunny", and the column item of the average number of sunny days in each month from January to December in Gifu is a day mark of a sunny mark indicating sunny. This shows a state in which a graph based on numbers is created and displayed. Such a graph is displayed as a graph corresponding to a line when the cursor is moved to another line.

The mark used in the graph described above may be displayed at a position that does not interfere with the table data. When the display screen is in color, the mark used in the graph portion is displayed in a different color from the character displaying the data. , And can be displayed in a shape and color indicating the weather. Also,
To indicate which line of data is displayed as a graph, the line can be underlined, or the color of the data characters on that line can be displayed differently from other data characters . The display of the graph itself can be at any position in the table, regardless of the position of the corresponding row. In this case, it is necessary to perform the above-described processing for clarifying which row of data is displayed as a graph.

FIG. 6 shows a third example of the tabular data in which the graph is superimposed and displayed in step 211 described above. The tabular data shown in this example divides children between the ages of 1 and 14 into age groups of 1 to 4 years, 5 to 10 years, and 11 to 15 years. This is an example of whether or not the player is playing in such a place. As in the case of FIG. 3, the item according to the age group is described as a row item on the leftmost side of the table, and the item of the playground is a column item on the top row of the table. Is described at the position where the row item and the column item intersect, and the data corresponding to the two items is the percentage of the children of that age group who are playing at that location.

When the cursor is moved in such a table, a graph of the column item corresponding to the line item of the line where the cursor is located is created as a pie graph and displayed over the table data. In the illustrated example, the age group of the line item is 5 to 10 years old
At the age, the pie chart shows how much the playground is “around the house”, “park”, “public playground”, and “other” and is displayed as a pie chart.
Such a graph is created by moving the cursor to another line.
It is displayed as a graph corresponding to that row.

In the above description, when the display screen is monochrome, the data cells corresponding to the respective column items in the row direction are hatched differently, and the corresponding pie chart is also displayed with the corresponding hatchings, so that the correspondence is clear. The graph can be displayed over the tabular data. Also, if the display screen is color, the data cells for each of the column items in the row direction are given a different color, and the pie chart to be created is displayed with the corresponding color, so that the correspondence is clear and the graph is displayed. It can be displayed over table data.

In the above-described embodiment of the present invention, when it is desired to select and display one of a plurality of types of graphs in one processing device, the type of graph to be displayed in the processing of step 206 is determined. What is necessary is just to make it select.

According to the data display method according to the embodiment of the present invention as described above, a large table can be displayed on the display screen, the data in the table is graphed, and the table display and the graph are superimposed. Since they can be displayed together, the meaning of the data can be displayed in an easily understandable manner.

The table data shown in FIGS. 3 to 5 are quoted from the CD-ROM version of the Science Dictionary, and the table data shown in FIG. 6 is quoted from the Environmental White Paper.

[0040]

As described above, according to the present invention, it is possible to display a large table on a display screen, graph the data in the table, and superimpose the display of the table and the graph. Therefore, the meaning of the data can be displayed in an easily understandable manner.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a configuration example of a processing device that executes a data display method according to an embodiment of the present invention.

FIG. 2 is a flowchart illustrating a processing example of a data display method according to an embodiment of the present invention.

FIG. 3 is a diagram illustrating a first example of a table processed and displayed according to an embodiment of the present invention.

FIG. 4 is a diagram illustrating a second example of a table processed and displayed according to an embodiment of the present invention.

FIG. 5 is a diagram illustrating a third example of a table processed and displayed according to an embodiment of the present invention.

FIG. 6 is a diagram illustrating a fourth example of a table processed and displayed according to an embodiment of the present invention.

[Explanation of symbols]

Reference Signs List 101 CPU 102 Display device 103 Input device 104 Hard disk device 105 Internal memory 106 Disk drive for floppy disk or CD-ROM

Claims (7)

[Claims] 1. A data display method for displaying tabular data on a display screen of a terminal device or a personal computer, wherein the tabular data displayed on the display screen includes data of a plurality of column items in a row direction. A data display method, wherein data of a column item of a desired data row displayed in a table is graphed, and the created graph is superimposed and displayed on the table. 2. When the entire table of tabular data to be displayed on the display screen has a size that cannot be displayed on the screen, characters in the table are compressed and the entire table is displayed on the display screen. 2. The data display method according to claim 1, wherein the characters to be displayed are displayed in gray scale or by performing processing according to the algorithm of Ancherias. 3. The data display method according to claim 1, wherein the graph is created for a data line where the cursor is located when a control cursor is present in the display screen. 4. The method according to claim 1, wherein when the control cursor in the display screen is positioned at a predetermined data line and clicked, the graph is created for the data line where the cursor is located. Item 3. The data display method according to item 1 or 2. 5. The created graph is a bar graph, a line graph, or a pie graph.
5. The data display method according to any one of Items 1 to 4. 6. The created graph is a bar graph or a line graph, and an underline is displayed in a data line corresponding to the created graph, and the graph is displayed using the underline as a base line of the graph. Item 5. The data display method according to any one of Items 1 to 4. 7. The created graph is a pie chart, and column items in rows corresponding to the created graph are displayed with different hatching or colors, and the corresponding items of the displayed pie graph are displayed in the corresponding columns. 5. The data display method according to claim 1, wherein hatching or color corresponding to the item is displayed.