JP2682418B2 - Graph display processing method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a graph display processing method, and in particular, stores numerical data, character data, arithmetic expression data and graph functions in a table format on an electronic sheet of a memory and outputs a table and a graph. The present invention relates to a graph display processing method.

[0002]

2. Description of the Related Art Conventionally, in this type of graph display processing method,
Numerical data, character data, arithmetic expression data and graph functions in a table format are stored on an electronic sheet of a memory, and a table and a graph are output by inputting the table format data.

An example of a conventional graph display processing method is described in "Japanese Patent Laid-Open Publication (A) Showa 60-142776 (Simple Language Processing System)".

This conventional example will be described with reference to the drawings.

FIG. 6 is a block diagram of a system to which this conventional example is applied. In FIG. 6, this application example includes a display device 1, a central processing unit 2, a keyboard 3, and a memory 4, the memory 4 has an electronic sheet 4a, and the display device 1 displays a table 5. .

FIG. 7 is a diagram showing an example of an electronic sheet stored in the memory shown in FIG. In FIG. 7, 1, 2, 3, ... In the left column are the row numbers of the electronic sheet, A, B, C, E in the top row are the column names of the electronic sheet, and character data is Tokyo, Osaka, Fukuoka, Kanazawa, etc. , 2, 2, 1, 3, ... are numerical data, @SUM (B2: B5) is an arithmetic expression, @G
RAPH (B, A6, B6: E6 etc. are graph functions, @
GXS (B1: E1) and the like indicate graph auxiliary functions.

FIG. 8 is a diagram showing a processing flow of a graph function in this conventional example. When the operator designates the item frame in which the graph function is stored from the keyboard 3 and gives an instruction to start the execution, the graph display processing according to the designated type of the graph is performed.

FIG. 9 is a diagram showing a graph display process in the case of a bar graph in this conventional example. FIG. 10 is a diagram showing an output example of a bar graph created by the graph display process shown in FIG.

Depending on the graph display processing, the numerical value of each data may be output on the created graph, which is a general function. FIG. 11 is a diagram showing an example of a graph in which numerical values of respective data are displayed on the bar graph of FIG.

[0010]

In the above-mentioned conventional graph display processing method, since the numerical position of each data is determined for each element of the graph as shown in FIG. 11, each element of the graph is complicated. When it is displayed, there is a problem that the numerical values of each data may be overlapped, making it unreadable.

[0011]

According to the graph display processing method of the present invention, numerical position information corresponding to the plurality of data is stored in a plurality of tabular data stored in advance on an electronic sheet in a storage device. It comprises an input means for inputting and a display processing means for displaying numerical data corresponding to the plurality of data on the graph display according to the numerical value position information of the previous period after the predetermined graphical display of the plurality of data. .

[0012]

Next, the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an example of a system to which an embodiment of the present invention is applied.

In FIG. 1, the system of this application example displays a keyboard 3 for inputting numerical position data and the like, a memory 4 for storing the program of this embodiment and having an electronic memory 4a, and various graphs and tables. And a central processing unit (CPU) that executes the graph display processing of this embodiment and controls the entire system of this application example.
It is configured with 2 and.

FIG. 2 is a diagram showing an example of an electronic sheet stored in the memory shown in FIG.

In FIG. 2, 1, 2, 3, ... In the leftmost column are row numbers of the electronic sheet, A, B, C, ... In the uppermost column are column names of the electronic sheet, Tokyo, Osaka, Fukuoka, Kanazawa, etc. Is character data, 2, 2, 1, 3, ... are numerical data, @SUM
(B2: B5) is an arithmetic expression, @GRAPH (B, A6,
B6 :) and the like indicate graph functions, @GXS (B1: E1) and the like indicate graph auxiliary functions, and LP (B2) and the like indicate “numerical value position information” for outputting numerical values for each element. On the display screen of the display device 1, from the table shown in FIG.
The one without the graph auxiliary function and numerical position information is displayed.

The graph function has a format such as @GRAPH (C, A2: A5, E2: E5), where C indicates the type of graph,
A2: A5 indicates the data type range, and E2: E5
Indicates the data range.

The graph auxiliary function has a format such as @GXS (E1), where E1 indicates the data display range. When the graph auxiliary function relates to a pie chart, the data range indicates the data displayed in the center of the circle, and in other graphs, the data displayed on the X axis.

"Numerical position information" L which is a feature of this embodiment
P is numerical data such as 2, 2, 1, 3, ... Of the electronic sheet 4a, data existing corresponding to each arithmetic expression such as @SUM (B2: B5), or input as a numerical value from the keyboard by the operator. To be done.

FIG. 3 is a diagram showing a processing flow of a graph function in this embodiment, FIG. 4 is a diagram showing a bar graph editing process according to this embodiment, and FIG. 5 is a diagram showing a bar graph processing result according to this embodiment.

Next, the processing procedure of this embodiment in the system of this application example will be described with reference to FIGS.

When the operator designates the item frame in which the graph function is stored from the keyboard 3 and gives an instruction to start the execution, the following processing is performed.

S11: Check whether the graph type is C or not. If Yes, the process of S12 is performed, and if No, the process of S13 is performed.

S12: Edit processing of the pie chart is performed.

S13: Check whether the graph type is B or not. If Yes, the process of S14 is performed, and if No, the process of S15 is performed.

S14: The bar graph is edited.

S15: Check whether the graph type is L or not. If Yes, the process of S15 is performed, and if No, the next graph type process is performed.

S16: The line graph is edited.

S17: When the judgment of all graph types and the graph editing are completed, the graph is displayed on the display device 1 by using the result of the graph editing.

In FIG. 4, the bar graph display processing is as follows.

S21: Obtain maximum data from the data range.

S22: The maximum scale for displaying the maximum data is determined.

S23: The number of bars is calculated from the number of data and the display position is calculated.

S24: The X-axis and the Y-axis are drawn to draw a graph according to the data value.

S25: Write the data indicated by the data type in the upper right.

S26: Check whether there is a graph auxiliary function. If Yes, the process of S28 is performed. If No, another process is performed, and the process returns to S26.

S27: Check whether it is GXS. If Yes, the process of S28 is performed, and if No, another process is performed.
Return to S26.

S28: Numerical position information data L of each data
A numerical value is output with reference to P. By the above processing, @ GRAPH = (B, A2, B6: E6), @ GS
When X = (B1: E1), the bar graph shown in FIG. 5 is output to the display device 1.

As shown in FIG. 5, the numerical display is displayed more easily than before.

[0040]

As described above, according to the present invention, when it is desired to specify the position of the numerical value corresponding to each element of the graph, the "numerical value position information" existing for each element on the electronic sheet.
By operating the LP and outputting the graph by the graph display process, the position of the numerical value can be specified for each element, making it easy to read the numerical values of the data even when the elements of the graph are displayed intricately. The effect is that it can be displayed.

[0041]

[Brief description of the drawings]

FIG. 1 is a block diagram showing an example of a system to which an embodiment of the present invention is applied.

FIG. 2 is a diagram showing an example of an electronic sheet stored in a memory in FIG.

FIG. 3 is a diagram showing a processing flow of a graph function in the present embodiment.

FIG. 4 is a flowchart showing a bar graph editing process in this embodiment.

FIG. 5 is a diagram showing a bar graph processing result according to the present embodiment.

FIG. 6 is a block diagram showing an example of a system to which a conventional example is applied.

7 is a diagram showing an example of an electronic sheet stored in a memory in FIG.

FIG. 8 is a diagram showing a processing flow of a graph function in a conventional example.

FIG. 9 is a flowchart showing a bar graph editing process in a conventional example.

FIG. 10 is a diagram showing an output example of a bar graph created by the graph editing process shown in FIG. 9.

11 is a diagram showing an example in which numerical information is output on the bar graph of FIG.

[Explanation of symbols]

 1 display device 2 central processing unit (CPU) 3 keyboard 4 memory 4a electronic sheet 5 table on display screen

Claims (1)

(57) [Claims] 1. An input unit for inputting numerical position information corresponding to a plurality of tabular data among a plurality of tabular data stored in advance on an electronic sheet in a storage device, and a predetermined one of the plurality of data. And a display processing means for displaying numerical data corresponding to the plurality of data on the graph display according to the numerical position information of the previous period after the displayed graph.