Most chart formats are shown below to give a quick static image overview of the chart types.
The best place to see the charts is at PulseUI.

Candlestick Chart

  • The table should contain columns labelled open/high/low/close/volume.
  • The table must atleast contain high/low or open/close to allow it to be drawn.
Candlestick Chart

Area Chart

  • The first string columns are used as category labels.
  • Whatever numeric columns appear after the strings represents a separate series in the chart.
Area Chart

Line Chart

  • The first string columns are used as category labels.
  • Whatever numeric columns appear after the strings represents a separate series in the chart.
Line Chart

Bar Chart

  • The first string columns are used as category labels.
  • Whatever numeric columns appear after the strings represents a separate series in the chart.
Bar Chart

Horizontal Bar Chart

  • The first string columns are used as category labels.
  • Whatever numeric columns appear after the strings represents a separate series in the chart.
Horizontal Bar Chart

Stacked Bar Chart

  • The first string columns are used as category labels.
  • Whatever numeric columns appear after the strings represents a separate series in the chart.
Stacked Bar Chart

Horizontal Stacked Bar Chart

  • The first string columns are used as category labels.
  • Whatever numeric columns appear after the strings represents a separate series in the chart.
Horizontal Stacked Bar Chart

Pie Chart

  • Each numeric column represents one pie chart. The title of each pie chart will be the column title.
  • The segments of the pie chart use the string columns as a title where possible. If there are no string columns, row numbers are used.
Pie Chart

Scatter Graph

  • Each numeric column represents one pie chart. The title of each pie chart will be the column title.
  • The segments of the pie chart use the string columns as a title where possible. If there are no string columns, row numbers are used.
Scatter Graph

Radar Graph

  • A radar chart requires 3 or more numeric columns to render sensibly.
  • Each numeric column represents one spoke in the radar. The column titles are used as spoke titles.
  • Each row in the data represents one circle withing the radar.
Radar Graph

Calendar Heatmap

  • The table should contain a date and atleast one numeric column.
  • The first numeric column will be used as the value for that date.
  • Dates should not be repeated. If they are the value selected is not guaranteed.
Calendar Heatmap

Heatmap

  • Each numerical column in the table becomes one column in the chart.
  • The numerical values represent the shading within the chart.
Heatmap

Treemap

  • Starting from the left each string column is taken as one nesting level
  • The first numerical column will be taken as size.
Treemap

Boxplot

  • Each numerical column in the table becomes one boxplot item in the chart.
  • The min/max/median/Q1/Q3 are calculated from the raw data.
  • This is inefficient as a lot more data is being passed than needed but useful for toggling an existing data set view quickly.
Boxplot

Sunburst

  • Starting from the left each string column is taken as one nesting level
  • The first numerical column will be taken as size.
Sunburst

Tree

  • Starting from the left each string column is taken as one nesting level
  • The first numerical column will be taken as size.
Tree