JPH0640300B2 - Table graph converter - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION (a) Field of Industrial Application The present invention relates to a table / graph conversion device, and more specifically, to item names already created by a device such as a word processor or a personal computer and numerical values corresponding to the item names. It relates to a device for creating a graph from a table with data.

(B) Prior Art Currently, devices such as word processors and personal computers have a function of automatically creating a graph from item names and a table corresponding to the item names as shown in FIG. 1A.

However, in the present apparatus, the graphs automatically created from the table have the item names “A”, “B”, and “C” shown in FIG. 1B.
Is automatically not listed at all. Therefore, such an item name has to be input again after the graph has been created by the user even though the user has already input it when creating the table, and the operability is poor. Furthermore, despite the fact that the table and graph item names must be the same,
If the item name is mistakenly input during the second input, that is, when the graph is created, the item names in the table and the graph do not match.

(C) Object of the invention The present invention has been made in view of the above point, and does not provide a table-graph conversion device that automatically writes an item name in the graph when a graph is automatically created from a table. It is what

Specifically, when converting the table shown in FIG. 1A into a bar graph, as shown in FIG. 1B, item names “A”, “B”,
"C" is also automatically written in the graph.

(D) Structure of the invention The present invention is an apparatus for creating a graph from a table having item names and numerical data corresponding to the item names, and in order to achieve the above object, at least an output in which the table is stored. Data storage means, item name retrieval means for retrieving item names in the table from the storage means, data retrieval means for retrieving numerical data in the table from the output data storage means, and output data storage means in the graph A graph data storage means in which physical data such as a storage area and its size is stored, a graph based on the physical data in the graph data storage means and the numerical data retrieved by the data retrieval means, the output data storage means Graph creation means to write to
An item name writing means for writing the item name retrieved by the item name retrieval means in the output data storage means based on the physical data is provided.

(E) Embodiment FIG. 2 is a block diagram showing an embodiment of the present invention.
Reference numeral (1) is an output data storage means including, for example, a RAM (random access memory), and the storage means has a CRT.
Display data is stored so as to have a one-to-one correspondence with the screen of (2). The contents of the output data storage means (1) are displayed on the CRT (2).

(3) is a graph data storage means, physical data necessary for writing a graph to the output data storage means (1), that is, a graph on the output data storage means (1) The range of the area in which is written (hereinafter referred to as the graph area), the origin position of the graph, the X-axis length, the Y-axis length, the item name position in the graph area, and the like are stored.

It should be noted that the above data will be specifically described with reference to FIG. 1B. The origin of the graph is (i) in the figure, and the X and Y axes are (ii) and (iii) in the figure.

(4) is a data changing means, which changes each data in the graph data storing means (3). Specifically, the user can specify the graph area and the graph origin position, etc. while looking at the screen on the CRT (2), and can set the above-mentioned origin position, X-axis length, Y-axis length, etc. It is configured to give a change instruction and change each physical data in the graph data storage means (3).

(5) is a data position designating means, which is means for storing output data of numerical data in a table to be converted into a graph.
Specify the position within (1). Specifically, the user is a CRT
(2) By designating the position of the numerical data in the output data storage means (1) while looking at the screen, the information P1 indicating the designated position is output.

(6) is a data search means, which is the data position specifying means
Numerical data is retrieved from the output storage means (1) based on the position designation information P1 sent from (5) and written in the data buffer (7).

(8) is an item name position specifying means, which specifies the position in the output data storage means (1) of the item name to be written in the graph. Specifically, the user specifies the position of the item name in the output data storage means (1) while looking at the CRT (2) screen, and outputs the information P2 indicating the specified position.

(9) is an item name search means, which searches the output data storage means (1) for an item name based on the information P2 sent from the item name position designating means (8) and stores the item name buffer. Write in (10).

(11) is a graph creating means, which is based on the physical data stored in the graph data storage means, and stores the data buffer in the graph area in the output data storage means (1).
Write a graph that displays the numerical data stored in (7).

Item name writing means (12) stores the item name buffer (10) in the output data storage means (1) based on the item name position data in the graph area of the physical data. Write the item name that is displayed.

The control of each of the above means is performed by a control means (not shown).

Next, the operation of the apparatus of this embodiment will be described based on a specific example.

Now, as shown in FIG. 3, on the CRT screen (20), a table having item names already created by a device such as a word processor or a personal computer and numerical data corresponding to the item names is displayed.
When (I) is displayed, first, when the item name position designating means (8) designates the item name position (hatched portion in the figure) in the above table, the item name searching means (9) Item names “A”, “B”, and “C” in the table are item name buffers (10)
Stored in. Then, when the data position designating means (5) designates the data position in the above table (indicated by a dotted line in the figure), the data retrieving means (6) designates the numerical data "18", "20" in the above table. , “10” is the data buffer (7)
Stored in.

When the respective data are stored in both the above buffers, first, the graph creating means (11) causes the graph data storing means (3)
Output data storage means based on the physical data of (1)
Write a graph optimized for, then item name writing means
Based on the item name position data by (12), the item name buffer (1
The item name stored in 0) is written in the output data storage means (1).

FIG. 4 shows a CRT screen after the above processing is completed. In the figure (21)
Is a graph area, and such an area is defined by an input from the data changing means (4).

In this embodiment, the data position designating means (5), the item name position designating means (8), the data changing means (4) and the like are individually provided, but they can be configured by one microcomputer. is there.

(F) Effect According to the present invention, when a graph is automatically created from a table created in advance based on the numerical data, the item name input when creating the table is transferred as it is as the item name of the graph. When creating a graph, you can effectively use the item names already entered in the table creation, and you do not have to enter the item name again.As a result, the table item name and the graph item name may not match due to incorrect input. To be prevented.

Further, in the present invention, a memory for writing the created graph
(1) is also used as the memory (1) that stores the table to simplify the configuration. Therefore, in the present application, the numerical data and item names in the table are searched from the display memory (1), and the graph created from this search result is displayed again in the display memory.
The graph is displayed by writing in (1).

[Brief description of drawings]

FIG. 1 is a schematic diagram for explaining the conversion from a table to a graph, FIG. 2 is a block diagram showing an embodiment of the present invention, and FIGS. 3 and 4 are schematic diagrams showing the operation of this embodiment. is there. (1) ... output data storage means, (3) ... graph data storage means, (9) ... item name search means, (11) ... graph creation means, (12) ... item name writing means.

 ─────────────────────────────────────────────────── ─── Continuation of the front page (56) Reference JP-A-57-52941 (JP, A) JP-A-59-178535 (JP, A) Practical application Sho-57-96489 (JP, U)

Claims (1)

[Claims] 1. A table-graph conversion device for creating a graph from a table having item names and numerical data corresponding to the item names, which is a means for storing display data corresponding one-to-one with a screen, Output data storage means (1) for storing at least the table as display data, item name search means (9) for searching the item name in the table from the output data storage means (1), and the output data storage means Data retrieval means (6) for retrieving the numerical data in the table from (1), and a storage area in the output data storage means (1) of the graph and a graph storing physical data such as its size A graph is written to the output data storage means (1) based on the data storage means (3) and the physical data in the graph data storage means (3) and the numerical data retrieved by the data retrieval means (6). Graph creating means (11) The output data storage means based on the physical data
An item name writing means (12) for writing the item name searched by the item name searching means (9) in (1).