Chapter 18
Graphs
Any result set with at least one numeric column can be charted. Open the Graph menu on the results toolbar:
- Wizard… — opens the graph dialog with the full wizard.
- Bar / Line / Area / Pie — opens straight into that chart type.
- From template — applies a saved configuration.
#18.1The graph window
A large chart on the left; a wizard sidebar on the right.
| Sidebar section | Controls |
|---|---|
| Graph Wizard | Four chart-type buttons: Bar, Line, Area, Pie. |
| X-Axis (category) | Which column supplies the categories. |
| Y-Axis series (numeric) | Tick one or more numeric columns to plot. For pie charts this becomes a single Value (numeric) selector. Numeric columns are detected automatically by sampling the data. |
| Options | Data labels (values printed on the chart), Legend, Auto Refresh, and a manual Refresh button. |
| Templates | Name the current configuration and save it; saved templates are listed and can be applied or deleted. |
| Export | PNG, JPEG (both include the legend) or SVG (plot only). |
#18.2Limits and behaviour
- Cartesian charts plot at most 500 rows; the footer tells you when it is showing the first 500 of a larger set.
- Pie charts show the top 8 categories and fold the remainder into an Other slice.
- With Auto Refresh off, the chart holds a snapshot and the footer says so; Refresh re-runs the query.
- The palette is colour-vision-validated, with separate light and dark variants, and follows the app theme.