Skip to main content
The Chart widget visualises query results as interactive graphics. A single query can drive any of 25+ chart types — changing the chart type never requires rewriting the query.

Reading the data

Supaboard maps query columns to chart dimensions automatically:
  • The first non-numeric column becomes the X-axis (categories or time values).
  • Numeric columns become series on the Y-axis.
  • For charts that need a third dimension (bubble, scatter, heatmap), a second non-numeric column becomes the grouping field.
If the automatic mapping doesn’t match your intent, use the X-axis → Axis and Y-axis field selectors in the settings panel to override it. Null values in numeric columns are treated as gaps in line and area charts, and as zero in bar and column charts.

Chart types

Select a chart type from the Chart type picker in the settings panel.

Trend over time

TypeBest for
LineA single metric over time
Multiple lineComparing multiple metrics over time
AreaShowing volume or cumulative growth
Multiple areaComparing multiple area series

Part-to-whole

TypeBest for
PieSimple proportions (fewer than 7 slices)
DonutProportions with a center metric
TreemapNested proportions by hierarchy
FunnelDrop-off across sequential stages
Grouped funnelComparing funnels side-by-side

Comparison

TypeBest for
BarHorizontal ranking of categories
ColumnVertical ranking of categories
Grouped barSide-by-side bars for multiple series
Grouped columnSide-by-side columns for multiple series
Stacked barHorizontal absolute totals by segment
Stacked columnVertical absolute totals by segment
Stacked 100% barHorizontal proportional share per category
Stacked 100% columnVertical proportional share per category
RadarMulti-variable comparison on a spider chart
Grouped radarMultiple radar series on one chart

Distribution and correlation

TypeBest for
ScatterCorrelation between two numeric variables
Grouped scatterCorrelation segmented by a category
BubbleCorrelation with a third magnitude dimension
HeatmapDensity or intensity across a 2D grid

Specialised

TypeBest for
ComboMixing bar/column with a line on one chart
WaterfallCumulative contribution of sequential values
SankeyFlow and distribution between categories
GaugeSingle value against a defined range
MapGeographic data plotted on a map

Basic settings

These settings apply to all chart types.
SettingDescription
TitleDisplay title shown above the chart
DescriptionOptional subtitle below the title
Font sizeBase font size for axis labels and legends

X-axis

Controls the horizontal axis (or the category axis for horizontal bar charts).
SettingDescription
Axis fieldThe query column used as X-axis categories
SortSort categories: None, Ascending, or Descending
Axis labelToggle and text for the axis title label
Category labelsToggle the per-category tick labels on the axis
Axis lineShow or hide the axis line itself
Label rotationRotate category labels: , 30°, 45°, 60°, or 90°

Time-based X-axis

When your X-axis contains dates or timestamps, enable Timestamp mode to unlock:
SettingDescription
Date unitAggregate or group by Day, Week, Month, Quarter, or Year
Timestamp sortSort chronologically: Ascending or Descending
Date formatChoose a preset format or enter a custom format string (e.g. YYYY-MM-DD, MMM YYYY)

Custom range

SettingDescription
Custom rangeEnable a fixed minimum and maximum for the X-axis
Show range breakDisplay a break symbol (≈) when the axis skips a discontinuous range

Y-axis

Controls the vertical axis (or the value axis for horizontal bar charts).
SettingDescription
Axis labelToggle and text for the Y-axis title
Axis tick labelsToggle the numeric value labels on the axis
Axis lineShow or hide the axis line
Auto rangeSet a custom minimum and/or maximum for the axis
ScaleLinear (default), Log (logarithmic), or Power
Split axesAutomatically split into multiple Y-axes when series have very different scales

Value formatting

Y-axis tick labels can be formatted independently of the raw data:
SettingDescription
StyleNumber, Percent, Scientific, or Currency
Separator style100,000,000 (Western) or 1,00,00,000 (Indian)
Decimal placesNumber of decimal places to show on the axis
Multiply byScale factor applied before display (e.g. enter 0.001 to show values in thousands)
PrefixText prepended to every axis label
SuffixText appended to every axis label

Dual axis

For multi-series charts (line, bar, column, combo), a second Y-axis can be added to plot series with different units or scales on the same chart.
SettingDescription
Enable dual axisToggle a second Y-axis on the right side
Left axis labelLabel for the primary (left) Y-axis
Right axis labelLabel for the secondary (right) Y-axis
Series assignmentDrag each series to the left or right axis
Left tick labelsShow/hide tick labels on the left axis
Right tick labelsShow/hide tick labels on the right axis

Series colors

Each series has a color swatch in the settings panel. Click any swatch to open a color picker and assign a custom hex color to that series. Colors are saved per-series by name — if the query returns the same column name on the next refresh, it retains its color.

Data point labels

Show the actual value on each data point or bar. Available for bar, column, pie, donut, area, bubble, scatter, and radar charts.
SettingDescription
Show labelsToggle value labels on data points
PositionTop, Middle, Bottom, Inside, or Outside (options vary by chart type)
AngleRotate the label text
FormatCompact notation: None, K (thousands), M (millions), B (billions), T (trillions)
PrefixText before the value
SuffixText after the value
ColorLabel text color
Labels can be configured per series — expand a specific series under Data points → Series to override the global settings for that series only.

Grid lines and goal line

Grid lines

SettingDescription
Show grid linesToggle background grid lines
LayoutHorizontal (default), Vertical, or Both

Goal line

A goal line draws a horizontal reference line across the chart at a specific value — useful for targets, SLAs, or budgets.
SettingDescription
Show goal lineToggle the goal line
ValueThe Y-axis value where the line is drawn
LabelText label shown alongside the line (e.g. Target, Budget)
ColorLine color (defaults to a muted accent if not set)

Legend

SettingDescription
Show legendToggle the series legend
PositionTop, Bottom, Left, or Right
Clicking a legend item in view mode toggles that series on and off interactively — this is a viewer-side interaction and does not change the saved configuration.

Data zoom

Data zoom adds a scrollable range slider below the chart, letting viewers pan and zoom into a subset of the data without changing the query. Available on all chart types except funnel and radar. Toggle it under Settings → Data zoom.

Pie and donut options

In addition to the standard chart settings, pie and donut charts have:

Center total (donut only)

SettingDescription
Show totalDisplay the sum of all slices in the donut center
StyleNumber, Percent, Scientific, or Currency
Decimal placesPrecision of the center value
Prefix / SuffixText around the center value
Multiply byScale factor before display

Percentage labels

SettingDescription
Percentage displayOff, In legend, On chart, or Both
Decimal placesPrecision of the percentage shown
Minimum slice %Hide the label on slices smaller than this percentage (avoids overcrowding)
Last modified on March 11, 2026