JP2828301B2 - Control display processor for graphs and tables - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Summary] Control of a graph and a table, in which a graph and a table corresponding to this graph (numerical values in the graph are summarized in a table format-the same applies hereinafter) are simultaneously displayed on a screen or printed on paper. A first object of the display processing device is to enable a graph and a table corresponding to the graph to be created at an optimum position by automatic layout as appropriate under a changeable state. The second purpose is to make it possible to collectively display non-important items from other display items in a table as one or two other items in a lump, and to create graphs and tables. A graph size setting function to set the graph creation size and a table display position calculation to set the table size and display range under the set graph size on a computer with Automatic layout processing means for a table having an output function, and an other item setting function for setting, among a plurality of display items in the table, non-important items to be collectively displayed as other items, Positive / negative data mixed identification function to identify whether positive data and negative data are mixed from the items, and total only the identified positive data or only the negative data, and add the totaled data one by one. Automatically processing other items in a table having a function of generating other items as items, and activating the automatic display processing means for the graph and the table to change the graph size when displaying or printing the graph. If it is possible to calculate and display the optimal display position of a graph and a table corresponding to the graph under the size of the graph even if it is free. In the by activating the other items automatic processing means, in the graph in size in graphing, configured to allowed to create a faithful understand easily simplified table for that chart.

[Industrial applications]

The present invention relates to a graph and table control display processing device for simultaneously displaying a graph and a table corresponding to the graph on a screen or printing on a sheet.

2. Description of the Related Art In recent years, computers have been used to convert various data into graphs and tables for the purpose of, for example, determining a management strategy. There is a need for the development of a computer that can control the graph and the table by automatic layout and can quickly perform screen display processing and print processing.

[Conventional technology]

2. Description of the Related Art Conventionally, for example, the following method is used as a method of screen display processing and print processing for a graph executed by a computer and a table corresponding to the graph.

First, a computer generally has at least a CPU (Central Processing Unit), a data storage unit (which stores character data and numerical data for creating graphs and tables), a graph creation function, a table creation function, and manual operation of graphs and tables. A layout function, a screen display device, a printing device, and the like are provided.

When a graph is displayed on a screen or printed by this calculator, various necessary data is extracted from a data storage unit based on character data and numerical data input by a user, and the obtained data is extracted by a graph creation function, such as a stacked bar graph. Is created as a graph. The created graph is displayed on a screen display device, and is printed on a sheet via a printing device when requested by a user.

When a table corresponding to a graph is displayed on a screen or printed, various necessary data is also extracted from a data storage unit based on character data and numerical data input by a user. Created as a table in the prescribed row and column format. In particular, the row and column format of the table are variously set, for example, according to the number of intersecting line segments, and the types of display items constituting the graph are arranged in the vertical columns. The measurement reference for each display item is arranged. Therefore, a table corresponding to a graph having many display items and many measurement criteria is created as a correspondingly large table.

Thus, the created table is displayed on a screen display device, and is printed on a sheet via a printing device when requested by a user.

When the created graph and the table corresponding to the graph are simultaneously displayed on the screen or printed, a manual layout function for the graph and the table is activated in addition to the above-described processing. The manual layout function includes, for example, a function of designating a coordinate position (that is, a display position) on the screen at a reference position of a graph or a table by a keyboard operation, and a function of moving the graph to the designated coordinate position. Have been. In other words, the user activates the manual layout function by operating the keyboard,
For example, the graph is moved to a desired position on the screen display device, and then the table is moved or displayed at a desired position in an empty area of the screen display device. Then, if there is a user's request, it is printed on a sheet via a printing device.

In addition, a computer having a function of setting and changing the graph size of the graph has been developed, but the description in that case is omitted here.

[Problems to be solved by the invention]

Conventionally, when a graph and a table corresponding to the graph are simultaneously displayed on a screen or printed on paper, the graph and the table are activated by a manual layout function by a keyboard operation so that the graph and the table can be displayed in a good-looking position on the screen. Since they have to be arranged, there is a problem that this processing takes time and is troublesome.

Also, especially when creating a table corresponding to a graph,
Since there was no concept of “other items” in the table, if the row and column format of the table were set as specified according to the graph configuration, the table would be created as a large table containing unnecessarily important items. Sometimes.
This results in a drawback that the graph runs out of a predetermined graph size when the graph is displayed or printed simultaneously with the graph.

If the lower part of the table is cut and displayed in order to avoid this, there is a problem that the table becomes unfamiliar to the graph and difficult to understand.

SUMMARY OF THE INVENTION The present invention has been made in view of such a problem, and has an object to make it possible to create a graph and a table corresponding to the graph at an optimal position as appropriate by automatic layout under a changeable graph size. As a first object, when a table corresponding to a graph is created, non-important items can be automatically displayed as one or two items as other items automatically from a plurality of display items in the table. The second object of the present invention is to provide a control and display processing device for graphs and tables.

[Means for solving the problem]

FIGS. 1 (a) and 1 (b) show the principle configuration of the present invention. FIG. 1 (a) corresponds to claim 1, and FIG. 1 (b) corresponds to claim 2.

1 (a) and 1 (b), reference numerals 1a and 1b denote screen display devices, for example, CRT displays.
Each has a keyboard device 2a, 2b. 3a and 3b are printing devices, for example, page printer devices.

Reference numerals 4a and 4b denote data storage units in which character data and numerical data for creating graphs and tables are stored, for example, magnetic disk devices. 5a and 5b are functions for creating graphs and tables.
Receives various character data and numerical data in a and 4b, and creates, for example, stacked bar graphs and double pie charts,
It has a function of creating a table corresponding to the graph.
The graphs and tables created by the graph and table creation functions 5a and 5b are the screen display devices 1a and 1b and the printing devices 3a and
It is supplied to 3b and displayed on the screen or printed on paper.

Reference numeral 6 in FIG. 1 (a) denotes a graph size setting function, which sets a graph size of a graph created by the graph and table creation function 5a and creates a graph size enlargement / reduction. It has a size setting change function that is performed together with the graph and table that have already been set. Therefore, the graph and table actually created by the graph and table creation function 5a are created under the graph size set by the graph size setting function 6. Reference numeral 13 denotes a graph and table automatic layout processing means for displaying a graph and a table for calculating an optimal display position between a graph created under a previously set graph size and a table corresponding to the graph. It has a position calculation function 12.

Reference numeral 17 in FIG. 1 (b) denotes other item automatic processing means in table creation. When a table corresponding to a certain graph is created by the graph and table creation function 5b,
Of the multiple display items in the table, the other item setting function 14 that sets the non-important items to be displayed collectively as other items, and a mixture of positive and negative data from the non-important items The positive / negative data mixed identification function 15 that identifies the
Other item creation function 16 to create as other items one by one
And is configured.

[Action]

First, in the case of claim 1, a graph and table creation function 5a
Receives necessary data from the data storage unit 4a,
Under the graph size desired by the user set by the graph size setting function 6, a graph based on the various data and a table corresponding to the graph are created. At this time, the display position calculation function 12 in the automatic layout processing means 13 for the graph and the table is activated, and the display position of the graph and especially the table is calculated under the already set graph size. As a result, the graph and the table can be simultaneously displayed or printed at a desired position in a desired size on a screen or paper.

In the case of claim 2, when the graph and table creation function 5b receives various necessary data from the data storage unit 4b, a graph based on the various data and a table corresponding to the graph are created. . At this time, the other item automatic processing means 17 in the table creation is activated. That is, when the user inputs a certain designation code via the keyboard device 2b, the other item setting function 14 is first activated, and non-important items in the table are picked up.
Next, the positive / negative data mixed identification function 15 is activated, and it is determined whether or not the positive / negative data is mixed in the non-important items picked up. If it is determined that positive and negative data are mixed, then the other item creation function 16 starts,
The positive data is added only with the positive data and is displayed on the upper display item of the other item, and the negative data is added with only the negative data and the lower display item of the other item is displayed with a minus sign.

However, if the positive and negative data are not mixed, the other items are displayed as one display item.

〔Example〕

 FIG. 2 shows an overall configuration diagram of this embodiment.

The figure shows a case where the configurations of the first and second aspects are provided together.

In the figure, reference numeral 1 is a screen display device, 2 is a keyboard device, 3 is a printing device, 4 is a data storage unit, 5 is a function for creating graphs and tables, 6 is a graph size setting function, and 13 is an automatic layout process for graphs and tables. Means, 12 is a display position calculation function for graphs and tables, 8 is a table row and column format setting function, 17 is other item automatic processing means in table creation, 14 is other item setting function, 15 is positive / negative data mixed identification function, Reference numeral 16 denotes a function for creating other items.

The computer according to the present embodiment has an external keyboard device 2
And a page printer 3 as a printing device. And a data storage unit 4, a function 5 for creating a graph and a table, and a function 6 for setting a graph size.
And automatic layout processing means 13 for graphs and tables, automatic processing means 17 for other items in tables, and the CRT display 1 as a screen display device.

 The configuration of the main part will be described.

First, the graph size setting function 6 has a function of setting the size of graph creation and table creation performed on a screen or on paper. When there is no request from the user, the standard graph size can be automatically set. In addition, the maximum size is, for example, the entire area on the screen, or even infinite, but this function allows you to enlarge and reduce the graph size of a graph (table) that has already been created together with the graph. I have.

The data storage unit 4 is, for example, a magnetic disk device, and stores a lot of character data and numerical data required for graph creation and table creation. These various data are supplied to the graph and table creation function 5 through activation of the data transfer function 7 when the graph and table are created.

The graph and table creation function 5 has functions necessary to create a graph and a table according to the set graph size and based on the various data that has been passed.

Specifically, it has a function of selecting a graph type such as a normal type, a stacked bar type, a scatter diagram type, a Pareto type, a circle type, a double circle type, and the like. Has the function of creating When a graph is created, necessary character data and numerical data are transferred from the data storage unit 4 through the activation of the data transfer function 7, and based on the various data in the selected model. To create a graph. That is, for example, a measurement standard (character data) is arranged on the X axis and a numerical scale (numerical data) is arranged on the Y axis based on the selected graph model, and the coordinates of both are arranged to arrange a line segment or a pattern. To be created.

The other has a function to create a table corresponding to the graph to be created. When a table corresponding to the graph is created, character data and numerical data necessary for creating the graph are also transferred via activation of the data transfer function 7, and a table based on the various data is obtained. Will be created. However, when a table is created, the row and column format setting function 8 of the table is activated.

The table row and column format setting function 8 arranges, for example, frames in which column names of graphs, which are components of the graph, are written in a vertical column (Y axis), and writes axis scale names, which are measurement standards of the graph. Frames are arranged in a horizontal axis row (X-axis), and both are configured as a mesh-like table style intersecting with, for example, a line segment. The item name of the graph (or the number of frames in which the item name is written)
And the axis scale name (or the number of frames in which the scale name is written) are referred to as “attribute information including items necessary for displaying or printing the table”.

In other words, when creating a table, in the set row and column format, write each item name of the graph in the vertical frame on the left side, and write the axis scale name, which is each measurement standard of the graph, on the horizontal axis on the upper side. Further, device data as a measurement result of each item name is written in a blank mesh.

Further, the graph created by the graph and table creation function 5 and the table corresponding to the graph are automatically created under the already set graph size by activating the automatic layout processing means 13 for the graph and table. Can be arranged at the optimal position.

The automatic layout processing means 13 for graphs and tables includes a display position calculation function 12 for graphs and tables. The display position calculation function 12 sets the graph created by the above-described graph and table creation function 5 or a graph already created and a table corresponding to the graph by the graph size setting function 6. This is a function to calculate where to arrange the data under the graph size.

Calculation method (algorithm) for automatic layout of graphs and tables in the display position calculation function 12
For example, at least the following coordinate calculation method can be considered.

One is to first calculate the display position of the table within the screen display size set as a vertically long rectangle, for example. It is conceivable that the information is displayed at a position toward the center. In this case, therefore, the length of the width of the screen display size and H, if the distance of the length of the table as h _1, for example, (H
−h ₁ ) The numerical value x ₁ obtained by calculating ÷ 2 is taken from the left end on the X axis of the coordinates within the screen display size, and a predetermined numerical value y ₁ is taken on the Y axis of the coordinates (this y ₁ May be zero). The table can be automatically laid out by matching the bottom left side (reference edge) of the table to the coordinates (x ₁ , y ₁ ) obtained in this way.

In this state, when calculating the display position of the graph,
Again the length of the width of the graph and h _2, if the length of the vertical width of the previous table as L, and the numerical value x ₂ obtained by calculating _{(H-h 2) ÷ 2} , (L + y 1 ) coordinates of a display position by a numerical value y ₂ obtained by calculating (x _2,
y ₂ ) can be considered as a coordinate calculation method. Also at this time, the automatic layout of the graph can be executed by matching the upper left side (reference edge) of the graph to the coordinates (x ₂ , y ₂ ).

Another possibility is to display a table and a graph on the left and right within a screen display size set to, for example, a horizontally long rectangle. In this case, the coordinate calculation method is simpler than the above-described calculation method. For example, first, the lower right edge of the table is adjusted to the lower right edge of the screen display size, and this table is on the opposite side. The lower right edge of the graph is aligned with the lower left edge, and both are arranged at the same time. Therefore, the length of the width of the table and h _3, when the length of the width of the graph and h _4, the numerical value x ₄ obtained by calculating _{(H-h 3 -h 4)} ÷ 3, and the table A method is considered in which each is moved in the X-axis direction so as to be a predetermined distance from the left and right in the screen display size of the graph and further to be an interval between the table and the graph. Thereby, automatic layout of the graph and the table can be executed.

In addition, it is basically possible to execute the automatic layout processing of graphs and tables within a square or deformed screen display size by applying any one of the above calculation methods. It goes without saying that the layout order may be reversed from the above, and it is easy to consider a method other than the above as a calculation method.

In particular, in the table where the display position is determined (automatic layout processing) by the activation of the automatic layout processing means 13,
Although it may be in the stage before the automatic layout processing is performed, in the table, when the other item automatic processing means 17 in the table creation is activated, the setting of the row and column format in the table can be changed. .

As the other item automatic processing means 17, for example, the arrangement of specific item names in the table is stopped to limit the number of rows in the table, and instead, the "lower item" is set to the first or second row in the bottom row. The system is provided with the following functions to provide omitted items.

One is the other item setting function 14. This is activated by, for example, inputting a certain code from the keyboard device 2. In each table name in the vertical frame in the table, and if necessary, in each axis scale name in the horizontal frame. , Non-important items that need not be referred to much are detected. However, this insignificant item can be detected from the graph. Then, the insignificant items detected in this way are reduced from the table together with the numerical data, and are set as "other items".

The other is a positive / negative data mixed identification function 15. This has a function of identifying whether positive data and negative data are mixed in the non-important items detected by the other item setting function 14. If they are not mixed, it is also possible to identify which one is positive or negative.

The other is the other item creation function 16. This is a function to add only the positive data or only the negative data identified from the previous non-important items by the positive / negative data mixed identification function 15 for each axis scale name, and to add the total data to “Other items”. And a function of writing in a corresponding blank mesh. That is, if only the positive data is identified, one "other item" is provided in the bottom column of the table and the total data is written therein. Conversely, if only the negative data is provided, a minus sign is added thereto. The added total data will be written. If both are mixed, two columns of "other items" are provided at the bottom of the table, and the same type of total data is distributed and written to each one.

FIG. 3 and FIG. 4 are flowcharts showing the operation when the automatic layout processing of the graph and the table is executed.

Here, a description will be given of a case where the automatic layout processing of both tables is executed while the table is first created in the process of creating the graph.

 First, start with the flowchart of FIG.

First, in step 3-1, graph data is created in graph creation. At this time, as shown in FIG. 7, various data necessary for creating the graph are displayed on the screen. What is displayed here is each item name 2 in the vertical column
1,22,23, horizontal rows are each axis scale 31,32,33,34, and each corresponding blank space is a specific graph value 92,43…
Is displayed.

Next, in step 3-2, a graph type is selected. That is, one of a normal type, a stacked bar type, a scatter diagram type, a Pareto type, a circular type, a double circular type and the like is selected. It is assumed that the standard bar graph is selected here. Then, in step 3-3, a standard bar graph corresponding to the above various data is created and displayed. At this time, as shown in FIG. 8, each axis scale name 31, 32, 33, 34 shown in FIG.
Item names 21, 22, which are color-coded with specific values for each
23 The bar graph data corresponding to each is displayed.

Subsequent to this state, in step 3-4, data display accompanying table creation is performed. At this time, as shown in FIG. 9, a menu sheet 40 for data display is displayed on the screen. In the menu sheet 40, display 41, column width 42, position 4
3, color 44, execution 45, and cancellation 46 are displayed. Among these various selection items, in particular, select "Yes" in display 41,
When "automatic" is selected at the position 42, the processing of the flowchart in FIG. 4 described later is executed, and the table is created while performing the automatic layout.

 Therefore, the description moves to the flowchart of FIG.

First, when the graph size is specified in the first step 4-1, the number of rows A of the table that can be displayed from below the graph size is calculated in step 4-2. This can be determined from the total height of the screen display size (the number of rows G when all vertical distances are used, and therefore, here, for example, it is assumed that the number of rows in the table is calculated as A = G / 3. Thus, the ratio between the graph portion and the table portion (the initial state of the automatic layout process) is determined.
Next, in step 4-3, the maximum number of rows MG and the maximum number of digits MK of the table are obtained from the number of elements of the data necessary for table creation. That is, this is the previously calculated number of rows in the table A = G / 3
Can be obtained from the display area of the table corresponding to (i.e., the previous ratio).

Following this state, in step 4-4, it is determined whether or not the maximum number of rows MG exceeds the number of rows A in the previous table. If YES, that is, if it is determined that the number of lines is exceeded, the process proceeds to step 4-5, and only the number of displayable lines is displayed. If NO, that is, if it is determined that the number of lines is not exceeded, step 4-6 is performed. And display up to the maximum number of rows in the table.

Further, in step 4-7, it is determined whether or not the maximum number of digits MK exceeds the number of digits K in the above table. If YES, that is, if it is determined that the number of lines is exceeded, the process proceeds to step 4-8. Also, display is performed for the number of displayable lines. If NO, that is, if it is determined that the number of lines is not exceeded, step 4-9. And display up to the maximum number of digits in the table.

When this state is obtained, in the last step 4-10,
The table is displayed at a good-looking position at the bottom of the graph based on the obtained number of rows and digits, for example, at the center from the left and right on the bottom side of the graph.

With this, the automatic layout processing of the table is completed, and this flowchart ends.

Note that the portion other than A = G / 3 in the screen display size, that is, the upper 2G / 3 area is the target area for executing the graph automatic layout processing.

Thus, returning to the flowchart of FIG.
In the last step 3-5, the display position of the already created graph is automatically calculated and displayed. At this time,
As shown in FIG. 10, the automatic layout processing of the graph and the table corresponding to the graph has been completed on the screen, and both are simultaneously displayed.

With the above, the flowchart here ends.

In this way, it is easy to simultaneously display the graph and the table corresponding to the graph as an automatic layout while creating the table during graph creation.

FIG. 5 is a flowchart showing the operation when the display position of the table is automatically changed according to the graph size change.

Here, a case where the graph size is reduced will be described.

First, in step 5-1, a change in the graph size is designated (reduced). Next, in step 5-2, the graph size is changed according to the designated size, and the display position of the table is calculated.

In step 5-3, a table is displayed under the designated graph size, and a reduced graph is displayed in an empty area under the new graph size. At this time, the graphs and tables that were initially in the state of the graph size shown in FIG. 11 on the screen are automatically laid out and displayed under the reduced graph size as shown in FIG. . Note that in FIGS. 11 and 12, the display sizes of “item name 1, item name 2, and item name 3” displayed at the upper right of each diagram are the same. As can be seen from this, the size of the table itself shown in FIG. 11 is the same as the size of the table itself shown in FIG. 12, and the graph size of the graph shown in FIG. Are shown smaller than those shown in FIG. Needless to say, FIG. 12 corresponds to the case where the graph size in FIG. 11 is reduced but the size of the table itself is not changed.

This is the end of this flowchart.

In this manner, the graph and the table corresponding to the graph can be automatically laid out and displayed at the same time as the graph size is changed.

FIG. 6 is a flowchart showing the operation when executing other item processing in the table.

Here, as shown in FIG. 13, a case where the other item processing is executed in a table in which the automatic layout processing has already been completed together with the stacked bar graph will be described.

First, it is determined in step 6-1 whether other items are set. If NO, that is, if it is determined that there is no such setting, the process proceeds to step 6-2, and the display area for the last line of data is secured for one line. Then, the process proceeds to step 6-3, and when the data value of the first row is displayed, the flowchart ends. If YES, that is, if it is determined that other items are set, the next step 6-7 is performed.
, It is determined whether positive and negative data are mixed in the data of the other items.

Here, if NO, that is, if it is determined that only positive or negative, not mixed positive / negative, the processing of the above-described steps 6-2 and 6-3 is executed, and this flowchart ends. Instead, if YES, that is, if it is determined that the data is mixed positive and negative, in the next step 6-5, the display area for the data values of the other items is secured for two lines. Then, in the next step 6-6, the data value of the first line is displayed. Here, for example, a total value of only positive data is displayed. Then, in the last step 6-7, the data value of the second line is displayed. Here, the total value of only negative data is displayed.

At this time, as shown in FIG. 13, a table that is faithful to the graph and that is easy to understand is displayed in a small display area on the screen having the “Other” column.

This is the end of this flowchart.

In this manner, by executing other item processing in table creation, it is possible to more effectively utilize the limited screen display size. Therefore, it is possible to create a large graph correspondingly, which greatly contributes to improving the usability of the user.

Also, in the present embodiment, an example has been described in which a table is created based on a standard bar graph and a stacked bar graph.
Of course, it is easy to execute automatic layout processing and other item display processing even with other graph types.

For example, as shown in FIG. 14, it is easy to simultaneously perform automatic layout of a scatter diagram and a table corresponding to the scatter diagram. In this case, too, as much data as possible can be displayed on the graph.
It is very convenient to perform other item processing.

Further, as shown in FIGS. 15 and 16, it is easy to simultaneously perform automatic layout of a pie chart or a double pie chart and a table corresponding thereto. In this case, although neither the X axis nor the Y axis is displayed on each graph side, the automatic layout can be performed based on, for example, the outer circumference and the diameter of the circle.

Further, as shown in FIG. 17, it is easy to simultaneously perform the automatic layout of the Pareto diagram and the table corresponding to the Pareto diagram. Since various graphs can be mixed and displayed on the Pareto chart, more data can be displayed, and it is very convenient to perform other item display processing.

〔The invention's effect〕

As described above in detail, according to the present invention, when a graph and a table are created and displayed, an automatic layout processing unit having a function of calculating each display position is provided, so that the graph and the graph can be handled. The table and the table can be displayed on the screen at the same time or printed on paper easily. As a result, the user does not have to consider each display position or wastefully change the display, and the working time can be reduced. In addition, since automatic layout without waste can be performed, paper can be reduced in simultaneous printing.

In addition, by providing other item processing means that has the function of displaying many items as other items at the same time when creating a table, it provides a table that is faithful to the graph and easy to see when displaying and printing the table screen it can. This has the advantage that the usability of the user is improved.

[Brief description of the drawings]

1 (a) and 1 (b) are diagrams illustrating the principle of the present invention, FIG. 2 is a diagram illustrating the overall configuration of the present embodiment, and FIG. 3 is an operation when an automatic layout process for a graph is performed in conjunction with graph creation. FIG. 4 is a flowchart showing an operation when an automatic layout process of a table is executed in accordance with table creation, and FIG. 5 is an operation flow in a case where a display position of the table is automatically changed according to a graph size change. FIG. 6 is a flowchart showing an operation when executing other item processing in a table. FIG. 7 is a view showing graph data in creating a graph displayed on the screen during the automatic layout processing. FIG. Fig. 9 is a diagram showing a standard bar graph displayed on the screen during the automatic layout processing. Fig. 9 is data showing table creation displayed on the screen during the automatic layout processing. Fig. 10 shows the simultaneous arrangement of the graph displayed on the screen during the automatic layout process and the table corresponding to the graph. Fig. 11 shows the graph size changed. Fig. 12 shows a graph and a table in a state before the graph is changed, Fig. 12 shows a graph and a table automatically laid out in a state after the graph size is changed, Fig. 13 shows a stacked bar graph, Correspondingly, a diagram showing the automatic layout of a table on which other items have been automatically processed, FIG. 14 shows a scatter diagram and a diagram showing an automatic layout of a table corresponding thereto, and FIG. 15 shows a pie chart. , A diagram showing the automatic layout of the corresponding table, FIG. 16 is a diagram showing the automatic layout of the double pie chart and the corresponding table, and FIG. 17 is a Pareto diagram and the corresponding table. FIG. 6 is a diagram showing an automatic layout of the above. DESCRIPTION OF SYMBOLS 1 ... Screen display device 2 ... Keyboard device 3 ... Printing device 4 ... Data storage part 5 ... Graph and table creation function 6 ... Graph size setting function 7 ... Data transfer function 8 ... Table row And digit format setting function 12 Display position calculation function 13 Automatic layout processing means for graphs and tables 14 Other item setting function 15 Positive / negative data mixed identification function 16 Other item creation function 17 Other items Automatic processing means

 ──────────────────────────────────────────────────続 き Continuing on the front page (72) Inventor Koichi Nishio 3-4-30 Masuizumi, Kanazawa-shi, Ishikawa Pref. Ishikawa Fujitsu Software Development Co., Ltd. (72) Inventor Masataka Yoshida Unoki 98, Unoki-cho, Kawakita-gun, Ishikawa Address-2 Inside PFU Corporation (56) References JP-A-61-272822 (JP, A) JP-A-61-18036 (JP, A) JP-A-1-214463 (JP, A)

Claims (2)

(57) [Claims] 1. A data storage unit for storing various character data and numerical data, and based on the various character data and numerical data stored in the data storage unit, a graph is selected from a plurality of different types of graphs. Function to create a graph and a table that summarizes a graph in a table format and numerical values in the graph, and a graph size setting function to set or change the graph size of the graph created by this function With a computer, the created graph and table are simultaneously displayed on the screen or printed on paper. In a graph and table control display processing device, the numerical values in the graph to be created and displayed are summarized in a table format. When creating a table, set the screen display size or print paper size and the graph size setting function Automatic table layout processing means (12) having a display position calculating function (12) for calculating a display position of the table based on the obtained graph size and attribute information including items necessary for displaying or printing the table ( 13) is provided. The table display position calculation function (12) of the table automatic layout processing means (13) is activated by the graph size setting function to display the graph size when displaying or printing the graph. Is set, and the size of the display area of the table based on the graph size of the graph and the screen display size or the size of the printing paper and the attribute information under the state where the graph size is given. Is determined, and a display range that can be displayed within the determined size of the display area of the table is set to display the entire table or a part of the table. In addition, the display position calculation function (12) of the table further includes a function for changing the graph size of the graph for which the table creation has been completed to another graph size by activating the graph size setting function. Under the state where the graph size is given, the size of the display area of the table is determined based on the graph size of the other graph and the screen display size or the size of the printing paper and the attribute information, and the determined size is determined. A graph and a table, wherein the display range of the table that can be displayed within the size of the table display area is set to display the entire table or a part of the table. Control display processing device. 2. A graph and table creation function for creating a graph and a table based on various character data and numeric data stored in the data storage unit, the data storage unit storing various character data and numerical data. And a calculator having a graph size setting function for setting or changing the size of the graph created by this function, displaying the created graph and table at the same time on the screen or printing on paper, In the control display processing device, when creating a table in which the numerical values in the graph to be created and displayed are summarized in a table format, one or two of the plurality of display items in the table are set as non-important items as other items.
The other item setting function (14), which is set to be displayed collectively in one item, and positive data and negative data are mixed from non-important items set as other items by the other item setting function. Positive / negative data mixed identification function (15)
And an other item creation function (16) that sums only the positive data or only the negative data identified by the positive / negative data mixed identification function and creates the summed data as other items one by one. A simplified item in which the other item automatic processing means (17) collectively creates numerical items of numerical values in the graph under a given graph size in the graph creation. A control display processing apparatus for graphs and tables, wherein the control display processing apparatus is configured to generate a table.