Unify Applications
Logo
Bar & Column Charts

Bar & Column Charts

Logo

9 mins READ

Bar and Column charts are cartesian charts within the single Chart block. Bar renders horizontal bars with categories on the vertical edge; Column renders vertical bars with categories on the horizontal edge. Both share the same X-axis configuration, series system, and add-ons. Switch between them via Chart Type in the Content inspector — switching never loses your configuration when the data fits.

bar_and_column_chart.png
bar_and_column_chart.png

Tip: Column is always vertical bars. Bar is always horizontal bars. Switch between them rather than trying to rotate one. Column always offers Group by; Bar only offers Group by while there is at most one series.

Chart Block Basics

The Chart block covers 20 plot types from a single Chart Type picker. Changing the type swaps the entire Content and Appearance inspector for the new type's property set. When the current configuration fits the new type, data mappings are carried over (though chart colors reset). When they don't fit, the block resets to the new type's defaults.

Data Binding

Property

Type

Default

Description

Data Source (data)

array of records

Sample data

The array of records the chart plots. Bind to a data source query result, a variable, or static rows.

Chart Type (chartType)

picker

Selected at add time

Drives everything in the inspector. Pick Bar or Column for these chart types.

X Axis Configuration

Both Bar and Column configure the X axis identically:

PropertyWhere to SetDescription
ValueContent → X Axis → ValueThe field plotted on the X axis (categories or numeric dimension).
LabelContent → X Axis → LabelAxis caption displayed next to the axis.
Type (scale)Content → X Axis → Typelinear (numeric, proportional), time (chronological), or category (each distinct value equally spaced). Default linear.
Plot Periodic ValuesContent → X Axis → Plot Periodic ValuesSwitches to period mode: map a Start value and End value field per row, tick labels use a period format like 02-09 Jan.
Tick labelsContent → X Axis (format fields)Format for axis labels — date format on a time scale; decimal places and compact/standard notation on numeric scales.
Group byContent → X Axis → Group byA second dimension pivoted into one bar series per group value. Bar: available only with at most one series. Column: always available.

Y Axis & Series

The Y axis carries the value axis label, tick formatting, and the series list. Each series has a Label and a Value field.

Y Axis Tick Label Formats

FormatDescription
NumberPlain number. Supports decimal places and Compact notation (1200 → 1.2K).
PercentAppends % symbol with configurable decimal places.
CurrencyCurrency code + decimal/notation options. Supports Compact notation.
DurationTime duration with max significant units and precision.

Series Modes

ModeDescription
ManualYou add each series individually with its Label and Value field.
MappedThe series list is generated from a bound array — one series per row. New rows in the source appear as new series automatically.

Bar Chart

Horizontal bars — categories on the vertical edge, values running horizontally.

PropertyWhere to SetDescription
Type (stacked)Appearance → TypeStacked vs Grouped bars. Shown once there is more than one plotted series. Default stacked.
Gap Between BarsAppearance → Gap Between BarsSpacing inside a grouped cluster (None to lg). Appears only when Type = Grouped.
Ticks → positionAppearance → X Axis → TicksCategory labels Outside Bars (default) or Above Bars.
Slots → X-Axis LabelsContent → SlotsOn a category axis, replaces axis labels with your own nested block.

Column Chart

Vertical bars — categories on the horizontal edge, values running upward.

Property

Where to Set

Description

Group by

Content → X Axis → Group by

Always offered on Column regardless of series count (unlike Bar, which hides it with multiple series).

Type / Gap Between Bars

Appearance

Which one you get depends on your series and Group by. See the list below this table.

Label Orientation

Appearance → X Axis → Label Orientation

Horizontal / Slanted / Vertical X-axis labels. Offered on a time scale.

Data Callout

Series detail panel → Data Callout

Per-series annotation from a second field printed above each bar. Column is the only chart type offering this. See Data Labels & Annotations.

  • One series with Group by: the Type toggle (Stacked or Grouped).

  • Several series without Group by: the Type toggle.

  • Several series with Group by: only Gap Between Bars. The layout is forced to stacked.

Tip: To show each segment as a share of 100%, pick 100% Stacked Column as the Chart Type. It has no Stacked/Grouped toggle and no Threshold add-on.

Dual Axes Chart

Two independent value axes — Y Axis Left and Y Axis Right — each with its own series list, value format, and visualization type. Use it to overlay measures with different units (revenue columns against a conversion-rate line).

Property

Where to Set

Description

Visualisation (per axis)

Content → Y Axis Left/Right → Visualisation

How that axis's series render: Column, Line or Scatter.

Series (per axis)

Content → Y Axis Left/Right → Series

Independent series lists for left and right axes.

Tick labels (per axis)

Content → Y Axis Left/Right

Independent value formats per axis.

Note: Dual Axes has no Group by and no Threshold add-on. When both axes are set to Column, Bar Width and Gap Between Bars move up to the top level and apply to both. Switching a multi-series chart to Dual Axes puts the first series on the left axis and the second on the right; further series are dropped.

Common Chart Properties

Property

Where to Set

Description

Tooltip

Content → Tooltip

Custom header/body text around the hover tooltip.

Summary

Content → Summary

A row of formatted stats rendered with the chart (String, Number, Currency, Percent, Time).

Threshold (add-on)

Content → Add ons

A reference line at a single value or a min–max band. Available on Bar, Column, and Line (not Dual Axes).

Scroller / Range Slider (add-on)

Content → Add ons

A brushing control to pan and zoom the X axis. Labelled Scroller on category axes, Range Slider on time/linear axes.

Chart Colours

Appearance → Chart Colours

Color assignment by series, X-axis values, group values, or conditions.

Legends (add-on)

Content → Add ons → Legends

Shown once there is a Group by or more than one series. Pick the Legend Position (Top Left, Top Right, Bottom Left, Bottom Right, Left, Right) and Legend Padding. Remove the add-on to hide the legend.

Events & Methods

Event / Method

Description

On Data Point Click

Fires when user clicks a bar. Payload is the clicked record (all fields). Use to filter a table, open a detail drawer, etc.

Select Data Point (method)

Selects a data point from your actions. The point is stored in {{ id.selectedPoints }}.

Clear Selected Data Point (method)

Clears the selected data point. {{ id.selectedPoints }} becomes empty.

Generate Preview (method)

Generates a preview image of the chart and stores it in {{ id.preview }}.

Set Visible Region (method)

Sets the region the Range Slider shows. Available on time and linear X axes only.

Exposed State

State Key

Type

Description

{{ id.selectedPoints }}

array

The selected data point (at most one element): X-axis, group and series name/value plus every field of the clicked record. Empty until a point is clicked or selected. Read it with {{ chart1.selectedPoints[0] }}.

Behavior & Gotchas

⚠ Only the first row per category is plotted

On category and time scales, a second row with the same X value is silently dropped — values are not merged or summed. Aggregate your data before binding it. Rows with a missing or empty category are also dropped.

⚠ Non-numeric series values plot as zero

A null, missing, or non-numeric value in a series field renders as 0 — the bar still exists rather than leaving a gap.

⚠ Multiple series + Group by forces stacked Column on a category axis

Combining more than one series with a Group by removes the Grouped option and time/linear scale choices — the chart is forced to stacked bars on a category scale.

⚠ Bar hides Group by once you add a second series

On Bar, the Group by picker is only present while the series list has at most one entry. Column keeps it visible always. To group a multi-series bar chart, remove series down to one first.

⚠ Data labels vanish when the layout can't place them

On Bar and Column, data labels are only supported for a single series, or for multiple series in Grouped layout without a Group by. Stacking or adding a Group by silently switches every series' data labels off.

⚠ Scroller caps chart height at 400px

When the Scroller add-on is active, the chart's computed height stops growing at 400px. The scroller is the intended way to reach the rest of the data.

Common Patterns

Grouped Monthly Comparison

  1. Set up Column chart: Set Chart Type to Column. Bind data with one row per month per region.

  2. Configure axes: Set X Axis → Value to the month field, one series with the revenue field, and Group by to the region field.

  3. Set layout: In Appearance, set Type = Grouped and pick a Gap Between Bars.

Revenue Columns vs Conversion Line (Dual Axes)

  1. Select Dual Axes: Set Chart Type to Dual Axes.

  2. Configure left axis: Set Y Axis Left → Visualisation = Column, series = revenue, format Currency.

  3. Configure right axis: Set Y Axis Right → Visualisation = Line, series = conversion, format Percent.

Page

Relationship

Line & Area Charts

Continuous trend lines and area fills; shares cartesian axis configuration

Data Labels & Annotations

Per-bar value labels and Column-only data callout annotations

Scatter & Bubble Charts

Two-dimensional point plots; shares cartesian axis machinery

FAQs

What is the difference between a Bar chart and a Column chart?

Both plot the same data in the same way — they differ only in orientation. A Column chart renders bars vertically (categories on the X axis, values on the Y axis). A Bar chart renders bars horizontally (categories on the Y axis, values on the X axis). Column charts are better for time-series comparisons; Bar charts are better for long category labels.

How do I add a second Y axis?

Select Dual Axes as the Chart Type. This gives you two independent value axes, Y Axis Left and Y Axis Right. Add each series under the axis it belongs to. Each axis has its own Visualisation, Series and tick-label format.

My X-axis labels are overlapping. How do I fix this?

On a Column chart with a time-scale X axis, set Appearance → X Axis → Label Orientation to Slanted or Vertical. On a category axis, long labels slant automatically. If they still overlap, shorten the labels, widen the chart, or switch to a Bar chart so labels run down the vertical axis.

Can I stack and group bars at the same time?

No. The Type option on a Bar chart is either stacked or grouped — you cannot combine both simultaneously on a single series set. If you need a mix, consider using a Dual Axes chart where one axis shows a stacked Column and the other shows a Line.

How do I highlight a threshold line on a bar chart?

Under Content → Add ons, add Threshold. Choose Single (one value) or Range (a min–max band), enter the value, and pick a colour so it stands out. For a dynamic threshold, bind the value to a variable or data source field.