JP2001250078A - Graph display device and storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the efficiency in graph preparing processing by saving the labor for correcting the format of a graph after the preparation of the graph by automatically reflecting the format of a table in the format of the graph, concerning a graph display device or the like for preparing/displaying the graph based on the table prepared by executing executing spreadsheet software. SOLUTION: When preparing the graph, the format of the relevant graph is automatically set on the basis of the format of the table. Besides, by referring to a format correspondent table stored corresponding to the format of the table and the format of the graph, the format of the graph is automatically changed corresponding to the display form of the graph to be prepared/ displayed.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a graph display device and the like for executing spreadsheet software to create and display a graph based on a created table.

[0002]

2. Description of the Related Art Conventionally, graph creation based on a table created by spreadsheet software (a so-called worksheet, referred to as a "table" throughout the present specification) is performed as follows.

[0003] First, the user, in the created table,
Specify the range of cells containing the data that will be the elements of the graph you want to create. Next, the type of graph you want to create (for example,
Bar chart, pie chart, etc.). Then, a graph of the selected type is automatically created using the data in the specified range. At that time, the graph is created based on a graph format (for example, the color of the graph area display, the character color of the character display, the font, etc.) predetermined for the type of the selected graph. After that, in the created graph, the color of the graph area display, the character color of the character display, the font, and the like can be corrected.

[0004]

However, usually,
For tables created with spreadsheet software, the user
In many cases, each cell is color-coded in consideration of readability, or the format of the character font, character color, etc. of the cell to be emphasized is changed.

However, in the conventional graph creation method, the format of each cell of the table is not considered, and the graph is automatically created according to the format of the graph specified in advance. Therefore, in the created graph, if there is an area display or a numerical value to be emphasized, the user needs to make a correction later. That is, in the conventional method, it is difficult to create a graph directly reflecting the format of a table. In addition, when the graph to be created is large or when there are many corrections, the user has to make corrections, which is often troublesome.

SUMMARY OF THE INVENTION An object of the present invention is to automatically reflect a table format in a format of a graph to be created, eliminate the trouble of modifying the format of the graph after creating the graph, and improve the efficiency of the graph creation process. It is to provide a graph display device or the like which can perform the above.

[0007]

According to the first aspect of the present invention, there is provided a graph display device for specifying a format (for example, a character format or a font format in FIG. 2) when displaying an item and data included in each item. First format specification means (for example,
A first display unit (for example, FIG. 2) that displays the items and data included in each item (for example, FIG. 2) based on the format specified by the first format specification unit. When a graph is displayed based on the display device 3) of FIG. 1 and the items and the data included in each item, a second format that specifies a format based on the format specified by the first format specification unit Based on the format specified by the format specification unit (for example, CPU1 in FIG. 1; steps S3 to S6 in FIG. 4) and the format specified by the second format specification unit, a graph display of the items and the data included in each item ( For example, second display means (for example, the display device 3 in FIG. 1) for performing FIG. 3) is provided.

According to the first aspect of the present invention, in the graph display device, the first format designating means designates a format for displaying an item and data included in each item, and
Display means for displaying the items and the data included in each item based on the format specified by the first format specification means, and the second format specification means includes the data included in the items and each item. When performing a graph display based on the data to be displayed, a format is specified based on the format specified by the first format specifying unit, and the second display unit specifies the second format.
The items and the data contained in each item are displayed in a graph based on the format specified by the format specification means.

Therefore, since the format of the graph is automatically set based on the format specified by the first format setting means, the trouble of setting the format when creating the graph can be saved, and the efficiency of the graph creation process can be improved. Can be planned.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment according to the present invention will be described below in detail with reference to FIGS. First, the configuration will be described. FIG. 1 is a block diagram showing the internal configuration of a graph display device 10 according to the present invention. In the figure, a graph display device 10 includes a CPU (Central Processing Unit).
1, input device 2, display device 3, printing device 4, transmission control device 5, RAM (Random Access Memory) 6, ROM (Re
ad Only Memory) 7, a storage device 8, and a storage medium 8a.

The input device 2 includes a keyboard, a mouse, and the like. The keyboard has cursor keys, numeric input keys, and various function keys, and outputs to the CPU 1 a signal indicating a key pressed by the keyboard. With this input device 2, a range of data of a table for which a graph is to be created,
Change the format of the created graph.

The display device 3 is a CRT (Cathode Ray Tub).
e) and the like, and displays a table created by spreadsheet software and a graph created based on the table.

The printing device 4 is constituted by a printer such as a laser printer or an ink jet printer, and prints and outputs a table created and a graph created based on the table.

The storage device 8 has an independent storage medium 8a in which programs, data and the like are stored in advance, and this storage medium 8a is constituted by a magnetic or optical storage medium or a semiconductor memory. ing. The storage medium 8a is fixedly provided in the storage device 8 or is removably mounted, and stores various application programs corresponding to the graph display device 10, data processed by various processing programs, and the like. Remember. The storage medium 8a stores a graph creation processing program executed by the spreadsheet software in addition to the spreadsheet software. Also, a format correspondence table 81 referred to in a second embodiment described later is stored.

The program, data, and the like stored in the storage medium 8a may be partially or wholly received from the transmission control device 5 from a server or a client via a communication line such as a network line. Further, the storage medium 8a may be a storage medium of a server configured on a network. Further, the program,
Some or all of the data and the like may be installed in these devices via a communication line such as a network line.

The RAM 6 stores, from among various application programs corresponding to the graph display device 10 and stored in the storage medium 8a, an application program designated by the CPU 1, various input data inputted by the input device 2, and the like. It has a work memory area for storing processing results.

The ROM 7 stores an IPL (Initial Program) executed by the CPU 1 when the graph display device 10 is started.
m Loader) program and various initial setting values related to the IPL program.

The CPU 1 includes an application program designated from various application programs stored in the storage medium 8a, and an input device 2
Are stored in a work memory area in the RAM 6. The CPU 1 executes various processes according to the various input data in accordance with the application programs stored in the RAM 6, stores the processing results in a work memory area in the RAM 6, and displays the results on the display device 3.

The CPU 1 reads out and executes spreadsheet software stored in the storage medium 8a. Then, based on the table created by the spreadsheet software, a graph creation processing program is executed, and a graph creation processing described later is executed.

Next, the operation of the graph creation processing in the spreadsheet software executed by the CPU 1 will be described using two embodiments.

(First Embodiment) FIG.
FIG. 6 is a diagram showing an example of a table created by spreadsheet software, which is displayed in FIG. In the table of FIG.
Each cell in the first row is called an item name cell, and cells in the range from the second row B column to the sixth row D column are called data cells.

In the item name cell 11, the name of the data cell in each column is set. Each of the item name cells 11 has a character color format and a font format. In the item name cells 11, “Tokyo” is orange, “Osaka” is green, and “Fukuoka” is blue. The text color format is set to display in text. Further, among the data cells, the numerical value of “560” is set in the cell 12 in the third row and the C column, and the numerical value of “480” is set in the cell 13 in the fifth row and the B column. It is displayed in italics. Also, “1” is stored in the cell 14 in the 5th row and the D column.
The value of “800” is stored in the cell 15 in the sixth row and the C column at “280”.
A numerical value of “0” is set in the cell 16 of the 6th row and the D column, and a numerical value of “2500” is set, and each numerical value is displayed in bold and bold italic font.
Indicates that the character color format is set to red and the font format is set to bold italic.
The font color format is set to blue and the font format is set to bold italic.

Based on this table, the CPU 1 executes a processing program stored in the storage medium 8a to create a graph. Then, the CPU 1 converts the created graph into
It is displayed on the display device 3.

FIG. 3 is a bar graph created by the graph creation processing executed by the CPU 1 based on the table of FIG. 2 and displayed on the display device 3. In the figure, for the sake of simplicity, the display part of the bar graph is called area display, and the character display part on the right side of the bar graph is called character display.

In FIG. 3, a graph area display 100 has a display color format, and a character display 200 has a character color format and a font format. The format of each cell in the table of FIG. Will be reflected in the format.

That is, the item name cell 11 in FIG.
Is set as the display color format of the area display 100 corresponding to the graph. For example, an area display 100 corresponding to “Tokyo” in the item name cell 11 in FIG.
Is set to orange, the area display 100 corresponding to "Osaka" is set to green, and the area display 100 corresponding to "Fukuoka" is set to blue, and displayed on a graph.

The font format and character color format of each data cell are reflected in the font format and character color format of the corresponding character display 200 of the graph. For example, the format of the cell 12 is reflected in the character display 22 of the graph, the character color format of the character display 22 is set to red, and the font format is set to bold italic, and displayed. Similarly, for the other data cells 13 to 16, the respective character color formats and font formats correspond to the corresponding character displays 23 to 26.
Are set and displayed in each character color and font format.

Next, the operation of creating the graph of FIG. 3 from the table of FIG. 2, that is, the operation of the graph display process executed by the CPU 1 will be described.

FIG. 4 is a flowchart showing the operation of the graph display processing executed by the CPU 1.

First, in the table created by the spreadsheet software, when a range of cells containing data for which a graph is to be created (step S1) and a graph display form to be created are selected from the input device 2 (step S2). ), CPU1
Indicates each item name cell 11 in the specified cell range.
It is determined whether or not a format is set in (step S
3).

If it is determined that the format is set in the item name cell 11 (step S3: YES), the CPU
1 reflects the format set in the item name cell 11 in the format of the graph (step S4). That is, CP
U1 displays the color set in the character color format of the item name cell 11 in the area display 10 corresponding to the item name cell 11.
Set the display color format to 0.

The CPU 1 reflects all the formats of the item name cell 11 in the graph format, or determines that no format is set in the item name cell in step S3 (step S3: NO). , Step S
It is determined whether a format is set for each data cell in the range of cells specified in step 1 (step S).
5).

If it is determined that the format is set in the data cell (step S5: YES), the CPU 1 reflects the format set in the data cell on the format of the graph (step S6). That is, the CPU 1 sets the character color and font format of the data cell to the character color and font format of the character display 200 corresponding to the data cell.

When all the formats of the data cell are reflected in the graph format, or when it is determined in step S5 that the format is not set in the data cell (step S5: NO), the CPU 1 returns to step S2. A graph is created in the selected graph display mode, and the created graph is displayed on the display device 3 (step S7).

As described above, in the spreadsheet software, the format of the table created and set is automatically set and reflected in the format of the corresponding graph. Processing efficiency can be improved.

(Second Embodiment) Next, a second embodiment will be described. In the second embodiment, the following configuration and operation are further added to the first embodiment.

In the first embodiment, the CPU 1
When performing the graph creation process, the item name cell 11 of the table
And the format of the data cell is set as it is to the format of the graph to be created. However, in the second embodiment, the format of the graph to be created can be arbitrarily set by using the format correspondence table 81. Can be changed to
FIG. 5 is a diagram showing the format correspondence table 81. This format correspondence table 81 is stored in the storage medium 8a.

The format correspondence table 81 shown in the figure is a correspondence relationship between each format of the item name cell and the data cell and the corresponding format of the area display 100 and the character display 200 in the table created by the spreadsheet software. Are set and stored, and stored in association with each graph display mode. In the figure, the format correspondence table 81 stores the formats of a bar graph and a pie graph as a graph display form.

Hereinafter, the CPU in the case where the bar graph is selected and the case where the pie graph is selected as the graph display mode will be described.
1 will be described. At this time, the description will be made assuming that the settings shown in FIG. 5 are made in the format correspondence table 81.

First, a case where a bar graph is selected as a graph display mode will be described. The character color format set in the item name cell 11 is reflected in the display color format of the corresponding graph area display 100. That is, if a color is specified in the item name cell, the area display 100 of the graph is set to that color. If the item name cell is designated with shading, the corresponding graph area display 100 indicates that if the value of the data included in the item name cell is 30 or less, the designated shaded area is displayed. If so, the color is set to the color corresponding to the designated type of hatching. As described above, the setting can be specified also by the value of the included data.

Further, the character color format and font format set in the data cell are respectively reflected in the character color format and font format of the corresponding character display 200 of the graph. That is, if a color is specified in the data cell, the character display 200 of the graph is set to that color.

Next, a case where a pie chart is selected as a graph display mode will be described. The character color format set in the item name cell 11 is reflected in the display color format of the corresponding graph area display 100. That is, when the item name cell is designated with shading, the area display 100 of the corresponding graph is set to a color corresponding to the type of the designated shading. For example, when the shading is designated, the display area of the corresponding graph is set to red, and when the shading is designated, the display area of the corresponding graph is set to blue.

The character color and the font format set in the data cell correspond to the area display 10 of the corresponding graph.
In the display color of 0 and the character display 200 and the character color format,
Each is reflected. That is, when a color is specified in the data cell, the corresponding area display 100 and character display 200 of the graph are set to that color. Also, according to the number of character points of the displayed data, the corresponding character display 2
The color of 00 is set. For example, if the number of character points of the displayed data is 8 points or less, the character display of the corresponding graph is set to yellow, and if it is 9 points or more and 12 points or less, it is set to blue.

The processing performed by using the format correspondence table 81 specifically corresponds to the processing of steps S4 and S6 in FIG. 4 described in the first embodiment. That is, the CPU 1 refers to the format correspondence table 81 stored in the storage medium 8a when setting the format of the item name cell 11 or the data cell of the table by reflecting it in the format of the corresponding graph. , And set the format of the corresponding graph.

Therefore, by setting the format of the graph with reference to the format correspondence table 81, a more effective graph can be created according to the type of the graph display mode.

The contents of the format correspondence table 81 can be changed and stored, and the format of the graph can be arbitrarily changed.

In this embodiment, the character color format and the font format of the item name cells and data cells of the table are reflected and set in the format of the graph to be created. It is also possible to configure so that the character type format and the character point number format of the item name cell and the data cell are reflected in the graph format.

[0048]

According to the first or fifth aspect of the present invention,
Based on the format specified by the first format setting means,
Since the format of the graph is automatically set, it is possible to save the trouble of setting the format when creating the graph and to improve the efficiency of the graph creation process.

According to the second aspect of the invention, in addition to the effects of the first aspect, the setting of the graph format at the time of creating the graph can be automatically performed based on the table format. it can.

According to the third aspect of the present invention, in addition to the effects of the first or second aspect of the present invention, it is possible to automatically set a graph format corresponding to a selected graph display mode. Further, by changing the association of the format stored in the storage means and storing it, the setting of the graph format can be arbitrarily changed.

According to the fourth aspect of the present invention, in addition to the effect of the first aspect of the present invention, the format of the graph can be set based on the specified data value. .

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating an internal configuration of a graph display device 10.

FIG. 2 is a diagram illustrating an example of a table created by spreadsheet software;

FIG. 3 is a diagram illustrating an example of a bar graph created based on a table.

FIG. 4 is a flowchart illustrating an operation when creating a graph based on a table.

FIG. 5 is a diagram illustrating an example of a format correspondence table 81.

[Explanation of symbols]

 Reference Signs List 10 Graph display device 1 CPU 2 Input device 3 Display device 4 Printing device 5 Transmission control device 6 RAM 7 ROM 8 Storage device 8a Storage medium 9 Bus 11 Item name cell 12-16 Data cell 21 Area display 22-26 Character display 81 Format Correspondence table

Continued on the front page (51) Int.Cl. ⁷ Identification symbol FI Theme coat II (reference) G06T 11/60 100 G06T 11/60 100B F term (reference) 5B009 NA03 PB06 5B050 AA10 BA19 CA07 FA02 FA05 FA09 FA13 5B069 DD20 FA04 5E501 AA02 AA14 AC17 BA05 CA03 CB02 CB09 DA12 EA12 EB05 FA14 FB26

Claims (5)

[Claims] A first format designating means for designating a format for displaying an item and data included in each item; and a format specified by the first format designating device. A first display unit for displaying data included in the item; and a graph display based on the item and the data included in each item, based on a format specified by the first format specification unit. A second format designating unit for designating a format related to the graph display; and a second format designating unit for performing graphical display of the items and data included in each item based on the format designated by the second format designating unit. A graph display device, comprising: display means. 2. The method according to claim 1, wherein the first format specification unit specifies a format of an item cell and a data cell when displaying the item and data included in each item. 2. The graph display device according to claim 1, wherein a format of a graph area display and a character display format is specified based on a format of an item cell and a data cell specified by the first format specification unit. 3. A storage system for storing a graph display format corresponding to each format specified by the first format specification unit in association with each of a plurality of graph display modes, wherein the second format specification unit is provided. Specifies a format for a desired graph display form from among the plurality of graph display forms based on the association of the format stored in the storage means, wherein the second display means comprises: 2. The data included in the item is displayed in a graph in a display form designated by the second format designation means.
Or the graph display device according to 2. 4. A method according to claim 1, wherein said second format designating means designates a format for graph display based on a format designated by said first format designating means and a value of data included in each of said items. The graph display device according to any one of claims 1 to 3. 5. A storage medium storing a program for creating a graph based on a table created by spreadsheet software and displaying the graph, and displaying items and data included in each item. A computer-executable program code for specifying a format at the time, and a computer-executable program code for displaying the items and data included in each item, based on the specified format, A computer-executable program code for specifying a format related to the graph display based on the specified format when performing a graph display based on the items and data included in each item; Based on the format related to the graph display
A computer-executable program code for displaying a graph of the items and data included in the items, and a program including the following.