JPH0620060A - Graph processing device - Google Patents

Abstract

PURPOSE:To inform an operator whether table data can be expressed by a graph or not by discriminating whether table data can be read or not to give a warning at the time visual output of table data. CONSTITUTION:Reference format data 8 used to discriminate whether a graph can be read or not is stored in a program memory 20. After range designation, a CPU 10 executes a graph selecting program 3 to accept the information of the indication of a graph form, the size of graph title printing, etc., inputted from an operator. Thereafter, the CPU 10 discriminates whether table data will be properly printed or not by a range discriminating program 4. If all of the designated range cannot be expressed by a graph because of the capability (the number of longitudinal/transverse dots) of a display device 70 or a printer 60 or the design of the graph, it is internally changed to an available maximum outputting range, and the CPU 10 uses a buzzer and/or a display message to inform the operator of the display error by a report program 5.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a graph processing device which graphs data based on table data.

[0002]

2. Description of the Related Art Conventionally, when displaying or printing table data created by a graph processing device or a document processing device having a graph processing function, the text created as table data is directly graphed or a table created in a document is displayed. The operator specified a specific range inside, and the text in the specified range was set as the target of graphing.

[0003]

However, in the above-mentioned conventional example, when the table data to be graphed is enormous, the display or printing becomes unreadable. For example, there are many line types that can not be read additionally in a line graph,
There are many divisions in a pie chart and many bars in a bar chart, which causes a problem such that the paint pattern for identifying them cannot be determined. For this reason, the operator has to repeatedly execute the trial and error of selecting the table data, displaying the graph, and printing, which complicates the operation of the operator involved in creating the graph.

Therefore, in view of the above-mentioned point, the object of the present invention is that the operator can know, before displaying or printing, whether the tabular data for which the graph is to be created can be represented by the graph. It is to provide a graph processing device.

[0005]

In order to achieve such an object, according to the present invention, a graph processing device for converting table data designated in advance into a graph and visually outputting the graph can read the visually outputted graph. Storage means for storing in advance information indicating the allowable range of the table data, and when the table data to be graphed is visually output in a graph, the result of the visible output is readable. It is characterized by further comprising: a determination means for determining whether or not the visible output is performed based on the information in the storage means, and a warning means for outputting a warning when the determination result of the determination means is a negative determination. And

Further, according to the present invention, in a graph processing device for converting preliminarily designated table data into a graph and visually outputting the information, information indicating an allowable range of the table data for making the visually output graph readable is provided. When the table means to be stored in advance and the table data to be graphed are visually output in the form of a graph, whether the result of the visible output is legible or not can be read based on the information of the memory means. The determination means for determining before output, and when the determination result of the determination means is a negative determination, the table data to be graphed is partially included so that it falls within the allowable range indicated by the information in the storage means. It is characterized by comprising information processing means to be integrated.

[0007]

According to the present invention, information indicating an allowable range of table data in which a visually output graph can be read is stored in the storage means in advance, and when the table data to be graphed is visually output. Based on this information, predictive judgment is made as to whether or not it will be readable. By issuing a warning or automatically correcting the table data based on the determination result, the operator can know whether or not the table data correction operation is necessary without displaying or printing the table data. . Moreover, the operator's operation is simplified by automatically making the correction.

[0008]

Embodiments of the present invention will now be described in detail with reference to the drawings.

FIG. 1 shows an example of a circuit configuration of an embodiment of the present invention.

In the figure, a central processing unit (CPU) 10,
Program memory 20, work memory 30, keyboard input device 40, floppy disk storage device (FDD)
50, the printing device 60, and the display device 70 are connected to a common bus.

The CPU 10 reads out various programs stored in the program memory 20 and executes calculations to perform graph creation processing, printing of created graphs, and display processing.

As will be described later, the CPU 10 operates as the judging means and the information processing means of the present invention.

The functions of the program stored in the program memory 20 are as follows.

Program 1 is a program for executing text editing or table data creation / editing.

The program 2 is a program for setting the range to be graphed from the table data created by the program 1.

The program 3 is a program for designating the shape of a graph to be displayed or printed, for example, a bar graph or a pie graph.

The program 4 is a program for determining whether or not the output result is legible when the table data to be graphed is set and the table data is graphed and visually output. is there.

The program 5 is a program for displaying the result of the determination executed by the program 4 on the display device 70.

Programs 6 and 7 are programs for displaying and printing the created graphs, respectively.

The program memory 20 further stores standard format data 8 used for determining whether or not the graph can be read.

The program memory 20 operates as the storage means of the present invention.

The work memory 30 stores table data and dot patterns of graphs to be created.

From the keyboard input device 40, the CPU 10
And the input data used when the above-mentioned various programs are executed.

The FDD 50 saves and stores the document text including the tabular data to be graphed.

An example of table data created by the table data editing program 1 is shown in FIG.

In the figure, C1, C2, C3, etc. indicate column division, and R1, R2, R3, etc. indicate line division. This tabulation example is tabulation data showing the sales of each product of Company A to Company P.

Such tabulation data is converted from FDD 50 to C
After being read by the PU 10 and displayed on the display device 70, the operator uses the keyboard input device 40 to instruct the CPU 10 to execute the range designation program. The operator uses the keyboard input device 40 to set the range of table data to be graphed. The CPU 10 identifies the range designated by the operator based on the range designation program, and displays the designated range in block form as shown in FIG. The range can be specified by specifying a block with a cursor or the like and specifying a column value and a line value.

After designating the range, the CPU 10 executes the graph selection program 3 and accepts information such as a graph shape instruction and a graph title print size input from the operator via the keyboard input device 40. After finishing the designation of the range and the selection of the graph, the CPU 10 determines the appropriateness of the print prediction for the table data by the range determination program 4 of FIG. At this time, the CPU 10 operates as the determination means of the present invention.

If the specified range cannot be converted into a graph due to the capability of the display device 70 or the printing device 60 (the number of dots in the vertical / horizontal direction) or the design of the graph, it is internally changed to the maximum outputable range. At this time, the CPU 10 uses the notification program 6 to notify the tabulator of the display error using a buzzer, a display message, or both. CP at this time
U10 and a buzzer (not shown) operate as the warning means of the present invention.

The information data of the confirmed range is stored in the designated range storage area in the work memory 30. The stored data may be range information composed of character codes, or image data for a graph obtained by converting the numerical data in the table data for display / printing based on the range information.

Based on these data, the CPU 10 executes display or print by the display or print programs 6 and 7.

In this embodiment, when the range is specified beyond the display / printing capability, the numerical data within the range is first graphed from the beginning. Then, the remaining data within the range are collectively calculated and summed to form a graph.

This process will be described with reference to FIG.
It is assumed that the table shown in FIG. 2 is created and the range is specified as shown in FIG. If the graph selection is a bar graph, it is assumed that the display device 70 has a limit on the number of columns and the number of lines as shown in the figure below.

Number of columns C1 C2 C3 C4 C5 C6 C7 C8 Number of lines 8 8 8 7 6 4 3 3 C9 C10 C11 C12 C13 C14 C15 C16 3 3 2 2 2 2 2 1 The CPU 10 determines the number of data in the table of FIG. , The number of columns is counted as 6 columns. Therefore, although the allowable number of lines is detected to be 4 or less from the reference table in the reference data 8, 6 lines are designated in the tabulation of the table.

The CPU 10 selects the allowable line number -1, in this case, the data A for the first to third lines of FIG. 4 and displays it as shown in the graph of FIG.

Since the data for the remaining one line can be displayed due to the display limitation, the CPU 10 integrates and sets the total sum of each column in the data B of the remaining three lines as one line data.

FIG. 6 shows the contents in which the data for three lines are collected as one line data. With respect to the new table data created in this way, the CPU 10 creates a graph on the work memory 30 and then displays it as shown in FIG.

The above-mentioned limit table of the number of columns and the number of lines is an example of the reference data 8, and in addition, the columns depending on the horizontal / vertical resolution of the display device or the printing device and the horizontal / vertical resolution of the printing device. The number of characters inside is determined. The contents of the range determination program 4 that executes the above processing are shown in FIG. 8 for reference.

In summary of the above example, when the range of l columns and m lines is designated as a range for a graph, when the CPU 10 determines that up to n lines can be displayed or printed in the case of 1 column from the restriction table, i) When m ≦ n, all m lines are treated as actual data and graphed.

Ii) In the case of m> n, up to n-1 lines are used as actual data, and the remaining m- (n-1) lines are summed in each column unit and reset to 1 line. Treated as "other" summary data.

That is, n lines are constructed by n-1 lines of actual data and 1 line of simplified data and are plotted in a desired graph. The graph scheme is applicable to all graphs, not just bar graphs.

In addition to this embodiment, the following examples can be given.

1) Before executing the range specification process 2 of the table data for graphing, by selecting the graph, the graph is confirmed, and the visible output range is displayed during the range specification process. You can also

For example, when a bar graph is selected in the graph selection process, a graphable range is illustrated according to the column and line restriction table described in the above embodiment. In addition, if the column range of the block is specified only when it is within the allowable range, it is possible to block up to the number of lines according to the specified range.

A concrete description will be given using numerical values. In the table as shown in FIG. 2, when the sixth column C6 is designated as the block column, the fourth line can be displayed from the restriction table. Therefore, the width specified by the line is 4 + α (α is the display /
It is an arbitrary value depending on the printing device) and 4 + α = m. A block is completed with a maximum of m lines, and thereafter, a block with 6 columns and m lines may be processed in the same manner as in the above embodiment.

2) By starting the editing program 1 after the end of the range designation of this embodiment so that the order of each line is switched, even if the allowable range is exceeded, the desired line is individually output. You can for that purpose,
It suffices to determine the operation of graphing execution after specifying the range and perform the processing as an edit screen accompanied by other block display.

3) After the range designation is completed, the actual data portion and the informal data portion are separately displayed by a specific key operation. For example, only the simplified data part is changed to halftone or the display is changed. This allows the operator to confirm that the array is unintended before graphing,
It is possible to re-edit without unnecessary display / printing,
The same effect can be obtained.

4) By providing a key operation for moving the abbreviated data display after displaying the actual data and the abbreviated data separately, it is possible to change the abbreviated data without replacing the lines, and the same effect as the above embodiment. Is obtained.

[0049]

As described above, according to the present invention, table data exceeding the allowable range can be known before being graphed. Therefore, it is necessary to confirm the graph by visual output as in the conventional case. There is no. Further, the table data to be graphed is automatically corrected to the table data within the allowable range, so that the operation of the operator is simplified.

[Brief description of drawings]

FIG. 1 is a block diagram showing a circuit configuration of an embodiment of the present invention.

FIG. 2 is an explanatory diagram showing an example of table data according to an embodiment of the present invention.

FIG. 3 is an explanatory diagram showing an example of range designation according to an embodiment of the present invention.

FIG. 4 is an explanatory diagram showing an example of range designation according to an embodiment of the present invention.

FIG. 5 is an explanatory diagram showing a graphic that is a graph of table data according to the embodiment of the present invention.

FIG. 6 is an explanatory diagram showing a graphic that is a graph of table data according to an embodiment of the present invention.

FIG. 7 is an explanatory diagram showing corrected table data according to the embodiment of the present invention.

8 is a flowchart showing the contents of a determination process executed by the CPU 10 of FIG.

[Explanation of symbols]

 10 CPU 20 Program Memory 30 Work Memory 40 Keyboard Input Device 50 FDD 60 Printing Device 70 Display Device

Claims (2)

[Claims] 1. A graph processing apparatus for converting predesignated table data into a graph and visually outputting the graph, wherein information indicating an allowable range of the table data for making the visually output graph readable is stored in advance. A storage means to be placed and, when the table data to be graphed is visually output in a graph, whether or not the result of the visible output is legible is determined based on the information in the storage means before the visible output. A graph processing device comprising: a determination unit for determining and a warning unit for outputting a warning when the determination result of the determination unit is a negative determination. 2. A graph processing device for converting predesignated table data into a graph and visually outputting the graph, wherein information indicating an allowable range of the table data for making the visually output graph readable is stored in advance. A storage means to be placed and, when the table data to be graphed is visually output in a graph, whether or not the result of the visible output is legible is determined based on the information in the storage means before the visible output. Judgment means for judging and information processing for partially integrating table data to be graphed so that if the judgment result of the judgment means is a negative judgment, it falls within the allowable range indicated by the information of the storage means. A graph processing device comprising: means.