Graphing

You can generate graphs from almost any interactive table data. The following graph types are available (click/tap for more information):

Line
Line, Area and Spline charts may have the following properties:
- text or numerical x-axis
- numerical y-axis.
- Restricted y-axis range - if the y-axis data are clustered in a very narrow range using this option will fit the scale of the y-axis to the min and max values in the data, giving a better fit.
- Data labels - if the x-axis is not sufficiently descriptive you may add another field to serve as a data label, e.g. compound name
- Apply zoom settings
Area
Line, Area and Spline charts may have the following properties:
- text or numerical x-axis
- numerical y-axis.
- Restricted y-axis range - if the y-axis data are clustered in a very narrow range using this option will fit the scale of the y-axis to the min and max values in the data, giving a better fit.
- Data labels - if the x-axis is not sufficiently descriptive you may add another field to serve as a data label, e.g. compound name
- Apply zoom settings
Scatter (with or without a regression line)
Scatter charts may have the following properties:
- numerical x- and y-axis.
- Regression line - a regression line calculated automatically.
- Restricted y-axis range - if the y-axis data are clustered in a very narrow range using this option will fit the scale of the y-axis to the min and max values in the data, giving a better fit.
- Apply zoom settings
Bar (vertical)
Bar charts may have the following properties:
- text or numerical x-axis
- numerical y-axis.
- 2D or 3D
- Restricted y-axis range - if the y-axis data are clustered in a very narrow range using this option will fit the scale of the y-axis to the min and max values in the data, giving a better fit.
- Data labels - if the x-axis is not sufficiently descriptive you may add another field to serve as a data label, e.g. compound name
- Apply zoom settings
Bar (horizontal)
Bar charts may have the following properties:
- text or numerical x-axis
- numerical y-axis.
- 2D or 3D
- Restricted y-axis range - if the y-axis data are clustered in a very narrow range using this option will fit the scale of the y-axis to the min and max values in the data, giving a better fit.
- Data labels - if the x-axis is not sufficiently descriptive you may add another field to serve as a data label, e.g. compound name
- Apply zoom settings
Spline
Line, Area and Spline charts may have the following properties:
- text or numerical x-axis
- numerical y-axis.
- Restricted y-axis range - if the y-axis data are clustered in a very narrow range using this option will fit the scale of the y-axis to the min and max values in the data, giving a better fit.
- Data labels - if the x-axis is not sufficiently descriptive you may add another field to serve as a data label, e.g. compound name
- Apply zoom settings
Area Spline
Line, Area and Spline charts may have the following properties:
- text or numerical x-axis
- numerical y-axis.
- Restricted y-axis range - if the y-axis data are clustered in a very narrow range using this option will fit the scale of the y-axis to the min and max values in the data, giving a better fit.
- Data labels - if the x-axis is not sufficiently descriptive you may add another field to serve as a data label, e.g. compound name
- Apply zoom settings
Pie
Pie charts may have the following properties:
- text data labels
- numerical data.
- 2D or 3D
- A legend is displayed below the chart. Click or tap items in the legend to remove/add them to the pie chart.

To view the graphing dialog, select Graph Numerical Data from the left menu (desktop mode) or via the hamburger menu (mobile mode) from the interactive table you wish to graph.

Click here to see the graph dialog

Selecting plot points

You may plot the following data points:

Row Range - type a row range into the min-max fields. The points will be plotted by the row number displayed in the table, ignoring any applied filtering or sorting.
Selected Rows - Any selected rows in the table will be used in the chart. This option respects any ordering applied to the table.
Filter/Search Results - If you have filtered the data in the table, or arrived at the table as a result of a search, this option will chart all visible rows in the filtered table. This option respects any ordering applied to the table.

A maximum of 500 data points can be plotted.

Ordering Plot Points

When using a row range to select plot points the graph will be plotted strictly on row number order as shown in the table.

When plotting data using Selected Rows or Filter/Search Results you should first order the interactive table rows as described here. Any ordering applied to the interactive table will be automatically applied to the graph plot points.

Viewing and Manipulating the Graph

Click Generate Graph one you have set the appropriate options.

Data Points

Hover your mouse or tap data points to see data point information, including any labels that have been applied (selected chart types).

3D View

Selected charts can be viewed in 3D. Use the sliders to the bottom left of the chart to change the viewing angle

Zooming

Selected graph types can be zoomed on the x- or y-axis or both. If you set this option you can click and drag your mouse, or drag your finger on touch enabled devices to zoom the chart on the selected axes. Clcik Reset Zoom on the upper right of the chart to reset to default.

Print or Save the Chart

Click the hamburger icon in the top right of the chart to print or save the chart. You may save in the following formats:

PNG image
JPEG image
PDF document
SVG vector image

Additional Notes

If data does not exist for any y-axis plot point then the chart will display no data on the corresponding x-axis point, resulting in gaps on the chart.

If data does not exist for any x-axis plot point then the plot point will be removed from the data entirely. This will be noted in the x-axis data label.