Visualizations overview
Celiq supports 27 visualization types organized into 8 groups. The best chart for your data is auto-selected when you run a query — you can change it with the pill bar above the results.
Chart groups
| Group | Charts | Best for |
|---|---|---|
| Tables | Table, Sheet, Pivot | Raw data review, spreadsheet-style analysis |
| Trend | Line, Area, Stacked Area, Column, Stacked Column, Bar, Stacked Bar | Time series, ranking, comparison over time |
| Part/Whole | Donut, Pie, Treemap, Funnel, Pareto | Distribution, composition, conversion |
| Compare | Scatter, Bubble, Heatmap, Waterfall, Radar | Correlation, outliers, multi-dimensional |
| Combo | Line+Column, Line+Stacked Column | Dual-axis comparisons |
| KPI | Single value, KPI Grid, Candlestick | Key metrics, financial |
| Geo | Geo Bubble, Geo Heatmap, Geo Area | Geographic distribution |
| Flow | Sankey | Flow and conversion paths |
Auto-selection logic
Celiq picks the chart type automatically based on your selected fields:
| Fields | Auto-selected |
|---|---|
| 1 metric, no dimensions | Single value |
| Date + metric(s) | Line chart |
| 1 dimension + 1 metric, ≤ 15 rows | Donut |
| 1 dimension + 1 metric, ≤ 30 rows | Bar |
| 2+ metrics | Scatter |
| Geo field + metric | Geo Bubble or Geo Area |
| Anything else | Table |
Settings panel
Click ⚙ (top-right of the chart area) to open the settings panel. It has:
- Theme picker — 6 built-in colour palettes
- Series colours — override individual series colours
- Chart settings — per-chart-type options (axis, labels, legend, grid)
- Conditional formatting — highlight cells or draw reference lines based on metric values
See Chart settings → for the full reference.