JPH05205064A - Graph output device - Google Patents

Abstract

PURPOSE:To output a compact and well-balanced graph even when the variation amounts of numerical data by elements are large. CONSTITUTION:The variation states of numerical data by elements stored in a numerical file 16-2 are analyzed by a CPU 11 and based on this analyzed result, a numerical range for omitting making into a graph is decided and set to an omitted numerical range memory 18. Then, the CPU 11 makes the numerical data by elements in the numerical file 16-2 into the graph and when arranging it in a page memory 20, making into the graph in the omitted numerical range is omitted while referring to contents in the omitted numerical range memory 18.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a graph output device for outputting numerical data by element as a graph such as a bar graph and a line graph.

[0002]

2. Description of the Related Art Generally, in an office computer or the like, for example, when preparing a sales performance report by sales office,
I am trying to insert a graph into the document, but in this case, secure the graph insertion area in advance when creating the document,
After creating the document, the sales data for each sales office is graphed and inserted into an area reserved in advance. For example, when the monthly sales totals for each of the sales offices A, B, C, ... F are represented by a bar graph, if only the sales office C has an extremely large amount of sales compared to other sales offices, or only the sales office C has another sales. Sales may be extremely small compared to other offices.

[0003]

If the sales amount is extremely high or low even in this way, the balance of the entire graph is lost and the readability is deteriorated. When the step width) is constant, there is a large gap between the upper limit value and the lower limit value of the scale step value, and there is a drawback that the graph becomes larger accordingly. An object of the present invention is to make it possible to output a compact and well-balanced graph even if the amount of shift between the numerical data for each element is large.

[0004]

The means of the present invention are as follows. The analysis means is a CPU or the like that analyzes the transition state of the numerical data for each element, and for example, analyzes whether or not even one numerical data is extremely large or small as compared with other numerical data. The determining means is a CPU or the like that determines a numerical range for omitting graphing based on the analysis result by the analyzing means. The output control means omits the graphing within the numerical range determined by the determining means when the numerical data for each element is graphed and output.

[0005]

The operation of the means of the present invention is as follows. Now, when plotting a plurality of elemental numerical data, the analyzing means analyzes the transition state between the elemental numerical data. As a result, as shown in FIG. 4B, when one numerical value is extremely larger than the other numerical values, the determining means sets the numerical range OM for omitting the graphing based on the analysis result by the analyzing means. decide. Then, the output control means omits the graphing within the numerical range OM determined by the determining means when the elemental numerical data is graphed and output. As a result, in the graph shown in FIG. 4B, the middle part of the line representing an extremely large numerical value is omitted as shown in FIG. 4C. Therefore, it is possible to output a compact and well-balanced graph even if there is a large amount of transition between the numerical data for each element.

[0006]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment will be described below with reference to FIGS. FIG. 1 is a hardware block diagram showing the configuration of the graph output device. The CPU 11 controls the overall operation of the graph output device in accordance with various programs stored in the ROM 12, and the input unit 13, the CRT display unit 14, the printing unit 15, and the disk device 16 are connected to the CPU 11 as peripheral devices. , Control their I / O operations.

The input unit 13 is a key input device for inputting document data and numerical data. The data input from the input unit 13 is displayed on the text screen of the CRT display unit 14 or stored in the disk unit 16. .. Here, for example, the document data input from the input unit 13 in order to create the sales performance report by sales office is stored in the document file 16-1, and the numerical values for each element for creating a graph to be inserted into this document. When the data (sales data by sales office) is input from the input unit 13, the numerical data by element is the numerical file 16
-2 is stored.

The table work memory 17 graphs a plurality of element-specific numerical data stored in the numerical file 16-2 and outputs them together with the scale step values.
This table work memory 1 is used by the CPU 11 to analyze the transition state between element-wise numerical data.
As a result of analyzing the data in 7, the numerical range for simplifying the graphing is determined based on the data, and is set in the omitted numerical range memory 18. Based on the setting contents of the abbreviated numerical value range memory 18, the CPU 11 determines the step value of the scale including the abbreviated numerical value range when determining the step value of the scale within the other numerical value range excluding this abbreviated numerical value range, It is set in the step value memory 19.

The page memory 20 stores print data for one page. When inserting a graph into a document,
A graph insertion area is secured in the page memory 20, and the created graph is inserted in this area. In this case, the CPU 11 omits the graphing within the numerical value range set in the omitted numerical value range memory 18 and places an omission mark (two parallel wavy lines) in the corresponding portion of the page memory 20. Further, when the numerical data for each element is graphed, the CPU 11 arranges in the page memory 20 the graph data of the scale size corresponding to the step value of the scale set in the step value memory 19.

Next, the operation of this embodiment will be described. FIG. 2 is a flowchart showing the operation when outputting a graph. Now, it is assumed that the sales data by sales office shown in FIG. 3A is graphed and output as the numerical data by element in the numerical file 16-2. First, in step S1, the maximum numerical value of the numerical data for each element shown in FIG. 3A is checked. In this case, sales data of sales office C (70
0) is the maximum value, and the table of the numerical range obtained by dividing the maximum value into seven is developed in the table work memory 17 (step S2). In this case, if the value of "700" is divided into 7,
"0"-"100"-"200"-"300"-"40"
It becomes a numerical value range of "0"-"500"-"600"-"700", and when this is expanded in the table work memory 17, it becomes as shown in FIG. Here, as shown in FIG. 3B, a table having a configuration in which numerical values for specifying a numerical range are arranged on the horizontal axis of the table work memory 17 and each element is arranged on the vertical axis is developed.

Next, the process proceeds to step S3, and FIG.
Numerical data for one element of the numerical data for each element shown in (1) is read out, and bit "1" is set in the table work memory 17 in all areas corresponding to the numerical range to which this numerical data belongs (step S4).
In this case, the numerical data for each element at the head is “70” and “1”
Since it belongs to the numerical range less than "00", the bit data of "1" is set only in the area (see (B) of FIG. 3). Then, in step S5, it is checked whether or not there is another element, and if there is another element, the process returns to step S3 and is repeated until the above table creation processing is completed for all the elements. As a result, as shown in FIG. 3B, the bit data of "1" is set in the area of all the numerical range to which the numerical data for each element belongs.

When the table creating process as described above is completed, the contents of the table work memory 17 are analyzed and the number of bit data of "1" is obtained for each numerical range (step S).
6). In this case, as shown in FIG. 3B, when the numerical value range is less than "100", the bit data of "1" is set in all elements, so the value becomes "6", Further, in the case of the numerical range "100" to "200", it is "3", and in the case of other numerical ranges, it is "1". Then, the numerical range in which the number of bits is the same is checked (step S7). As a result, it is checked whether three or more numerical ranges are continuous (step S8).

In the case shown in FIG. 3B, since three or more numerical value ranges having the same number of bits are consecutive, the process proceeds to step S9, and the upper end of the numerical value range having the same bit number is reached. The range excluding the numerical range of is determined as the omitted numerical range (the range in which graphing is omitted), and the omitted numerical range memory 18
Set to. In this case, since the numerical range at the upper end is "700", the omitted numerical range is "300" to "600".

When the default numerical value range is determined in this way, the scale step value corresponding to the graph insertion area on the page memory 20 is determined within the numerical value range excluding the default numerical value range (step S10). .. In this case, the range of numerical values excluding the omitted numerical value ranges "300" to "600" is "300", and the scale pitch (1
Calculate the step size for the scale. Here, when the scale pitch "50" is obtained, each step value "5" is obtained based on this.
0 "," 100 "," 150 "," 200 "," 65 "
“0” and “700” are determined and set in the step value memory 19. Then, the scale step value in the step value memory 19 is arranged in the graph insertion area on the page memory 20 excluding the omitted numerical range (step S11).

Next, in step S12, numerical data for one element of the numerical data for each element is read from the beginning, and the numerical data for one element is read based on the scale arranged in the graph insertion area in the page memory 20. Is converted into a bar graph and placed in the graph insertion area (step S13). Then, it is checked whether there are other elements (step S1).
4) If so, the process returns to step S12, and the above operation is repeated until all the elements are graphed and arranged in the graph insertion area. When all the elements are graphed by this, the process proceeds to step S15, and the omitted wavy lines (two parallel wavy lines) are arranged in the part of the omitted value range in the graph insertion area of the page memory 20. As a result of the determination in step S8, if three or more numerical value ranges in which the number of bits is the same are not continuous, the process proceeds to step S6, and the numerical data for each element is graphed as usual and the insertion area of the page memory 20 is processed. Place inside.

When the graph is inserted into the document stored in the page memory 20 in this manner, the contents of the page memory 20 are printed out from the printing section 15.
FIG. 5A shows an example of printing in this case, and a bar graph is inserted in the sales performance report by sales office. A part of this bar graph is shown in FIG. 4C. It will be omitted. Here, (B) of FIG. 4 is (A) of FIG.
An output example is shown in which the numerical data for each element shown in is graphed by a method similar to the ordinary method. Only the line of element C is extremely long, and other elements A, B, D, E and F are shown.
Each of them is short and their lengths are very slight, so that they are unbalanced as a whole and their readability is poor. On the other hand, in the graph shown in FIG. 4C, the graphing in the omitted numerical value range OM shown in FIG. 5B is omitted, and the scale pitch is within the numerical value range excluding the omitted numerical value range. Is so large that element A,
The amount of shift between B, D, E, and F becomes large, the readability is improved, and the balance of the entire graph is improved.

In the above embodiment, the omitted numerical value range is provided only at one place, but it may be provided at a plurality of places. FIG. 5 shows an example in which two omitted numerical value ranges are provided. Further, although the standard scale bar graph is given as an example in the above embodiment, a log scale bar graph, a stacked bar graph, a line graph or the like may be used.

[0018]

According to the present invention, it is possible to output a compact and well-balanced graph even if there is a large amount of shift between the numerical data for each element, so there is no need to edit the graph later, and sales results It is possible to efficiently create reports and the like.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a graph output device according to an embodiment.

FIG. 2 is a flowchart showing an operation when outputting a graph.

FIG. 3A is a diagram showing a concrete example of numerical data for each element in the graph creating process, and FIG. 3B is a diagram showing table contents developed in a table work memory 17 based on the numerical data for each element.

4A and 4B show examples of graph output, where FIG. 4A is a diagram showing a state in which a graph is inserted in a document, and FIG. 4B is a graph showing the numerical data for each element shown in FIG. FIG. 3C is a converted output state diagram, and FIG. 3C is an output state diagram when a part of the numerical data for each element shown in FIG.

FIG. 5 is a diagram showing another example of graph output.

[Explanation of symbols]

 11 CPU 12 ROM 14 CRT display section 15 Printing section 16-2 Numerical value file 17 Table work memory 18 Omitted numerical value range memory

Claims (1)

[Claims] 1. A graph output device for graphing and outputting a plurality of elemental numerical data, and analyzing means for analyzing a transition state between elemental numerical data, and graphing is omitted based on an analysis result by the analyzing means. Determining means for determining the numerical range for the purpose, and output control means for omitting graphing within the numerical range determined by the determining means when the numerical data for each element is graphed and output. A graph output device.