AdapTable provides data visualisation in the form of Charts.
Charting is only available if you have included the Charting Plugin when initialising AdapTable.
These charts can either be viewed in the Chart Display (currently above the grid) - or where applicable as a popup (e.g. for Pie Chart, Sparkline etc.)
If you want to show charts when AdapTable starts, then set displayOnStartUp to true in Chart Options. You need to have a chart selected in the Chart State.
Category Charts are charts that let you see data in a typical X and Y axis form.
In the Category Chart wizard you need to select:
One or more Y Axis (Vertical) Columns (numeric only)
An X Axis (Horizontal) Column
You can create a Query to reduce the number of values retrieved in the X Axis (see Queries for more details on creating queries).
Name and (optional) Description
There are a huge amount of different options and properties you can set for Category Charts including Chart Type (e.g. column, line etc), Annotations, Callouts, Transitions and much else.
This function allows you to see the contents of a Column in Pie or Doughnut Chart form.
In the Pie Chart wizard you need to select:
You can choose whether to see the chart as Pie Chart or Doughnut. You are also able to specify 'Others' to group together the smallest set of values.
As well as being able to create a saveable Pie Chart, you are also able to see a whole column as a Pie Chart (via the Column Header menu) or a range of selected cells (via the Context menu).
If there are too many values to view individually (e.g. if its a numeric column) then AdapTable will group the values into ranges for you.
Sparklines are ideal for seeing data as a range.
Like with Pie Charts, as well as being able to create a saveable Sparkline, you are also able to see a whole column as a Sparkline (via the Column Header menu) or a range of selected cells (via the Context menu).
You can choose whether to see the Sparkline as Line, Column or Area.