Docs/Analytics/Chart types

Chart types

All chart types available in Discover and Mosaics, with field requirements and settings reference.

TracerWeaverLuminaryUpdated June 2026 · 6 min read

✦

In this section

Part of Celiq's semantic layer platform. Connect your warehouse, model your data once, query it everywhere.

Celiq picks a chart type automatically when you run a query — based on your field mix. You can override it by clicking the chart type picker in the results toolbar. If your current fields don't satisfy a chart's requirements, Celiq shows a warning and auto-selects a compatible type.

Saved in Scenes — your chosen chart type and all settings are saved with the Scene and restored when you reopen it.

Bar chart

Requires: 1–2 dimensions · 1–5 measures

Compare values across categories. Use grouped for side-by-side comparison, stacked for part-to-whole relationships, and 100% stacked for proportions.

Settings: Layout (grouped / stacked / 100%), orientation (vertical / horizontal), corner radius, reference lines, data labels, sort order, grid, axes, legend.

Line chart

Requires: 1–2 dimensions · 1–5 measures · Works best with a date dimension

Show trends over time. Multiple measures render as separate lines.

Settings: Line style (solid / dashed / dotted), width (1–3 px), markers (on/off + shape), smooth curve, fill area, null value handling (gap / zero / connect), reference lines, X label rotation.

Area chart

Requires: 1–2 dimensions · 1–3 measures

Like a line chart but with filled regions below each line. Use Stacked to accumulate measures into a total.

Settings: Stacked mode, smooth curve, null handling, X label rotation.

Combo chart (Bar + Line)

Requires: 1–2 dimensions · 2–4 measures

Combines bars (left Y axis) and lines (right Y axis). The default assigns the first measure to bars and the rest to lines — you can override this per measure in Series assignment.

Ideal for comparing a volume metric (e.g. revenue as bars) against a rate metric (e.g. conversion rate as a line).

Settings: Per-measure type (bar or line), dual Y axis titles, reference lines.

Pie chart

Requires: exactly 1 dimension · exactly 1 measure · max 8 categories recommended

Classic part-to-whole chart. Slices beyond the maximum are grouped into Other.

Settings: Label type (percent / value / label / label + %), max slices, group others toggle, start angle.

Donut chart

Requires: exactly 1 dimension · exactly 1 measure

Like a pie chart but with a configurable centre label showing the total or percentage.

Settings: Inner radius, centre label (total / percent / none), max slices, group others.

Scatter chart

Requires: 1 dimension · exactly 2 measures

Shows correlation between two numeric measures. Each row becomes one dot. The dimension is used for tooltips and colour.

Settings: Trend line, log scale on X and Y axes.

Bubble chart

Requires: 1 dimension · exactly 3 measures

Like scatter but the third measure controls bubble size. The larger the value, the larger the bubble.

Settings: Min/max bubble size, trend line.

KPI (number)

Requires: 0–1 dimensions · exactly 1 measure

Displays a single large number with optional sparkline and target comparison.

Settings:

Font size — auto (scales to container), small, medium, large
Number format — auto (abbreviates large numbers), currency, percent, number
Target value — shows a delta below the metric (↑ above target / ↓ below)
Trend direction — whether higher or lower is better (controls delta colour)
Sparkline — thin trend line beneath the value

Table

Requires: any combination of dimensions and measures

Full tabular display. Every column in your result set is shown.

Settings:

Row numbers — prepend a row index column
Wrap text — allow multi-line cells
Compact rows — reduced row padding
Show totals — add a summary row summing all numeric columns
Freeze columns — keep N leftmost columns sticky when scrolling horizontally
Column formats — per-column override: auto / currency / percent / number / text
Conditional formatting — highlight cells based on rules (column, operator, value, background colour, text colour)

Heatmap

Requires: exactly 2 dimensions · exactly 1 measure

A colour-coded matrix where the two dimensions form rows and columns, and the measure value sets the cell intensity.

Settings:

Color scale — Indigo → Teal · Teal → Red · Navy → Amber · Sequential
Show cell values — display the numeric value inside each cell
Row/col labels — toggle axis labels on and off

Waterfall chart

Requires: exactly 1 dimension · exactly 1 measure

Shows how a starting value changes through a sequence of positive and negative steps. Useful for P&L, pipeline changes, or budget variance.

Settings: Positive colour, negative colour, total colour, connector lines, data labels, totals bar.

Funnel chart

Requires: exactly 1 dimension · exactly 1 measure

Horizontal bars proportional to value — ideal for conversion or pipeline stages. Bars narrow as value decreases.

Settings: Label type (value / percent / value + %), conversion rate between stages, orientation (vertical / horizontal).

Treemap

Requires: 1–2 dimensions · exactly 1 measure

Nested rectangles sized by measure. Good for showing proportions across many categories simultaneously.

Settings: Label type (label / value / label + value).

Color palettes

Every chart type supports a Color palette setting:

Palette	Description
Celiq	Default brand palette — indigo, teal, amber, red, navy
Ocean	Blues and teals
Sunset	Warm ambers and reds
Forest	Greens and blues
Mono	Navy to light grey — suitable for print

Reference lines

Available on Bar, Line, Area, and Combo charts. Add one or more horizontal reference lines with:

Label — e.g. "Target", "Quota"
Value — the Y position
Color — line and label colour
Style — solid, dashed, or dotted

Validation

If you switch to a chart type that doesn't match your current fields, a ⚠ warning banner appears at the top of the results panel explaining what's missing. Celiq will also auto-select a compatible chart type when you run a query if the current type would produce no meaningful output.