The Select Data ダイアログボックス allows you to add and delete series as well as to define the column or data range that should be illustrated by a particular series. The available columns are displayed in a list box at the bottom of the ダイアログボックス. You can add and remove columns by clicking the Select Columns ボタン and activate the required columns in the Select columns ダイアログボックス that appears (note that columns can only be added to, or removed from, this ダイアログボックス via the 結果ウィンドウ).
Axis Values グループボックス内で、 you can define a column, row, or data range that is used as an X-axis for all series. To specify the column, row, or data range for the Y-axis, select a Series in the Series グループボックス and then click into the Y (selected series) field in the Axis Values グループボックス. An asterisk appears next to the field to mark it as the field that can be edited.
In Value Line Charts, you can add an additional X-axis for the selected series if, 例えば、 the X-axes of two series do overlap but do not match entirely. Then the additional axis can be laid over the default axis, which allows to display the data in the correct place.
For Candlestick Charts, please note that the sequence of the series is important in order to display the chart correctly. A corresponding note is displayed in the Select Data ダイアログボックス.
Adding, deleting, and renaming series
The Series グループボックス shows all the data series that are currently included in the chart. You can rename a series by clicking its name in the グループボックス and enter the new name. A series can be removed from the chart by clicking the Delete ボタン. To add a series to the chart, click the Add ボタン, enter a descriptive name, and assign a column, row, or data range to the Y-axis.
To add a series to a chart:
|1.||Make sure that the column you want to display in the chart is listed in the list box at the bottom of the ダイアログボックス.|
|2.||Click the Add ボタン in the Series グループボックス and give the new series a descriptive name.|
|3.||Click into the Y (selected series) field to select it for editing.|
|4.||In the list box below, click into the column, row, or data range you want to assign to the series (or type the corresponding letter into the Y (selected series) field. You can also select a single value or a value range from the list box.|
|5.||In Value Line Charts, optionally assign an individual X-axis in the same way.|
|6.||任意で、 click the Apply ボタン to see a preview of the new series.|
Reloading source data
If the result grid that has been used to create a particular chart has changed since the chart was originally generated, the source data has to be reloaded. This can be done either automatically or by clicking the Reload ボタン in the Chart window ツールバー. The content of a result grid may change because it is in the Editing mode and the data has been edited—such changes will be depicted in the chart immediately if the Auto toggle is activated—or because the result grid has been closed or the underlying SQL script has been changed and/or re-executed.
If the name of a result grid changes, the connection to the chart is broken and DatabaseSpy displays the Select Result grid ダイアログボックス when you click the Reload ボタン or when automatic reloading occurs.
Choose one of the available result grids and click 「OK」.
(C) 2019 Altova GmbH