After you have retrieved data and displayed the record set in a result window, you can open a chart that depicts the selected data. Several types of charts, such as pie chart, bar chart, line chart, area chart, or gauge chart, are available and the appearance of the chart can be customized. Charts are displayed in the Charts window at the bottom of the application, this is where you can also change the chart type and appearance, define what data is to be displayed and how, or export the chart to file, clipboard, or printer.
The easiest way to display a chart window in DatabaseSpy is to retrieve data and then click the Show Data in Chart Window button in the Result window toolbar. This opens the Select columns dialog box which lists all the columns that have been retrieved into the Result window. You can deactivate unwanted columns and change the sequence of the selected columns by dragging them to the desired position in the dialog box.
Unchecked columns can later be activated again when you choose the chart data in the Chart Data dialog box.
If you have retrieved all columns of a table but want to display only specific columns in a chart, you can select one or several columns in the Result window before you click the Show Data in Chart Window button. Then only the selected columns will appear in the Select columns dialog box and only these columns can be used for the chart.
You can choose the X-axis for the chart from the First Column ( Category/X-Axis ) drop-down list or leave the default setting "Auto Enumerated (not coming from source data". In the latter case, all available columns are depicted on the Y-axis and an auto-generated value is used for the X-axis.