JP2564139Y2 - Graph creation device - Google Patents

Description

[Detailed description of the invention]

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a graph creating apparatus for creating a graph of tabular data.

[0002]

2. Description of the Related Art Conventionally, office computers and word processors are provided with a graph creation function as standard.
A graph is created in which the matrix data of the matrix structure input on the worksheet screen is represented by the correlation between the horizontal axis and the vertical axis. That is, FIG. 5A shows the table data of the monthly sales table input on the worksheet screen, and the data in the column direction constituting this table data are column names “B” and “C” of the worksheet screen. ...... "January" corresponding to "G",
The month data is “February”, “June”, and the row direction data is the row number “4” on the worksheet screen.
Sales of “Calculator” and “Watch” correspond to “5”. For example, when a stacked bar graph is created from such table data, as shown in FIG. 5B, the data “January” to “June” in the column direction of the table are the element data arranged in the horizontal axis direction of the graph. , And the sales of the data “calculator” and “clock” in the column direction of the table are the item data arranged in the vertical axis direction of the graph. In other words, a graph is created in which data in the column direction of the table is always used as element data of the graph, and data in the row direction of the table is used as item data of the graph.

[0003]

By the way, it is assumed that tabular data as shown in FIG. 6A has been input on the worksheet screen. That is, the table data shown in FIG. 6A is obtained by reversing the matrix of the table with respect to the table data shown in FIG. 5A. It is similar. When a stacked bar graph is created from such table data, the data in the column direction of the table becomes the element data of the graph, and the data in the row direction of the table becomes the item data of the graph, similarly to the graph of FIG. Therefore, as shown in FIG. 6B, the element data of the table is a calculator,
A stacked graph in which the clock sales and item data are month data is created. However, the graph shown in FIG. 6B is not suitable as a monthly sales table, and has a drawback that a graph in a desired format as shown in FIG. 5B cannot be obtained. An object of the present invention is to make it possible to always create a graph in a desired format irrespective of the data arrangement of table data having a matrix structure.

[0004]

The means of the present invention are as follows. The data number counting means 1 (refer to the functional block diagram of FIG. 1; the same applies hereinafter) is used in a graph creating apparatus for creating a graph in which table data having a matrix structure is represented by a correlation between a horizontal axis and a vertical axis. The number of data in the column direction and the number of data in the row direction are counted. Here, the graph is a line graph, a bar graph, or the like that expresses table data in a correlation between the horizontal axis and the vertical axis. The comparing means 2 compares the number of data in the column direction counted by the data number counting means 1 with the number of data in the row direction. When the number of data in the row direction is equal to or less than the number of data in the column direction by the comparing means 2, the first graph creation means 3 associates the data in the column direction with the element data of the graph, and converts the data in the row direction into the item of the graph. Create a graph corresponding to the data. For example, the element data of the graph corresponds to the horizontal axis direction, and the item data corresponds to the vertical axis direction. If the number of data in the row direction is larger than the number of data in the column direction by the comparing means 2, the second graph creating means 4 associates the data in the row direction with the element data of the graph and converts the data in the column direction into the item data of the graph. Create a graph corresponding to.

[0005]

The operation of the means of the present invention is as follows. Now, when creating a graph based on the matrix structured table data input on the worksheet screen, the data number counting means 1
Responds to the graph creation command, and counts the number of data in the column direction and the number of data in the row direction constituting the table data. Then
The comparing means 2 compares the number of data in the column direction counted by the data number counting means 1 with the number of data in the row direction. As a result, when the number of data in the row direction of the table is equal to or less than the number of data in the column direction, the first graph creating means 3 associates the data in the column direction with the element data of the graph and converts the data in the row direction into the item data of the graph. Create a line chart or bar chart corresponding to. On the other hand, if the number of data in the row direction of the table is larger than the number of data in the column direction, the second graph creating means 4 makes the row direction data correspond to the element data of the graph, Create a line chart or bar chart that corresponds to the data of the graph with the item data of the graph. Therefore, it is possible to always create a graph in a desired format, irrespective of the data arrangement in which table data having a matrix structure is created.

[0006]

An embodiment will be described below with reference to FIGS. FIG. 2 is a hardware block diagram of the graph creation device. The table data creation device 11 creates table data based on the data input from the input unit 12 and stores the table data in the table data memory 1.
3 or output on the worksheet screen of the CRT display device 14. The table data created by the input unit 12 has a matrix structure, and includes a data group in a column direction and a data group in a row direction. The table data written in the table data memory 13 is stored in the table data file 15.

When outputting the table data as a graph, the table data analysis unit 16 analyzes the table data read from the table data file 15 into the table data memory 13 and calculates the number of data in the column direction and the number of data in the row direction of the table. And the number of data in the column direction is compared with the number of data in the row direction. The element data memory 17 is a memory in which data read from the table data memory 13 according to the comparison result of the table data analysis unit 16 is set as element data arranged in the horizontal axis direction of the graph. Reference numeral 18 denotes a memory in which data read from the table data memory 13 in accordance with the comparison result of the table data analysis unit 16 is set as item data arranged in the vertical axis direction of the graph.

The graph specification data generating section 19 generates graph specification data representing table data in a correlation between the horizontal axis and the vertical axis. The specification data that can be generated in this embodiment includes standard scales, count scales, and the like. It is a bar graph such as a line graph or a stack. The graph data creation unit 20 creates graph data developed on a line graph or a bar graph. The data created by the graph specification data creating unit 19 and the graph data creating unit 20 are stored in the CRT display device 1.
4 and printed out from the graph printer 21.

Next, the operation of this embodiment will be described. FIG. 4 is a flowchart showing the operation of the graph creation device.
First, when the table data to be graph-created is designated and the type of graph to be created is designated, the table data to be graph-created is read from the table data file 15 to the table data memory 13 (step S1). Then, the table data analysis unit 16 analyzes the table data in the table data memory 13. That is, the number of data in the column direction of the table and the number of data in the row direction are counted (step S2). Next, the number of data in the column direction and the number of data in the row direction of the table are compared (step S3). As a result, when the number of data in the row direction is equal to or less than the number of data in the column direction, the process proceeds to step S4,
The data in the column direction is set in the element data memory 17 as the element data of the table, and the data in the row direction is set in the item data memory 18 as the item data of the table. On the other hand, if the number of data in the row direction is larger than the number of data in the column direction, the process proceeds to step S5, the data in the row direction is set in the element data memory 17 as the element data of the table, and the data in the column direction is stored in the item of the table. The data is set in the item data memory 18. Now, in the table data shown in FIG. 4A, the number of data in the column direction is "6" and the number of data in the row direction is "2". Therefore, in step S3, the data in the column direction> the number of data in the row direction is detected. Therefore, data in the row direction of the table (data from January to June) is set in the element data memory 17, and data in the column direction of the table (sales of calculators and watches) are set in the item data memory 18. Is done.

When the element data and the item data of the graph are determined in this way, a graph creation process is performed based on the contents of the element data memory 17 and the item data memory 18. That is, the specification data is created from the graph specification data creation unit 19 (step S6), the graph data is created from the graph data creation unit 20 (step S7), and the graph data is sent from the CRT display device 14 together with the specification data. Display output (Step S
8). Here, FIG. 4B is an output example when a stacked bar graph is created from the table data shown in FIG.
Originally, table data as shown in FIG. 5A should be created. Even if table data with its row direction and column direction reversed as shown in FIG. ) Can be obtained in the same graph as when the tabular data as shown in FIG.

Although the above-described embodiment has exemplified the stacked bar graph, the same applies to a line graph.

[0012]

According to the present invention, a graph in a desired format can always be created irrespective of the data arrangement in which matrix data is created. Therefore, it is not necessary to consider the data arrangement, and table data can be efficiently created.

[Brief description of the drawings]

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

FIG. 2 is a hardware block diagram of a graph creating apparatus showing an embodiment.

FIG. 3 is a flowchart for explaining the operation of the graph creation device.

FIG. 4 is a diagram showing a case where table data is output as a graph.
5A is a diagram showing a specific example of table data, and FIG. 5B is a diagram showing a graph output example thereof.

5A and 5B are diagrams for explaining a conventional example, in which FIG. 5A shows an example of creating table data, and FIG. 5B shows an example of graph output thereof.

6A and 6B are diagrams for explaining a conventional example, in which FIG. 6A shows another example of creating table data, and FIG. 6B shows an example of graph output thereof.

[Explanation of symbols]

 11 Table data creation device 15 Table data file 16 Table data analysis unit 17 Element data memory 18 Item data memory 19 Graph specification data creation unit 20 Graph data creation unit

Claims (1)

(57) [Scope of request for utility model registration] 1. A graph creating apparatus for creating a graph in which table data having a matrix structure is represented by a correlation between a horizontal axis and a vertical axis, wherein the number of data in the column direction and the number of data in the row direction constituting the table data are determined. Means for counting the number of data to be counted; comparing means for comparing the number of data in the column direction counted by the number of data counting means with the number of data in the row direction; If the number is less than or equal to the number, first graph creating means for creating a graph in which the data in the column direction corresponds to the element data of the graph and the data in the row direction corresponds to the item data of the graph; If the number of data items in the row is larger than the number of data items in the column direction, the data in the row direction is made to correspond to the element data of the graph, and the data in the column direction is made to correspond to the item data of the graph. 2. A graph creation device, comprising: a graph creation means according to claim 2.