JPH0619891A - Graph processor - Google Patents

Abstract

PURPOSE:To facilitate specifying of data desired by an operator by displaying the allowable value of number of data pieces in the shape of a graphic pattern. CONSTITUTION:FDD 50 keeps/stores a document text including table data to be the object of making a graph. After CPU 10 reads the table making data from FDD 50 and displays it at a display position 70, the operator instructs CPU 10 to execute a limit specifying program 2 from a key board input device 40. After specifying the limit, CPU 10 executes a graph selection program 3 and receives the indication of a graph shape inputted from the operator through the key board input device and information such as the size of graph title printing. After finishing the specifying of the limit and the selection of the graph, CPU 10 judges classification concerning printing prediction with regard to table data by a limit judgement program 4. Information data in the established limit is stored in a storage area within a work memory.

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, the present invention relates to a graph processing apparatus for designating data to be graphed from created table data. Storage means for storing the allowable number of data, input means for designating a graph by inputting information indicating the position of the data, display means for sequentially displaying the input information, and the input Prior to the input from the means, in association with the display position of the information on the display means, by the number indicated by the number of data in the storage means,
Display control means for displaying a specific graphic pattern.

[0006]

The present invention focuses on the fact that the information designated and input by the operator is often displayed on the display means in the graph processing device, and the number of data permitted to be graphed is set to the specified figure pattern. Notify by the number of items displayed. Further, by displaying the specific graphic pattern in association with the display position of the instruction information, the operator can know that the number of designated data has reached the allowable number.

[0007]

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 performs arithmetic operations to perform graph creation processing, printing of created graphs, and display processing.

As will be described later, the CPU 10 operates as 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.

Program 2 is a program for setting the range to be graphed from the table data created by 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 readable 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 work memory 30 stores table data and dot patterns of graphs to be created.

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

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

An example of the 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 FDD50 to C
After being read by the PU 10 and displayed on the display device 70, the operator instructs the CPU 10 to execute the range designation program 2 from the keyboard input device 40. The operator uses the keyboard input device 40 to set the range of table data to be graphed. CPU10 has range designation program 2
Based on the above, the range designated by the operator is identified, and the designated range is displayed 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 receives 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, the internal range is 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.

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 displays or prints by the display or print programs 6 and 7.

In this embodiment, the table as shown in FIG. 2 is completed,
When the operator instructs the graphing operation from the keyboard input device 40, the graph selecting program 3 is started in the CPU 10.

As a result, the graph selection as shown in FIG. 4 is displayed on the display screen of the display device 70. The operator uses the keyboard input device 40 to key in a number indicating the desired graph type.

For example, a case where a bar graph is selected will be described.

After the graph type is designated, the execution procedure of the CPU 10 shifts to the range designation program 2 in FIG.

In this program, restriction data for table data for each graph type as shown in FIG. 5 is described. This limited data represents the maximum allowable number of columns and the number of lines of table data that can be read when graphing. Therefore, the program memory 20 which stores this program operates as the storage means of the present invention.

The CPU 10 reads out the column limit value 5 and the line control value 4 for the selected graph type, and initializes the count value I of the designated number of columns and the count value J of the designated number of lines J to "0" (FIG. 11 step S10).

Next, the table data to be graphed (see FIG. 2) and the column symbol input frame (specific graphic pattern of the present invention) are displayed on the display screen as shown in FIG. 6 (step in FIG. 11). S20). In this embodiment, column input frames are provided in the same number as the above limit value. CPU at this time
10 operates as the display control means of the present invention.

Next, the column symbol to be graphed is accepted from the keyboard input device 40 (step S30 in FIG. 11). The keyboard input device at this time operates as the input means of the present invention.

The CPU 10 counts the number of designated columns each time a column symbol is input (step S40 in FIG. 11).
If the number of designated columns is equal to or less than the allowable limit value, the table data of the column designated by a thick line frame is enclosed in a display form indicating that the column is within the allowable limit value, and the operator is notified of the designated column (step of FIG. 11). S60). Further, the designated column is temporarily stored in the work memory 30 (step S70 in FIG. 11).

In this way, the CPU 10 repeatedly executes the loop processing of steps S30 to S80 until the operator gives an instruction to end the input of the column data, and displays and stores the column designated by the operator. FIG. 7 shows a display example when five columns are designated.

On the other hand, when the column designation number I exceeds the allowable limit value, a message to that effect is displayed and a warning is issued (steps S50 → S90 in FIG. 11). Next, the CPU 10 accepts an operator's instruction to end the input or to redo (step S100 in FIG. 11).

When the input is completed, the column selection processing is completed and the line designation processing is started. In the case of re-designation, the procedure is returned to step S10, the above-mentioned processing procedure is restarted, and the designation of the column is performed again from the beginning.

The line designation process is performed in steps S30 to S11.
The processing is the same as that of 0, and the column may be read as a line, and detailed description thereof will be omitted in this embodiment. For reference, FIG. 8 shows a display example when the column designation and the line designation are completed.

Thereafter, the CPU 10 extracts the column data (see FIG. 9) determined by the designated column and line position designation from the tabulated data as the data for graphing as in the conventional case, and executes this control procedure. The process ends (step S200 in FIG. 11).

When the graph tabulated through the range designation processing of FIGS. 8 and 9 is output, the output result as shown in FIG. 10 is obtained.

Besides the present embodiment, the following examples can be given.

1) Instead of the column designating method of this embodiment, the following designating method may be used. That is, after selecting the graph format, the designated area by the column and line symbols as shown in FIG. 6 is displayed and the column and line are designated by the next operation instead of inputting.

For example, after selecting a graph, the column symbol "C
The first column C1 in the area displaying "1 to Cn" is highlighted, and when confirming the designation of the column C1, the enter key is pressed to change the column row to inverted or halftone display. indicate.

Then, the process proceeds to the next C2. If no column is specified, the move key (→, ←, TAB key, backspace key, etc.) is used to move to the target column. Further, according to the restriction table of FIG. 5, if the number of columns to be confirmed by a specific decision key exceeds the restricted column number “5”, it is regarded as an error and the operator is notified by an alarm or a message as in the present embodiment. is there. Then, when the vertical movement key (↑, ↓, screen scroll key, screen scroll key, etc.) is input, the column designation is terminated and the line designation processing is performed. Similarly to the column designation, the area displaying the line symbols (R1 to Rn) is highlighted, the vertical movement key is used to move to the target line, and the designation of the line is completed by the specific enter key.

2) In the present embodiment, the designation of the column and line to be graphed is confirmed, and after the graph is displayed, the operator judges that the graph format is not optimum, and the key operation for returning to the range designation screen of FIG. 8 again. Will be described, and the graph selection program will be activated on the display screen of FIG. 8 to change the graph format.

When the changed graph format is confirmed, the range designation function changes and displays the already set range designation display in real time in the changed graph format in accordance with the restriction table of FIG.

For example, when the pie chart is changed to a bar chart, the pie chart is designated by 6 columns and 5 lines and is displayed in reverse video. The changed bar graph is
Since it is limited to 5 columns and 4 lines, the reverse display is continued from the smallest column number and the smallest line number. If columns and lines that are out of the range occur when expressed in the changed bar graph, the area is expressed by another display method that is distinguished from reverse display, for example, shaded display, halftone display, etc. Notify the operator.

Further, a specific operation is provided to permit change and cancellation of the designated column and designated line.

By the above procedure, the range of the table data is fixed, and it is possible for the operator to simplify the re-designation of the desired column and line and to eliminate unnecessary operations.

3) According to the restriction table of FIG. 5, the CPU 10 sets column C2, line R1, column C3, line R2 with (column C1, line R1) as the start position.
In this order, the effective columns and lines are notified in advance by reverse display or halftone display, and the input areas of the designated columns and lines in FIG. 6 are initialized according to the above display. It is also displayed as an initial display of valid data supplied by the graph function. Next, the operator may give a desired column instruction by deleting or moving the currently designated column. In this case, when the operator desires the same designation as the designated designation column and line in the initial setting, it is sufficient to perform the graphing operation without performing the range designation operation, and the operation can be further shortened.

Furthermore, it goes without saying that when the effective range designation position that is initially displayed is changed, the display of the designated range is followed.

[0056]

As described above, according to the present invention,
When specifying table data by position specification such as column specification and line specification, by displaying the allowable value of the number of data in the form of a graphic pattern, the operator can specify the desired data without excessive specification of the range. There is an effect that it becomes easier and can be graphed with the richest expressive power within the expressive power of the display device or the printing device.

[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 creation table data according to an embodiment of the present invention.

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

FIG. 4 is an explanatory diagram showing an example of a menu for selecting a graph type according to the embodiment of this invention.

FIG. 5 is an explanatory diagram showing an allowable value of the number of data for each graph according to the embodiment of the present invention.

FIG. 6 is an explanatory diagram showing contents of a display for data designation according to the embodiment of the present invention.

FIG. 7 is an explanatory diagram showing contents of a display for data designation according to the embodiment of the present invention.

FIG. 8 is an explanatory diagram showing contents of a display for data designation according to the embodiment of the present invention.

FIG. 9 is an explanatory diagram showing contents of designated data in the embodiment of the present invention.

FIG. 10 is an explanatory diagram showing a graph output example of the data of FIG. 9;

11 is a flowchart showing a processing procedure for data designation executed by the CPU 10 of FIG.

[Explanation of Codes] 10 CPU 15, 50 FDD 20 Program Memory 30 Work Memory 40 Keyboard Input Device 60 Printing Device

Claims (1)

[Claims] 1. A graph processing device for designating data to be graphed from created table data, comprising: a storage unit that stores the number of data allowed for graphing; and information that indicates the position of the data. Input means for designating a graph by inputting, display means for sequentially displaying the input information, and a display position of the information on the display means prior to input from the input means. A graph processing apparatus, further comprising: display control means for displaying a specific graphic pattern in a number corresponding to the number of data in the storage means.