Building diagrams and graphs

Procedure of creating diagrams and graphs is intended for formation of the graphic representations evidently illustrating values ratio of chosen characteristics for separate objects of electronic map.

To processing in this procedure those objects are exposed which preliminary were marked on a source electronic map (for example, by means of search and mark).

Graphs are built on the basis of values of the semantic characteristics of the selected objects - Semantics bookmark, or according to the data from the database - Table bookmark.

To create a graph by the table, you need to customize the connection to the database.

To connect to the database, among the database drivers supported by the program select from the drop-down list «DB Driver» the database driver to which you want to connect.

After that the other fields of parameters of connection are filled. Depending on the chosen type (driver) of the database (DB), the fields «DB Server» and «DB Name» are filled in different ways:

- for the Dbase and Paradox databases, the «DB Server» field is not filled, and the «DB Name» field must contain the full path to the database file, for choice of which you can use the button of the dialog call for selecting the file ;

- for MS SQL Server databases, the «DB Server» field should contain the name of the database server registration in the network, and the «DB Name» field - the registered name of the database;

- for Oracle databases it is necessary to specify in the «DB Alias» field, the registered database alias which should be registered in the file tnsnames.ora (the detailed description is in the Oracle DBMS administration manual);

- when connecting to the database using ODBC, in the drop-down list «ODBC DSN», you should select the name of the customized user connection registered in ODBC.

If the connection to the selected database requires authorization, you must fill in the «DB User» and «Password» fields.

When saving settings into the project, you must specify the name of the connection to the database.

Set the link type of the map object and the selected table:

- there is no link (the values from the table);

- internal link (by the field of the LinkObject table). To set the internal link, the table must contain the LINKOBJECT field, which contains the unique number of the map object;

- conditional link (table field <-> semantics of object). Specify the name of semantics and the name of the field in the settings. Link of objects with the table is carried out by identification of value of semantics chosen from the list of semantics of selected objects and a field of the table, chosen of the list of link fields.

To change type of the diagram or the graph press the Edit button. Chart editor window becomes active.

In the environment of editor it is possible to set properties of the graph (Chart page) and its series (Series page). The contents of the editor's window are represented a tabulated notebook. The first for a new graph the Chart bookmark is always shown and for Chart page the Series bookmark is always the first.

Each of bookmarks on Chart page is intended for parameters setup of graph.

Series bookmark contains the graph series. Set of graph points is named series. A separate line or a number of columns correspond to a series on the graph. After pressing Title button it is possible to define title of a series.

Twice having clicked the left mouse button on the pictogram representing the graph, the window of a choice of diagram type becomes active. For changing the graph color make double click on a color square.

Common settings bookmark is used for setting graph's common parameters, such as its 3Dimensions, indents from margins, possibility of zooming, scrollbars etc.

Axes bookmark is used for definition of graph axes. With the help of switches Axis it is possible to select the necessary axis - left, right, top or bottom. On a page defined by the Scale bookmark the properties of a values scale on a selected axis are set. The Auto switch determine the automatic scaling of the data - minimum and maximum are calculated dynamically, outgoing from the current values of a series. At cancellation of automatic scaling it is possible to set automatic scaling of minimum value (Minimum) or of maximum (Maximum) value (mark Auto). To set the value of a maximum and (or) a minimum manually it is necessary to click the appropriate Change button. Step of a scale on an axis is selected automatically, if Step (Desired increment) is set into 0. To set the fixed value of step it is possible, having clicked Change button. The Title bookmark is used for definition of the title text on an axis, angle of its location, size and font, by which the title is output. The Labels bookmark is used for definition of labels parameters (visibility of labels, font, angle of lean, size, interval between labels, format, style). Use the Axis ticks bookmark to set parameters of an axis line.

Titles bookmark contains tools for definition of parameters of the graph title - title text, its font, alignment etc.

With the help of a Legend bookmark you can define the legend parameters - graph area, where the explaining information is located.

Panel bookmark is intended for parameters setup of the panel, on which the graph is located.

Walls bookmark is intended to set parameters (visibility, background color, border, pattern, size) of the left and bottom "wall" of the graph.

Each of bookmarks on Series page is used to set series of data values.

Series format bookmark is used for definition of property of the graphic palette, graph lines and other personal settings of a current series.

On Common settings bookmark you can set data formats of the values and percents, and also legend visibility.

Series marks bookmark is intended for placing marks - the values above points of a series. Marks are displayed on a graph, if the switch Visibility is marked. Style switches define the view of marks.

To build a graph by the table it is necessary:

1. To activate the Data source page of the Series bookmark.

2.  On the Data source page, you define the data source for the current series.

The drop-down list below the bookmark allows you to define the type of data source for the series:

- No data - no data source is assigned to the series.

- Random values - a set of random numbers. It is useful at forming the workpiece of series, so that without specifying the real data, visually to assess the capabilities of a series.

- Dataset - allows you to specify (as a data source) the dataset, fields values of which will be used to form series points. The data set includes records only for the selected objects. X list allows you to select the field of the dataset the values of which will be sequentially laid on the abscissa axis. Y list allows you to select the field of the dataset the values of which will be sequentially laid on the ordinate axis. The correspondence between fields values along two axes is determined by the belonging to the same dataset record. Selecting a field in the Labels list links its values in the form of labels to the abscissa axis.

The information displayed in the chart can be saved in BMP or EMF file, or to plot as OLE-document. For changing the scale of a numerical axis draw demanded area on the diagram by the left mouse button. The combination of Shift key and the pressed right mouse button allows to change a position of the chart.

Print button is used for print of the graph.

At activation of dialog the linear graph on the basis of values of the semantic characteristic which is located by the first in the list automatically will be built.

Example of building the graph

To build graphs of values of semantic characteristics it is necessary to execute following actions:

1. To mark objects on a map and to start the application onto an execution.

2. To specify names of semantics on the basis of which values the graphs will be built. For this purpose place the mouse cursor at demanded semantics and click on it twice (from the left party from the name there will be a badge ' + '). For a cancellation of a choice repeat this actions (the badge ' + ' will disappear).

3. Press Edit button if the graphs settings must be changed.