JP5663363B2 - Graph creating apparatus and graph creating method - Google Patents

Description

  The present invention relates to a graph creation device and a graph creation method for obtaining a predetermined numerical value from various data and creating a graph on a display device.

  Conventionally, in spreadsheet software adopted in information processing devices, a table called a worksheet is created, and if a range of cells for which a graph is to be created is specified from the table, a graph such as a bar graph or a pie graph is easily created. be able to. These graphs are frequently used for various materials and lecture materials because the situation expressed numerically compared to the table is easier to understand visually.

  On the other hand, the same type of graph creation method is widely used to grasp the situation even in a monitoring device that monitors while recording data acquired from a plurality of sensors. For example, the operation status of the production line in the factory is displayed as a graph on the display screen of the monitoring device, or a graph such as the power consumption of each room is displayed on the display screen of the building air conditioning monitoring device or remote controller. Monitoring is widely performed.

Japanese Patent Laid-Open No. 2001-250078 JP 2005-168611 A

  There are many ways to represent a graph, such as a pie graph, a bar graph, a line graph, or a radar graph. Recent graph creation apparatuses in information processing apparatuses can automatically generate many representations of these graphs, but no graphs or the like partially omitted have been proposed.

  For example, when it is desired to compare two numerical values of a plurality of production lines, the horizontal axis X shows two numerical names of the plurality of production lines, and the vertical axis Y shows this 2 as shown in FIG. A bar graph showing the numerical quantity of one numerical name is used. However, when the numerical quantity of each production line is small relative to the total quantity, there are cases where it is not clear how much the difference is in FIG. Therefore, as shown in (b), a partially omitted bar graph is used in which the lower part of (a) is omitted and the upper part is greatly expressed.

  However, in the currently proposed graph creation apparatus, even though a standard graph of (a) figure can be created, there is no proposal for automatically generating a graph with a part omitted as shown in (b) figure. . For this reason, when the graph shown in FIG. 5B is created, the user is currently producing the graph based on the graphic creation software. In particular, this partially omitted graph requires creation of a graph that combines the values for the allocated memory from the memory allocation, so it takes a lot of time to create and cannot be created in a good-looking manner, etc. There is a problem.

  Accordingly, an object of the present invention is to create a graph that automatically generates a partial omission graph of a graph configured by showing a plurality of objects and numerical values of the objects on two axes, the X axis and the Y axis. It is to propose a device and a graph creation method.

In order to achieve the above object, the graph creation device and the graph creation method according to the present invention are graph creation devices that acquire a predetermined numerical value from various data and create a graph on a display device, the graph creation device When receiving an instruction to create a graph from the input device, the control device displays a graph display screen including a graph display region and an operation region on the display device, and a plurality of objects are displayed in the graph display region. Generates a graph showing the numerical value of the object on the X axis and Y axis, and when a partial omission graph instruction is received from the input device, a blank area is set on one lower limit side of the X axis or Y axis indicating the numerical value The range of the maximum value and the minimum value of the numerical value is expanded in two stages, and the control device performs expansion based on the maximum value as a first stage, and sets the maximum value and the minimum value. Expansion middle After reaching the middle position of the graph between the upper part of the blank area on the lower limit side and the maximum position of the scale in the X-axis or Y-axis direction indicating the numerical value, the maximum Increase value and minimum value.

  According to the present invention, it is possible to create a partial abbreviation graph having a blank area on one lower limit side of the X axis or Y axis indicating a numerical value and expanding the range of the maximum value and the minimum value on the upper limit side. .

1 is a schematic configuration diagram of a monitoring system according to the present invention. It is an operation | movement flowchart of the monitoring system which concerns on this invention. It is a screen transition diagram of the monitoring system according to the present invention. It is a screen transition diagram of the monitoring system according to the present invention. It is a screen transition diagram of the monitoring system according to the present invention. It is a screen transition diagram of the monitoring system according to the present invention. It is a screen transition diagram of the monitoring system according to the present invention. It is a screen transition diagram of the monitoring system according to the present invention. It is the conventional graph figure.

  Hereinafter, the graph creating apparatus according to the present invention will be described in detail with reference to FIGS. In the following description, an example in which the graph creating apparatus according to the present invention is applied to a monitoring system such as a production line will be described. However, the present invention is not limited to the monitoring system such as the production line, but also to an extremely general personal computer or portable terminal, or a network server that provides various information by opening a site on a network. Can be applied. Also, the operation flow program according to this embodiment can be downloaded from a server established on the network, or can be downloaded from the recording medium storing these operation flow programs to the information processing apparatus.

  Here, FIG. 1 is a schematic configuration diagram of a monitoring system according to the present invention. FIG. 2 is an operation flowchart of the monitoring system. 3 to 8 are screen transition diagrams. Note that the symbols and arrows such as A and B on the right side of the screen diagrams shown in FIGS. 1 and 3 to 8 are shown for explanation, and are not displayed on the actual display screen.

  First, a schematic configuration of a monitoring system according to this embodiment will be described with reference to FIG. In FIG. 1, this monitoring system is connected to a production line system 50 that collects data from a plurality of sensors installed at various locations on the production line, and this production line system 50 is connected to the network 10 to analyze the acquired data. And a monitoring device 20 that monitors the production line.

  The production line system 50 includes a line control unit 53 that stores a plurality of sensors 51 installed in various parts of the production line in a database of the storage device 52, and transmission / reception between the line control unit 53 and the monitoring device 20 via the network 10. The line communication device 54 is configured to be included. Here, the line control unit 53 comprehensively controls the production line system 50.

  The monitoring device 20 can be configured by an extremely general personal computer system. For example, in this embodiment, a control device 21 that comprehensively controls the monitoring device 20, a storage device 22 that stores various databases, an input device 23 such as a mouse and a keyboard, a printer 24, and a display device 25. The communication device 26 is included.

  The control device 21 according to this embodiment obtains data from the production line system 50 via the network 10, builds various databases based on this data, stores them in the storage device 22, and builds this data. Data can be displayed in a graph format on a monitoring screen (not shown) displayed on the display device 25, and the production line system 50 can be monitored based on the monitoring screen.

  One of the major features of this monitoring system is that it includes a graph display screen 100 that can display a partially omitted graph 200b.

  That is, on the graph display screen 100, a graph display area 110 and an operation area 120 arranged on one side of the graph creation area 110 are arranged side by side. The control device 21 displays the graph display screen 100 on the display device 25 when an operation for selecting data for creating a graph and a type of the graph is performed on a graph designation screen (not shown).

  In this embodiment, a graph is created with the specified graph type in the graph display area 110, and various operation button groups 150 corresponding to the graph type are displayed in the operation area 120. FIG. 1 shows a graph display screen 100 displaying a bar graph.

  In this embodiment, a plurality of objects 111 on one of the X-axis and Y-axis, and a graph configured by showing the numerical value of the object 111 on the other X-axis or Y-axis, such as a bar graph or a line graph, are displayed. It can be generated with a partially omitted graph.

  That is, when receiving an operation instruction on the graph display screen 100, the control device 21 generates a standard graph 200 a and displays the graph display screen 100 in which the standard graph 200 a is displayed in the graph display area 110 on the display device 25. The graph display screen 100 is provided with a scroll bar 151 constituting the operation button group 150. When receiving the operation of the operation scroll bar 151, the control device 21 switches from the standard graph 200a shown in the display device 25 to the partial omission graph 200b shown in the balloon.

  The operation scroll bar 151 includes an operation button 152 and a movement range bar 153 that indicates a movement range of the operation button 152, and the control device 21 executes the switching operation when the operation button 152 is operated.

  The partial omission graph 200b is provided with a blank band portion 201 that does not display a graph in a predetermined range L9 in the lower part of the memory on the X axis or the Y axis (Y axis in this embodiment) indicating the numerical value of the object 111. . The user can understand that it is the partial omission graph 200b by displaying the band part 201.

  In addition, one of the major features of this monitoring system is that it has a graph display screen 100 that can enlarge a notable part of the graph with an arbitrary size.

  That is, when the partial omission graph 200b is necessary, for example, as shown in the example of FIG. 1, the numerical values of the respective objects 111 are concentrated around “800”, and the difference between the numerical values is the total amount “800”. Is a small difference. In such a case, it is difficult to determine where the total amount “800” can be omitted and which part can be enlarged.

  Therefore, the present inventors pay attention to the point that the user wants to create the partial abbreviation graph 200b because he wants to confirm the difference in the numerical value of each object 111, and the maximum value A of this numerical value is The range L1 of the minimum value B is set as a range to be expanded, and how far to omit is solved by taking a method of freely setting the expansion rate.

  Moreover, when enlarging the range L1 to which attention is paid, there is a problem that if the range L1 is randomly expanded, the user is confused or the visibility is deteriorated. Further, when the enlargement operation is complicated, there is a problem that the operation is distracted and the confirmation of the range L1, which is a point of interest, is sparse.

  Therefore, the inventors have conceived that enlarged display is performed in two stages. That is, in the first stage, paying attention to the point that the line of sight that the user intends to enlarge and display is in the range L1, enlargement is performed by extending the minimum value B in the “0” direction of the numerical value with the maximum value A of the numerical value as a base point. Let According to this enlargement operation, since the user's line of sight does not move greatly, it is possible to reduce the user from being confused and the visibility being lost.

  However, when the maximum value A of the numerical value is used as a base point and the minimum value B is extended in the “0” direction of the numerical value and enlarged, the upper space L20 set above the maximum value A should be used as an area for expansion. I can't.

  In general, in a graph having an X axis and a Y axis, in order to improve the visibility of the maximum value A, a scale is set so as to form an upper space L20 above the graph, and the graph is created. For this reason, when the minimum value B is extended in the numerical value “0” direction with the maximum value A as a base point and enlarged, the upper space L20 becomes a dead space.

  In view of this, the inventors of the first stage extend the numerical value B in the “0” direction of the numerical quantity to a predetermined size by using the maximum value A of the numerical quantity as a base point, and expand it to a predetermined size. The maximum value A is increased in the increasing direction and the minimum value B is expanded in the “0” direction from the center C of L1.

  Specifically, the point E is set at a position obtained by equally dividing the upper point F of the band part 201 in the Y-axis direction and the length L5 of the uppermost part (the uppermost part of the scale) D of the graph display area 110. Further, point C is set at a position where the range L1 of the maximum value A and the minimum value B is equally divided. Then, the first stage expansion operation is performed in a range where C point reaches point E. As shown in the balloon of FIG. 1, when point C reaches point E, this time, the second stage operation is performed as point C. The maximum value A and the minimum value B are extended in the vertical direction centering on, and the enlargement operation is performed.

  As a result, the user's line of sight that was initially above the graph is moved closer to the center in the first stage, and in the second stage, the center is enlarged in the vertical direction with the center as the base point. Therefore, it is possible to reduce the user's confusion and the loss of visibility.

  On the other hand, the present inventors have focused on the fact that the expansion operation of the range L1 is in the Y-axis direction, and adopted the scroll bar 151 that moves the operation button 152 in the Y-axis direction. The movement range bar 153 constituting the crawl bar 151 is formed in a triangular shape that gradually increases in width in the enlargement direction, so that the operation of moving the operation button 152 in the wide direction is an enlargement operation at a glance. Since it can be understood, erroneous operations can be reduced. In addition, as the cursor is moved to the operation button 152 and moved, the standard graph 200a is switched to the partially omitted graph 200b in which the band 201 appears, and the range L1 is gradually enlarged, so that the operation is easy. Become.

  The characteristic partial omission graph display method will be described in detail below with reference to FIGS. 1 and 3 to 8 based on the operation flow of FIG.

  First, the control device 21 displays the graph display screen 100 shown in FIG. 3 on the display device 25 when an operation for selecting the data for creating the graph and the type of the graph is performed on the graph designation screen (not shown). 310). In this embodiment, a bar graph is designated. And the control apparatus 21 will monitor whether the operation button 152 of the scroll bar 151 was operated, if the graph display screen 100 is displayed (step 310).

  Here, in FIGS. 3 to 6, the enlarged region 154 is displayed in a bar format next to the scale. The enlarged region 154 indicates a region in the range L1, and the enlarged region 154 is enlarged or reduced as the range L1 is enlarged or reduced.

  In this embodiment, as shown in FIG. 3, when the operation button 152 is positioned at one end (lower end) P1 of the movement range bar 153, the standard graph 200a is displayed in the graph display area 110, and the operation button 152 is displayed. However, as shown in FIG. 5, when it is located at the other end (upper end) P3 of the moving range bar 153, a partially omitted graph 200b in which the range L1 is enlarged to the maximum is displayed in the graph display area 110.

  As shown in FIG. 4, the range L1 changes the enlargement / reduction direction of the range L1 depending on whether or not the point C has reached the point E. That is, based on the point P2 as the position of the operation button 152 shown in FIG. 4, the lower stage is set to perform the first stage expansion and reduction, and the upper stage is set to perform the second stage expansion and reduction. Furthermore, the magnification of the range L1 is set by the position of the operation button 152 on the movement range bar 153. Therefore, if the position of the operation button 152 moves quickly, the range L1 can be enlarged and reduced quickly.

  Therefore, the control device 21 controls the enlargement / reduction operation of the range L1 at the position of the operation button 152 on the movement range bar 153.

  That is, the control device 21 determines whether or not the operation button 152 has exceeded the point P2 (step 320). If the operation button 152 does not exceed the point P2, the position of the movement range bar 153 of the operation button 152 is determined, the range L1 is expanded by the magnification assigned to this position, and the maximum value A is used as the base point for the expanded figure. The partial abbreviation graph 200b is generated (step 325).

  On the other hand, if the operation button 152 exceeds the point P2, the position of the movement range bar 153 of the operation button 152 is determined, the range L1 is enlarged by the magnification assigned to this position, and the enlarged figure is changed to the point E. A partially omitted graph 200b is generated as a base point (step 335), and the process proceeds to step 315.

  In step 325, it is determined whether the operation button 152 is at the position P1, that is, the position of the standard graph 200a from the state where the first stage graph is generated and displayed (step 330). In step 330, if the operation button 152 is not in the position P1, the process proceeds to step 315. If the operation button 152 is in the position P1, the partial abbreviation graph 200b is switched to the standard graph 200a (step 335), and the process is performed. finish.

  Thus, in this embodiment, the standard graph 200a in the graph display area 110 can be switched to the partially omitted graph 200b by operating the scroll bar 151. Moreover, the magnification and reduction of the range L to be enlarged in the partial omission graph 200b can be easily enlarged and reduced simply by moving the operation button 152. Further, the currently expanded range is indicated by an enlarged area 154.

  Next, a partial omission graph 200c in the second mode of this embodiment will be described with reference to FIGS.

  In the standard graph 200a of FIGS. 1 to 5 described above with reference to FIG. 6, all values of the object 111 are around “800” and the difference is small. However, as a common example, as shown in FIG. 6, for example, there is a case where the unique value Q is small for only one object 111 and there is almost no difference in the values of the other objects 111. In such a case, if the maximum value A and the specific value Q are set in an expansion range, the expansion width becomes small, so that it is difficult to achieve the effect.

  Therefore, in this embodiment, only the singular value Q is separated and the maximum value A and the minimum value B of the remaining object 111 are enlarged by the same method as in the first mode described with reference to FIGS. The second mode is provided. In this embodiment, the partial omission graph 200c in the second mode can be displayed in the graph display area 110 by operating the mode switching button 155 constituting the operation button group 150.

  In the following description, the points different from the first mode will be mainly described.

  First, the control device 21 displays an enlarged range 154b showing the maximum value and the minimum value including the singular value Q, and an enlarged range 154a showing the maximum value A and the minimum value B excluding the singular value Q. The enlargement area 154 also serves as a selection button. If the enlargement area 154a is selected, a partial omission graph 200c shown in FIG. 7 described below is displayed, and if the enlargement area 154b is operated, the maximum value A is unique. The partial omission graph 200b described with reference to FIGS. 1 to 5 is displayed with the range of the value Q as an enlarged region.

  When the enlarged range 154a is selected, a singular point display area 202 sandwiched between the two first band parts 201a and the second band part 201b is displayed below the graph display area 110. That is, a G2 point for setting the first band portion 201a similar to the first mode is set at the bottom of the vertical axis (Y axis), and a singular point display area 202 for displaying a singular value Q on the G2 point. The F2 point for setting the second band portion 201a is set on the F2 point.

  In the partial omission graph 200c in the second mode, the D point, the E point, the maximum value A, the minimum value B, and the like set from the F point to the upper part are the same as those in the first mode.

  In the second mode, as shown in FIG. 7, except that a peculiar value Q is shown between the two band parts (first band part 201a and second band part 201b) at the lower part of the graph display area 110. The change between point F and point D is displayed as in the first mode.

  Here, the length L9 between the G point and the G2 point indicating the value of “0” on the Y axis, the length L30 between the G2 point and the F2 point, and the length between the F2 point and the F point. Although it depends on the number of dots of the L40 display device 25, it is set to have a length of about 1/10 from the G point to the D point.

  Next, the partial omission graph 200d in the third mode of this embodiment will be described with reference to FIG. The feature of the third mode is used when, for example, it is desired to enlarge and display the target portion with the target value “1000” remaining as shown in FIG.

  In the third mode, a third mode button 156 is provided in the operation area 120, and by operating the third mode button 156, the target value “1000” is displayed above the graph display area 110 as shown in FIG. ”Is displayed and the third band portion 201c is displayed.

  Specifically, D1 point is set at the position of the uppermost scale in the graph display area 110, and D point defining the length L10 for displaying the third band portion 201c is set below this D1 point. The And from D to the lower G point, it is the same as the setting of the first mode and the second mode. Therefore, this third mode can be applied to either the partial omission graph 200b or the partial omission graph 200c.

DESCRIPTION OF SYMBOLS 10 ... Network, 20 ... Monitoring device, 21 ... Control device, 22 ... Storage device, 23 ... Input device, 24 ... Printer, 25 ... Display device, 26 ... Communication device, 50 ... Production line system, 51 ... Sensor, 52 ... Storage device 53... Line control unit 54... Line communication device 100. Graph display screen 111. Object 110 110 Graph display area 120 Operation region 150 Operation buttons group 151 Scroll bar 152 Operation buttons, 153... Movement range bar, 154, 154a, 154b ... Enlarged region, 155 ... Mode switching button, 156 ... Third mode button, 200a ... Standard graph, 200b ... Partially omitted graph, 200c ... Partially omitted graph, 200d ... Partial abbreviation graph, 201 ... band, 201a ... first band, 201b ... second band, 201c ... second band, A Maximum value, B ... minimum value, Q ... singular values, L1 ... range, L20 ... headspace

Claims (4)

A graph creation device that obtains predetermined numerical values from various data and creates a graph on a display device,
When the control device of the graph creation device receives an instruction to create a graph from the input device,
Displaying a graph display screen having a graph display area and an operation area on the display device;
In the graph display area, generate a graph showing a plurality of objects and numerical values of the objects on the X axis and the Y axis,
When receiving an instruction of a partial omission graph from the input device, a blank area is set on one lower limit side of the X axis or the Y axis indicating the numerical value,
The expansion of the range of the maximum and minimum values is performed in two stages,
The control device performs, as a first step, enlargement with the maximum value as a base point, and the enlargement intermediate position of the maximum value and the minimum value has an upper part of the blank area on the lower limit side and an X axis or Y indicating a numerical value. After reaching the middle position of the graph between the maximum position of the scale in the direction of the axis, the maximum and minimum values are expanded around this middle position of the graph.
A graph creating apparatus characterized by that. The graph creation device according to claim 1,
A scroll bar for setting an enlargement ratio in the operation area;
The scroll bar includes a movement range bar arranged in parallel with one of the X axis and the Y axis indicating numerical values, and an operation button that moves on the movement range bar.
In the movement range bar, an enlargement ratio is set with respect to the X-axis or Y-axis direction indicating a numerical value,
The graph creating apparatus, wherein the control device sets an enlargement ratio corresponding to a position of an operation button on the moving range bar. A graph creation method for obtaining a predetermined numerical value from various data and creating a graph on a display device,
Receiving a graph creation instruction from the input device, and displaying a graph display screen having a graph display region and an operation region on the display device;
Generating a graph showing a plurality of objects and numerical values of the objects on the X-axis and the Y-axis in the graph display area;
When receiving an instruction of a partial omission graph from the input device, setting a blank area on one lower limit side of the X axis or the Y axis indicating the numerical value;
The expansion of the range of the maximum value and the minimum value is performed in two stages,
As a first step, enlargement is performed using the maximum value as a base point, and the intermediate position between the maximum value and the minimum value is an upper part of the lower limit side blank area, and a scale in the X-axis or Y-axis direction indicating a numerical value. After reaching the middle position of the graph between the highest position and the maximum position, the maximum and minimum values are expanded around this middle position of the graph.
A graph creation method characterized by this. In the graph creation method according to claim 3 ,
A scroll bar for setting an enlargement ratio in the operation area;
The scroll bar includes a movement range bar arranged in parallel with one of the X axis and the Y axis indicating numerical values, and an operation button that moves on the movement range bar.
In the movement range bar, an enlargement ratio is set with respect to the X-axis or Y-axis direction indicating a numerical value,
An enlargement ratio is set corresponding to the position of the operation button on the moving range bar.

Images