Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
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".

More

Add your opinion

Customers
Download Buy

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:

 

Appearance

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

 

Data

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

 

Titles

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

 

Legend

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