JPS61134832A - Automatic calculation program for scale in production mode of graph or the like - Google Patents

Abstract

PURPOSE:To increase the program processing speed in a graph production mode by calculating the number of sections of a coordinate axis based on the obtained maximum value of the input data and the unit of said maximum value and displaying the numerical value of the data after deciding the unit to be displayed on the graph. CONSTITUTION:The maximum value is obtained from the input data with an automatic calculation program of scales in a graph production mode. This obtained maximum value is divided successively by the multiples of 10, and 1/10 of the multiple of 10 is obtained (omitting decimals) when the result of said division is equal to zero. Thus a unit T of the maximum value is decided, and the number of sections (X) is decided by an equation X=(maximum value +T)/T with a coordinate axis. The value X is set at >=5 and T=T/2=T/5 is satisfied with the value X set at <=5. The units P (Yen1, Yen1,000, Yen10,000-) are obtained for graph display from the obtained maximum value. Then the scale of the coordinate axis is obtained from Y=A/P (Q: T, T/2 or T/5). Finally the graph is displayed on a CRT.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a device for graphing data collected from input or files in an application program or the like and displaying the graph on a CRT screen.

[Conventional technology]

Application programs often create graphs to compare and analyze various data handled in the program.

However, since creating a graph generally takes time in terms of programming, it is desired that data be easily graphed.

[Problem that the invention seeks to solve]

Conventionally, it was necessary to consider a method for calculating graph scales, units, etc. for each program, which had the drawback of requiring time and effort.

[Means for solving problems]

When creating a graph, etc., the present invention calculates how many divisions the coordinate axes of the graph should be divided into based on the maximum value found from the input data and the unit of this maximum value, and displays it on the graph. It is characterized by determining the unit, calculating the data on the coordinate axes, and creating a graph.

[For production]

When creating a graph, the maximum value is determined from the input data, and the unit of this maximum value is determined.

In other words, divide the maximum value by multiples of lO in order, and when the answer becomes Φ (round down the decimal places), it is 1/1 of the multiple of lO
Let 0 be T, which is the unit of the maximum value. These things,
Decide how many divisions the coordinate axes should be divided into, and if this number is tx, the calculation formula will be X2 (maximum value + T)/T. Here the value X
is set to be 5 or more, so if it does not meet this, T
Calculate with a value of /2. Even in this case, if it is not considered to be 5, calculation is performed using the value of T15.

Next, decide on the units for displaying the graph. Depending on the maximum value, this is "yen", 1,000 yen', 10,000 yen', 1 child's yen', 100 million yen'
I can understand. Here, the unit of this graph display is set to Q, especially when the value .

FIG. 1 is a flowchart of a program for automatically calculating scales when creating a graph. (1) shows data input 2 in the application program.

In (2), the maximum value is calculated from the data input in (1). Using this maximum value, the number of digits is calculated in (3), and the graph display unit, scale, etc. necessary for graph creation are calculated in (4). And (5
), the graph is actually created on the CRT screen. The present invention mainly performs processes (2) to (4).

FIG. 2 is a graph of the data in Table 1 shown below in accordance with the present invention.

In this embodiment, first, the maximum value is found from the data in this table.

First, a LOW-VALVE value is set, this value is compared with the first data, and the larger value is compared with the next data in order, and this is repeated for all data. And finally ask for the maximum value. Here, the maximum value MAX = t 5,800,000.

Here, if the maximum value MAX is less than 4 (MAX < 4), the graph display unit is unconditionally 1 yen, the coordinate axis is divided into 5 parts, and 0.1.2.3.4 from the origin. It is determined to be .5. If it is 4 or more, check the unit for this maximum value. This is checked using a multiple of 10. First, divide the maximum value box by lO.

It is determined whether this result is Φ (round down to the decimal point), and if it is not Φ, the maximum value ■ is further divided by 100 and the result is determined. Then, multiply the number to be divided by 10 and repeat until the result is Φ.If MAX = 15,800,000, then 15,80
0. When OOO+100.000,000, the answer is 0.
158, and the decimal part is rounded down to Φ.

Here, unit T: 100,000,000/10
: 1.0,000,000.

Next, decide how many divisions the coordinate axes should be divided into. At this time, in order to make the graph easier to see, the coordinate axes will be divided into 5 to 10 ranges.

The number of delimiters X is determined by the calculation formula X=(MAY+T)/T.

MAX = 15,800,000, T = 10,0
00,000, X= (15,800,
000 + 10,000,000 ) + 10,00
2 out of 0,000.

However, as mentioned earlier, the condition of 5≦×≦10 is not satisfied, so the calculation formula
)/T/2 is used. Then, X , = (15,800
,000+5.000,000)÷5,000,00
It was 4 out of 0, which also does not meet the condition of X. Next, use the calculation formula X: (MAX+T15)/T15. At this time, X == (15,800,000+2.000,
000 ) ÷ 8 out of 2,000,000, which satisfies the condition of X. At this time, T=:T15.

Finally, data for the unit of graph display and the scale of the coordinate axes is determined from the maximum value MAX. (Graph display unit: P,
Scale of coordinate axis: Q) Here.

(a) When MAX < 400, P=-yen",
Q=T(b) MAX < 40,000 P="1,000 yen" Q=T/1000(C) MAX <
In the case of 40,000,000 P = “10,000 yen” Q: T
/ 10,000 (d) When MAX < 400,000,000
P = "Children's Yen" Q = T / 10,000,000 (e'l If it is more than that, P = "Billion Yen" Q2 T /
In the case of 100,00.0.000 example, MAX: 1
5,800,000 is (C1, 15.800,000
< 40,000,000, so the unit of graph display is P = "10,000 yen", and the scale of the coordinate axis is Q =: 200 (Q =
2,000,000 / 10,000). The coordinate axis starts from the origin Φ and is determined by sequentially adding Q X times. That is, Φ, 200.400. 6
00.800.1000, 1200.1400.16
It becomes 00.

Calculate the units and scale for graph creation as described above.

FIG. 2 is a graph of the monthly sales, selling expenses/non-operating income and expenditure, and gross profit data shown in Table 1 by calculating the units of graph display and the scale data of the coordinate axes according to the present invention.

〔Effect of the invention〕

When creating a graph, the maximum value is calculated from the input data, and this is used to calculate how many coordinate axes the graph should be divided into, the data value of each scale, and the unit of graph display. .

Data can be graphed in a short time, making it easier to compare and analyze data.

[Brief explanation of drawings]

FIG. 1 is a flowchart showing an embodiment of the present invention, and FIG. 2 is a diagram showing a display state according to the present invention.

Claims (1)

[Claims] When creating a graph, based on the maximum value found from the input data and the unit of this maximum value, calculate how many divisions the graph coordinate axes should be divided into, decide the units to be displayed on the graph, and then display the data. A program for automatically calculating scales when creating graphs, etc., which is characterized by displaying numerical values.