Choose the Right Chart Type

Pick the chart type that fits your data in ChartBrick — from bar and line to KPI and table — and switch types without redoing your fields.

ChartBrick gives you one dataset and many ways to draw it. This guide helps you pick the right type and switch between them without redoing your fields. Editing a chart needs the Editor or Admin role — Viewers see charts read-only.

1

Open the Chart type picker

In the chart editor, the right panel opens with the Chart type picker at the top. Click it to open the dropdown and choose a type; the preview on the left updates as soon as you switch.

The types are Bar, Line, Area, Combination, Pie, Donut, Scatter, Bubble, Histogram, Waterfall, Heatmap, Nightingale, Radar Area, Radar Line, Radial Bar, Radial Column, Funnel, Cone Funnel, and Pyramid, plus KPI and Table. There's no separate "column" type — a Bar chart is vertical (columns) by default; use the Direction control under Appearance to switch it to horizontal.

2

Compare categories with bars

Use Bar to compare a value across categories. Add a dimension under Axis X (Categories) and one or more measures under Axis Y (Values); each measure gets an aggregation (Sum, Average, Count, and so on).

With more than one measure — or a column under Segment (Color by) — a Stacking control appears under Appearance with None, Stacked, and 100% options.

3

Show trends: line and area

For change over time, use Line or Area. They map like bar: an Axis X (Categories) field (often a date) and one or more Axis Y (Values) measures.

4

Parts of a whole and specialized shapes

For a single share of a total, use Pie, Donut, or Nightingale — these map one Labels (Slices) field and one Value. Funnel, Cone Funnel, and Pyramid map Stages plus one Value; Radar Area, Radar Line, Radial Bar, and Radial Column map Categories and Values.

A few shapes are more specific:

  • Heatmap needs three fields: Axis X (Categories), Axis Y (Rows), and Value (Color).
  • Scatter and Bubble plot two numeric measures as Axis X and Axis Y (Bubble adds a Size field).
  • Waterfall shows how steps add up to a total.
5

Use Table or KPI instead

Not every dataset needs a chart. Table shows the raw rows — use the Columns list to reorder and toggle which appear, and under Appearance switch on Striped rows, Compact mode, Row numbers, or Pagination.

KPI displays one headline number. Add a numeric Value field, pick its aggregation (Sum, Average, Count, Distinct, Min, or Max), give it a Label, then format it with a Prefix, Suffix, Decimals, and an optional Compact (1k, 1M) toggle.

6

Switch types safely

You can change the type anytime from the Chart type picker — your fields carry over, so moving between bar, line, and area needs no rework.

Single-value types (pie, donut, funnel, cone funnel, pyramid, waterfall, heatmap) keep only one value field, so switching to one from a multi-measure chart uses the first measure. The same applies once you add a Segment: a segmented chart renders only the first measure. Every change saves automatically — there's no Save button.

What's next?

Turn your data into charts now

Free plan available — no credit card required