JPH0454561A - Graph display controller - Google Patents

Abstract

PURPOSE:To effectively apply a graph display controller to the estimating jobs for distribution of the budget, a forecast of the future, etc., where the numerical data are decided from the graph shapes by updating the numerical data after designating a coordinate point on a graph displayed on a screen. CONSTITUTION:A coordinate input means 6 designates the numerical data to be changed and the coordinate points of the numerical data at the changed side on a screen 3a. Then the value of the numerical data to be changed is automatically changed based on the positional relation between the present coordinate point held by a storage means 4a and the changed side coordinate point designated by the means 6. Thus the numerical data is obtained in response to the changed variable of a graph shape with designation of this change. Then it is possible to perform the estimating jobs for distribution of the budget, a forecast of the future, etc., with use of the visible data change into a graph. As a result, the working efficiency is improved with a graph display controller.

Description

DETAILED DESCRIPTION OF THE INVENTION [Object of the Invention] (Industrial Application Field) The present invention relates to a graph display control device that graphs numerical data and displays it on a screen using spreadsheet software or the like.

(Prior Art) Generally, high-performance workstations and personal computers perform aggregation processing and statistical processing using spreadsheet software such as spreadsheets. In addition, recent high-performance workstations and personal convenience stores not only perform spreadsheet calculations such as aggregation processing and statistical processing, but also the numerical data used for such aggregation processing and statistical processing. There is also a function to create a graph in the form of a graph and display it on the screen. Since such a graphing function is an effective method for visually recognizing numerical data, it is very effective for processing such as budget allocation, future forecasting, and even understanding actual results.

However, the graphing functions provided by conventional workstations and personal computers only display the numerical data on the spreadsheet in a specified graph format, so in order to change the numerical data, it is necessary to You have to go back to the sheet input screen and re-enter the data. This work of re-entering numerical data involves handling the numerical information on the spray/nod sheet regardless of the graph displayed on the screen, so it is not possible to directly reflect the changed information recognized from the shape of the graph etc. in the numerical data. Have difficulty. As a result, when the changed numerical data is displayed in a graph again, a problem may arise in that the shape of the graph differs from the shape expected by the operator.

(Problem to be solved by the invention) In the past, it was only possible to graph numerical data, so it was necessary to use graphs for estimating work that required numerical data to be determined from graph shapes, such as budget allocation and future forecasting. It was difficult to use the functions.

This invention was made in view of these points, and allows numerical data to be automatically updated by specifying coordinate points on the graph displayed on the screen, making it possible to automatically update numerical data, such as budget allocation and future forecasting. It is an object of the present invention to provide a graph display control device that can be effectively used in estimation work that determines numerical data from graph shapes.

[Structure of the Invention] (Means and Effects for Solving the Problems) A graph display control device according to the present invention displays on a screen each numerical data specified by rows and columns on a spreadsheet in a predetermined graph format. a graph display means for displaying a graph, a storage means for storing coordinate points on a graph displayed on a screen by the graph display means for each of the numerical data, and predetermined coordinates on the graph displayed on a screen by the graph display means. coordinate input means for inputting numerical data to be changed and a coordinate point to which the numerical data is to be changed by specifying a point;
and updating means for updating the numerical data to be changed based on the destination coordinate point input by the coordinate input means and the coordinate point held in the storage means, and specifying the coordinate point by the coordinate input means. The method is characterized in that the numerical data on the spreadsheet worksheet is changed by the following steps.

In this graph display control device, the numerical data to be changed and the coordinate point to which the numerical data is to be changed are designated on the screen by the coordinate input means.

Then, the value of the numerical data to be changed is automatically updated based on the positional relationship between the current coordinate point held in the storage means and the change destination coordinate point specified by the coordinate input means. Therefore, by specifying a change in the graph shape, it is possible to obtain numerical data corresponding to the amount of change, so it is possible to perform estimation work processes such as budget allocation and future forecasting using the graphed visible data. This makes it possible to improve the efficiency of the business.

(Example) Hereinafter, the present invention will be described in detail with reference to the drawings.

FIG. 1 shows a graph display control device according to an embodiment of the present invention. This graph display control device is realized by a workstation or a personal computer, and includes a CPU 1, an input/output (I 10) interface 2, a display unit 3, a memory 4,
It is composed of a keyboard 5 and a mouse 6.

The CPU controls the entire operation of this graph display control device, and controls the operations of the display 3, keyboard 5, and mouse 6 in cooperation with the input/output interface 2, and also controls the information management provided in the memory 4. Performs data management of table 4a. In addition, the CPU has functions such as displaying various spreadsheets and numerical data on the sheets in graphs according to the spreadsheet program stored in the memory 4 and displaying them on the display unit 3. It has a function of updating the numerical data of the spreadsheet based on the coordinate values of the graph on the display screen of the display unit 3 and the data held in the information management table 4a.

The input/output interface 2 controls the display of the display 3, the keyboard 5, and the mouse 6 under the control of the CPUI.
Data controls human operations.

Numerical data on a spreadsheet is displayed on the display unit 3 in the form of a bar graph, line graph, pie graph, or the like. Further, the coordinate points on the graph displayed on the display unit 3 are specified by a clicking operation or a dragging operation using the mouse 6.

The memory 4 stores various programs executed by the CPU 1, such as a spreadsheet program for aggregating numerical data and performing statistical processing, a graph creation program for graphing the numerical data on the sheet, and furthermore, , a program for updating numerical data on a sheet using the information management table 4a, and the like are stored.

The information management table 4a provided in the memory 4 is
This information management table 4a is for holding various information related to the graph displayed on the display unit 3, and the information management table 4a is stored in the storage area 11. Storage area 1 where the number of Y-axis data (n) is stored
2. storage area 13 in which information indicating a graph format is stored;
and a storage area 14 in which graph control data is stored.

The storage area 14 in which graph control data is stored includes the cell name of the spreadsheet to which the numerical data to be graphed belongs, the value of the numerical data in that cell, and the graph display screen corresponding to the numerical data. Information on the current coordinate point, the destination coordinate point of the graph specified by the mouse 6, etc. are the number of X-axis data (m) and the number of Y-axis data (n).
It is registered for each position on the graph specified by .

The keyboard 5 is used for inputting numerical data into a spreadsheet, etc. Also, the mouse 6 is connected to the display 3.
It is used to specify the destination coordinate point etc. in the graph displayed.

FIG. 2 shows an example of a spreadsheet graphed by the display control device shown in FIG.

This spreadsheet Sl displays the budget amount (Kl-4) to be allocated to each business for each month from April to December, and has 4 rows (R1-R4) x 9 columns (Ct~
C9).

When numerical data on such a spreadsheet Sl is displayed on the display 3 in the form of a pie chart, the screen state will be as shown in FIG.

In FIG. 3, a pie chart G displayed on screen 3a
1 indicates the budget allocation for April corresponding to the first column C1 of the spreadsheet SI in FIG. Here, both 3 and 4 in budget Kl- are "30", and 4 and 4 in budget are "10", so in pie chart Gl, 2. 3. The ratio of occupied area of 4 to 4 is 3:3:3:1.

In FIG. 4, the budget Kl of the pie chart Gl is designated as change data, and the coordinates (xi, yl) of the point PI on the graph Gl corresponding to the budget Kl are changed to the coordinates (xl'
, yl') are shown.

What is displayed in pie chart G1 is spreadsheet S
Since there are only four numerical data, 1 to 4, corresponding to one column of l, the graph control data storage area 14 stores the first row and first column corresponding to budget as cells to be graphed. cell (RICI) and the second row corresponding to 2 in the budget 1st
There are four cells: the cell in the column (R2C1), the cell in the 3rd row and 1st column that corresponds to 3 in the budget (R3C1), and the cell in the 4th row and 1st column that corresponds to 4 in the budget (R4C1). Registered.

Also, the current position and changed position on the graph Gl corresponding to 1 in the budget are the coordinate points (xi, yl) and (xi',
yl'), and the current position and changed position on the graph Gl corresponding to 2 in the budget are coordinate points (x2.y2
) and (X2'y2'), and the current position and changed position on the graph Gl corresponding to 3 in the budget are registered as coordinate points (x3.Y3) and (X3',,a/), and are registered in the budget. The current position and changed position on the graph Gl corresponding to 4 are the coordinate points (x4.y4) and (X4'
, V4').

Here, the coordinate point (Xl', Vl') of the change position on the graph Gl corresponding to 1 in the budget is specified by the dragging operation of the mouse 6 by the operator, but if the budget is 2 to 4, The coordinate point of each change position is a value obtained by calculation inside the graph display control device.

In other words, from the positional relationship between the coordinate point (xi', yl') of the change position corresponding to 1 in the budget specified by the mouse 6 and the coordinate point (xi, yl) of its current position, the budget corresponds to 1. The amount of change in the numerical data is calculated, and the numerical data of 1 in the budget is changed from "30" to "45". The amount of change r+15J in the numerical data of 1 in this budget is also reflected in the value of each numerical data of 2 to 4 in the budget. For example, the numerical data of 2 to 4 in the budget is changed to "
-5” is changed. Then, from the amount of change in numerical data 2 to 4 to the budget calculated in this way, 2 is added to those budgets.
The coordinate point of the change position of 4 is determined at ~.

The second issue is due to changes in the numerical data of the budget Kl? l-
I changed the value of each numerical data of 4 in Pre-IK2 to 4 by the same change amount, but for example, I did not change the numerical data of 4 in Budget,
Change only the numerical data of 2 and 3 in the budget ffi r-
15" can also be reflected.

In this way, in order to distinguish between budgets in which changes are reflected and budgets in which changes are not reflected, information indicating whether ratios are reflected is also registered in the graph control data of FIG. 4. here,
rYJ is registered in the budget that reflects the amount of change, and rNJ is registered in the budget that does not reflect the amount of change.

Figure 5 shows a pie chart G based on the changed numerical data.
The state of the screen 3a when l is displayed again is shown.

In this way, in the redisplayed pie chart Gl, the budget K
l is the change position coordinate (x
i', yl').

Next, a series of operations from specifying a coordinate point using the mouse 6 to updating numerical data will be described with reference to the flowchart in FIG.

First, the numerical data on the spreadsheet Sl to be graphed is developed on the memory 4, and the numerical data is stored in the graph control data storage area 14 of the information management table 4a for graph display control. Information management table 4
Also stored in a is information indicating the graph format.

When changing the numerical data on the spreadsheet Sl, the operator specifies a specific coordinate point on the pie chart Gl displayed on the display 3, for example, as shown in FIG. 3, by operating the mouse 6. . In this case, the operator first selects the numerical data to be changed, for example, budget
In order to specify I, as shown in FIG. 3, the mouse cursor 6a is positioned at the coordinates (xi, yl) of point P1 and a click operation is performed. Next, the operator performs a dragging operation and moves the mouse cursor 8a to change the coordinates (xi, yl) of the point Pi corresponding to the budget Kl to desired coordinates, for example, the coordinates (xi 'yl') of the point Pl'. from the coordinates (xi, yl) to the coordinates (Xi', )/1'
).

The CPU 1 analyzes this operation of the mouse 6 and recognizes that the data to be changed is the numerical data "30J" of 1 in the budget from the coordinates (xl, yl) of the point PI, which is the click point, and starts dragging. The coordinates (xl
', yl') is stored in the graph control data storage area 14 as the change position of the data to be changed (step AI
).

CPUI then determines the coordinates of point PI (Xl.

yl) and the coordinates of point PI'""' + yl')
Based on the positional relationship with
) in the budget corresponding to the numerical data after the change of 1, for example, “
45'' and stores it in the graph control data storage area 14 as update data (step A2).

After this, the CPUI reflects the value of the update data stored in the graph control data storage area 14 on the data of the corresponding cell on the spreadsheet, thereby updating the numerical data on the spreadsheet (step A3). The CPU then redisplays the graph G1 on the display 3 based on the updated numerical data on the spreadsheet (step A4).

As explained above, in the graph display control device of this embodiment, the numerical data to be changed and the coordinate point to which the numerical data is to be changed are specified on the screen by clicking and dragging the mouse 6, and the information Based on the positional relationship between the current coordinate point held in the management table 4a and the destination coordinate point specified with the mouse 6, the value of the numerical data to be changed is automatically updated.

Therefore, by specifying a change in the graph shape, it is possible to obtain numerical data corresponding to the change, making it possible to efficiently perform estimation work such as budget allocation and future forecasting.

Note that although a mouse has been described here as a pointing device for specifying coordinate points, it is also possible to specify coordinate points using a keyboard or a touch panel. Further, by changing the S-shape not only for pie charts but also for bar graphs, line graphs, etc., numerical data corresponding to the change can be obtained.

[Effects of the Invention] As described above, according to the present invention, numerical data can be automatically updated by specifying a change in the graph shape, and numerical data can be determined from the graph shape, such as for budget allocation or future forecasting. It can be effectively used for estimation work.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the configuration of a graph display control device according to an embodiment of the present invention, and FIG. 2 is an example of a spreadsheet used for graph display processing of the graph display control device shown in FIG. Figure 3 is a diagram showing an example of a graph before changing the numerical data displayed on the screen by the graph display control device shown in Figure 1, and Figure 4 is a diagram showing an example of the graph before changing the numerical data displayed on the screen by the graph display control device shown in Figure 1. FIG. 5 is a diagram showing an example of a graph after changing the numerical data displayed on the screen by the graph display control device shown in FIG. FIG. 6 is a flowchart illustrating the numerical data change processing operation executed by the graph display control device shown in FIG. ■...CPU, 2...I/O interface, 3
...Display unit, 4...Memory, 4a.
...Information management table, 5...Keyboard, 6...
mouse. Applicant's representative Patent attorney Takehiko Suzue Figure 1 Figure 4 Figure Nik' - Ni → ], A4 Nini D

Claims (1)

[Claims] A graph display means for displaying on a screen each numerical data specified by rows and columns on a spreadsheet worksheet in a predetermined graph format, and a coordinate point on the graph displayed on the screen by the graph display means for each numerical value. Coordinate input for inputting the numerical data to be changed and the destination coordinate point of the numerical data by specifying a storage means for storing each data and a predetermined coordinate point on the graph displayed on the screen by the graph display means. and updating means for updating the numerical data to be changed based on the destination coordinate point inputted by the coordinate inputting means and the coordinate point held in the storage means. A graph display control device characterized in that numerical data on the spreadsheet work sheet is changed by specifying coordinate points.