Chart
The chart visually shows dependence of values of one field on the other one. Two-dimensional chart is the most widely used type of charts. The independent column values are set on its horizontal axis, and the dependent column values that comply with them are set on its vertical axis.
Interface
Operations
Configure fields: show/hide the list of the data set fields.
General settings: general chart settings. It is possible to open the configuration window using the toolbar or by double clicking on the charting area with the left mouce button. A part of general settings (Rotate 90° – rotate the chart, Rationing, Navigator, Animation) is available on the toolbar.
Series editor: settings of the series list and parameters of particular series (graphic charts).
Configure axes.
Rationing: set the same scale for all charts.
Navigator: detail any chart section along the X axis, it is displayed under the axis. Moving the navigator edge, it is possible to select the required chart area.
Rotate chart enables to reverse the axes positions, namely, the field along the X axis is moved to the Y axis, and vice versa, the Y axis becomes the X axis.
Pointer mode enables to zoom in the selected area view (also refer to How to Use the Constructed Chart).
Drag mode enables to move the chart on the screen (refer to How to Use the Constructed Chart).
Zoom in enables to zoom in the chart area.
Zoom out enables to zoom out the chart area.
Reset zoom enables to reset all zoom in settings (for both axes).
Reset zoom Y enables to reset zooming in of the chart along the Y axis but the X axis zooming in is preserved.
Export enables to save the chart as it is displayed in the view window in the file with an image. The name of the format that has been selected for export will be displayed in this menu option:- Export to SVG.
- Export to PNG.
- Export to JPG.
- Export to PDF.
Chart Configuration
The fields that can be used as the chart axes are displayed in the left list. For this purpose, it is required to drag (Drag&Drop) necessary fields to the chart construction area holding down with the left mouse button: to the upper part - the Y axis is set, to the lower part - the X axis is set. When setting the Y axis, the series addition is configured, namely:
- Type: the chart type is set.
- Name: series name (namely, the definite graphic chart). This name will be displayed in the chart legend.
- Y field: the field is set for Y axis.
- Color field: the numeric field that is projected onto the color chart.
When configuring the X axis settings, it is also possible to use the buttons in the fields list (to the right from the field name):
Use as abscissa field (CTRL+X).
Use as caption field (Alt+L).
Thus, the X axis values field and caption field (the axis points marks) must not necessarily coincide.
The following types of charts are available:
Lines.
Areas.
Splines.
Columns.
Interval areas.
Smoothed areas.
Smoothed areas with intervals.
Bubble.
Scatter.
Waterfall.
Errors.
Polygon.
Columns with ranges.- Heatmap.
- Candlestick.
- OHLC.
All main settings are available either using the context menu options (it is required to press the chart area with the right mouse button), or the toolbar buttons (in the upper part over the chart). The chart settings are described above in this article.
How to Use the Constructed Chart
When using the chart, it is possible to zoom in the view of the whole chart or its random part. For this purpose, it is required to enable pointer mode on the toolbar, and then it is required to select the chart area that must be viewed in more details by holding down the left mouse button. As soon as the mouse button is released, it will be possible to zoom in the selected area view. The procedure is to be repeated to zoom in again. To provide more detailed view of the chart with the set zooming in, it is required to enable drag mode. It will enable to move the chart on the screen.
To return to the initial chart scale, it is required to use reset zoom.
Articles in Section: