JPH0844802A - Device and system for displaying graph of calculation table - Google Patents

Abstract

PURPOSE:To efficiently execute the temporary conversion of cell data for graph display in the case of graph display of calculation table or the conversion of a lot of cell data for graph display on the same condition. CONSTITUTION:The value of a conversion function 12 inputted from an input device 10 is converted by a data conversion processing part 14 for the cell data within the range to be graphed among cell data 11 of a sheet. This converted value is stored in a converted cell data storage part 15, processed for the graph display by a graph plot processing part 16 together with graph parameter data stored in a graph parameter data storage part 13, and displayed on an output device 17 as a graph.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a graph display method for spreadsheets, and in particular, it converts cell (numerical) data of a table required for graphing by a specified function and temporarily stores it in a storage unit. The present invention relates to a graph display method of a spreadsheet stored for displaying a graph.

[0002]

2. Description of the Related Art Conventionally, a graph display method of this kind of table calculation requires a conversion necessary for each cell data by directly referring to the cell data (numerical value) of the table when executing a test or a change of the graph display. After processing, the cell data is changed for displaying the graph, or the converted cell data for displaying the graph is separately input, and then the graph is displayed based on the graph data (additional information).

Further, in order to efficiently execute the test or change of the graph display, the cell data (numerical value) of the table and the graph data (additional information) are independently managed. For example, Japanese Patent Application Laid-Open No. 63-36387 discloses a technique of performing graph drawing processing by independently managing numerical data of a sheet and parameter data of a graph.

[0004]

In the above-mentioned conventional graph display method of the spreadsheet, since the cell data (numerical value or calculated value) of the sheet is directly referred to with respect to the numerical data, it is temporarily used for displaying the graph. If you want to convert the numerical value to, you need to create and enter the data in another cell position and use it, or directly change the cell data and restore it again. Further, even when converting the same condition for a large number of cell data, it is necessary to perform the above-mentioned operation for all the cell data, which is troublesome.

[0005]

[MEANS FOR SOLVING THE PROBLEMS] An input device for inputting data, an output device for displaying a sheet of a graph or a table, and information for each cell data of a sheet which is a table input from the input device is stored. A cell data storage unit, a conversion function storage unit that stores a conversion function for displaying a graph, a graph parameter data storage unit that stores parameters that are additional information necessary for displaying a graph, and the data in the cell data storage unit A data conversion processing unit that performs data conversion by a function of the conversion function storage unit, a converted cell data storage unit that stores the converted cell data, data of the cell data storage unit, and data of the graph parameter data storage unit And a graph drawing processing unit for displaying the graph on the output device.

[0006]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of the present invention. FIG. 1 stores an input device 10 such as a keyboard and a mouse for inputting data, an output device 17 such as a CRT for displaying a sheet of a graph or a table, and information of each cell data as information of a table sheet. A cell data storage unit 11, a conversion function storage unit 12 that stores a conversion function for displaying a graph, a graph parameter data storage unit 13 that stores parameters that are additional information necessary for displaying a graph, and a cell data storage unit 11 Data conversion processing unit 14 that performs data conversion of the data of the above using the function of the conversion function storage unit 12
And a converted cell data storage unit 15 for storing the converted cell data, and a graph is drawn based on the data in the cell data storage unit 15 and the data in the graph parameter data storage unit 13 and displayed on the output device 17. It is composed of the graph drawing processing unit 16.

The cell data storage unit 11 for storing the cell data of the sheet stores the numerical value or calculated value of each cell input from the input device 10, and a part of this becomes the cell data in the range to be graphed.

The conversion function storage unit 12 stores a function such as a calculation formula or a conditional formula for converting cell data designated at the time of graphing.

The graph parameter data storage unit 13 stores additional information necessary for graphing (type of graph, color, number of divisions of scale, etc.).

Next, the processing operation of the present invention will be described with reference to FIG. 1 and FIG. 2 which is a flowchart showing the flow of the processing of the present invention.

The cell data of the sheet input from the input device 10 is stored in the cell data storage unit 11 (step 20).

When the range of the cell data to be graphed with respect to the input cell data is designated from the input device 10, an area having a capacity for the cell data to be graphed is secured in the converted cell data storage unit 15 (step 21, 22).

The conversion function storage unit 12 stores the conversion function in advance or stores it by inputting it from the input device 10 (step 23). In the following description, this conversion function will be referred to as a conversion function F.

When the conversion function is specified, the data conversion processing unit 14 uses the corresponding conversion function F stored in the conversion function storage unit 12 to store the cell data storage unit 11.
All the cell data to be graphed are converted and stored in the converted cell data storage unit 15 (steps 24, 2).
5).

Here, the cell data having the row number y and the column number x before conversion is referred to as axy, and the cell data after conversion having the row number y and column number x is referred to as Axy. .

In the graph parameter data storage unit 13,
The additional information required for graphing is stored in advance, or the additional information required for graphing is input from the input device 10 and stored (step 26).

When the graph parameter data is designated, the graph drawing processor 16 receives the corresponding graph parameter data stored in the graph parameter data storage 13 and the corresponding cell data stored in the converted cell data storage 15. Axy and Axy are used for processing calculation, and graphic data as drawing information is displayed on the output device 17 (step 27).

A first specific example will be described with reference to FIG.

[0020] This concrete example is a sales table 3 of three companies by month.
Input the cell data 31 of the sheet from the 0th row to the 3rd row and the 3rd column
It is generated by inputting from 0.

The first conversion function 32 converts the value of the cell data into the cumulative sales from April of each company. "@IF (conditional expression, expression 1, expression 2)" in the function is to obtain expression 1 if the conditional expression is satisfied, and to obtain expression 2 otherwise. That is, when x = 1, that is, the April sales of each company are converted into April values, and otherwise, that is, 5 of each company.
The sales for the month and June are converted into the total value of the previous month and the total value of the sales for the month.

The converted result is the converted cell data 33.
Is stored in the cell data storage unit 15 after conversion.

A second specific example will be described with reference to FIG.

In this concrete example, the sales table of three companies by month 4
The cell data 41 of the sheet from 0 to 3 rows and 3 columns is input device 1
It is generated by inputting from 0.

The second conversion function 42 converts the value of cell data into a unit of 1000. Company A's April sales of 112,000 are converted to 112 (thousands). That is, all cell data is converted by dividing it by 1000, and the converted result is stored in the converted cell data storage unit 15 as the converted cell data 43.

A third specific example will be described with reference to FIG.

In this concrete example, the sales table of three companies by month is also 5
Input the cell data 51 of the sheet from the 0th row to the 3rd row and the 3rd column
It is generated by inputting from 0.

The third conversion function 52 converts the other sales into relative values with the largest value of all sales as 100. “Amax” in the function is the maximum value in all cell data. That is, all the cell data are divided by the maximum value amax and converted by 100, and the converted result is stored in the converted cell data storage unit 15 as the converted cell data 53. For example, in FIG. 5, sales 151,000 of Company A in May is the largest value, so this is set to 100 and all other cell data are converted into relative values.

A fourth specific example will be described with reference to FIG.

In this concrete example also, the sales table of three companies by month 6
Input the cell data 61 of the sheet from the 0th row to the 3rd row and the 3rd column
It is generated by inputting from 0.

The fourth conversion function 62 converts a month in which each sales exceeds a certain reference value (here, 120,000) into "10" and a month in which the sales do not exceed into "0". Is. For example, company A's April sales 112,000 do not exceed the reference value of 120,000, so they are converted to "0". Company A's sales of 151,000 in May are the standard value of 12
Since it exceeds 10,000, convert it to "10". This conversion is performed on all the cell data 61, and the converted result is stored in the converted cell data storage unit 15 as the cell data 63.

In any of the first to fourth specific examples, after the cell data in the cell data storage unit 11 is converted by the data conversion processing unit 14 by the conversion function in the conversion function storage unit 12, the converted cell data is converted. The converted cell data stored in the storage unit 15 is subjected to the graph drawing processing by the graph drawing processing unit 16 based on the additional information for displaying the graph in the graph parameter data storage unit 13 and displayed on the output device 17. To be done.

[0033]

As described above, in the graph display of the spreadsheet according to the present invention, the numerical values for displaying the graph are not directly used from the cell data (numerical value, calculated value) of the sheet, but the specified function is used. Since the numerical value converted and stored in the temporary storage unit is used, it is not necessary to directly change the cell data of the sheet each time the graph is displayed, and the numerical operation for the graph display can be easily performed.

Further, since all the cell data in the graphed range are collectively converted by the specified function, all the cell data are individually converted even when the same condition is converted to a large number of cell data. There is no need to change, only one conversion function needs to be changed, which simplifies the operation and enables efficient operation.

[Brief description of drawings]

FIG. 1 is a block configuration diagram of the present invention.

FIG. 2 is a flowchart showing the flow of processing of the present invention.

FIG. 3 is an image diagram of a first specific example.

FIG. 4 is an image diagram of a second specific example.

FIG. 5 is an image diagram of a third specific example.

FIG. 6 is an image diagram of a fourth specific example.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 10 Input device 11 Cell data storage unit 12 Conversion function storage unit 13 Graph parameter data storage unit 14 Data conversion processing unit 15 Converted cell data storage unit 16 Graph drawing processing unit 17 Output device

─────────────────────────────────────────────────── ─── Continuation of the front page (51) Int.Cl. ⁶ Identification code Internal reference number FI technical display location 9365-5H G06F 15/62 322 L

Claims (2)

[Claims] 1. An input device for inputting data, an output device for displaying a sheet of a graph or a table, and a cell data storage unit for storing information of each cell data of a sheet which is a table input from the input device. A conversion function storage unit that stores a conversion function for displaying a graph; a graph parameter data storage unit that stores parameters that are additional information necessary for displaying a graph; A data conversion processing unit that performs data conversion using a function of the unit, a converted cell data storage unit that stores the converted cell data, and a data based on the data in the cell data storage unit and the data in the graph parameter data storage unit. And a graph drawing processing unit for drawing a graph and displaying the graph on the output device. 2. A step of storing inputted cell data of a sheet in a cell data storage section, and a range of the cell data to be graphed with respect to the inputted cell data is designated from the input device to be graphed. The step of allocating an area of capacity for cell data in the converted cell data storage, the step of storing and changing the conversion function in the conversion function storage, and the conversion function storage when the conversion function is specified A step of converting all the cell data to be graphed in the cell data storage unit by using the stored corresponding conversion function and storing the converted cell data in the converted cell data storage unit, and additional information necessary for graphing in advance. The step of storing in the parameter data storage unit, the corresponding graph parameter data stored in this graph parameter data storage unit, Performs processing calculation using the corresponding cell data stored in 換後 cell data storage unit, the graph display method of the spreadsheet, which comprises a step of displaying on the output device a graphic data as drawing information.