After you have retrieved data and displayed the record set in a 結果ウィンドウ, 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 ボタンを結果ウィンドウツールバー内でクリックします。 This opens the Select columns ダイアログボックス which lists all the columns that have been retrieved into the 結果ウィンドウ. You can deactivate unwanted columns and change the sequence of the selected columns by dragging them to the desired position in the ダイアログボックス.
チェックされていない列s can later be activated again when you choose the chart data in the Chart Data ダイアログボックス.
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 結果ウィンドウ before you click the Show Data in Chart Window ボタン. Then only the selected columns will appear in the Select columns ダイアログボックス 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 ) ドロップダウンリスト 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.
(C) 2019 Altova GmbH