Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Mario Figueiredo: "I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".
Johnattan Badden, Manager: "The software is easy to work with and most importantly, report management is extremely easy, even for a novice like me! I am able to create and edit my databases with a few clicks and easily maintain them afterwards. I highly recommend SQLite Maestro to educational institutions: it's easy and flexible, it is exactly what can be good for using in schools and colleges".


Add your opinion

SQLite Maestro online Help

Prev Return to chapter overview Next

Customizing diagram properties

To build a diagram in Diagram Viewer, you should select the source field(s) to be represented in the diagram first. Only numeric types of fields can be used in the diagram, and each selected field corresponds to a separated diagram series. Fields are selected by checking items in the third combo box from the top in the Database group of the Navigation Bar. If the combo box is empty then either data source is not yet selected or it contains no numeric fields.



Diagram Viewer provides a special control for customizing the diagram properties. This control is located in the Properties group of the Navigation Bar and consists of four separate subgroups:



Contains properties responsible for major diagram appearance:


Chart type - defines a way of how the diagram will be represented: as bars, lines, areas, points, pies, or fast lines
Color each points - if checked, each bar, point, line or sector of the diagram has an individual color; if not checked, all the points are colored red
Show axis - defines if the diagram has the axis and background grid or not



Contains the Labels source property which allows you to specify the field for X-axis labels as well as for diagram point marks .



Contains properties for defining titles for different parts of the diagram:


Header - defines the title appeared on the top of the diagram
X-axis and Y-axis - define the titles for diagram axis
Show marks - defines if the diagram point marks are visible or not



The only Visible property of this subgroup specifies whether the legend rectangle should be represented on the right side of the diagram or not.

Prev Return to chapter overview Next