A chart is a complex output control that allows users to display a visual representation of a data set in the user interface. Widely used in data analysis and presentation, charts are a vital component of dashboard reports. Each chart must be associated with a Table Named Range (TNR) from the workbook.

Inserting a chart into the web interface can be done by dragging and dropping a Chart module from the context menu into the staging area of the User Interface Designer.

Once placed, click on the chart to define its properties from the properties menu. Begin by selecting the Table Named Range (TNR) that contains the target data for the chart from Table Named Range selection. This range should include both the data and the column headers for the chart. Currently, only horizontally-oriented Table Named Ranges (TNR) are supported (i.e. columns are displayed horizontally).

Select your chart from the Chart Type dropdown menu. This selection will be used to populate the appropriate chart configuration options in the properties menu.

The available charts can be categorized into three subsections:

  • Single-Axis Charts: Donut, Pie, Funnel, and Pyramid
  • Multi-Axis Charts: Area, Bar, Columns, Line, Radar, Scatter
  • Special Charts: Bubble, Combo
  • Gantt Chart