---
title: "Column chart in Vista | Oplema"
description: "Make a column chart in Vista: compare one calculated value across categories or time periods, with a live example you can edit."
url: "https://oplema.com/docs/vista/bars-columns/columns"
updated: "2026-11-04"
---

# Columns

Columns compares a value across categories or over time. It groups your rows by one column, calculates one value per group and draws one upright bar for each.

## Show revenue by month

Revenue from 180 dated orders is summed per month, so each upright column is what one month brought in.

Result
| Order date | Purchased at | Revenue | Customer ID | Order ID | Region | Refunded |
| --- | --- | --- | --- | --- | --- | --- |
| 2026-01-01 | 2026-01-01 10:00:00 |  | 1000 |  | North |  |
| 2026-01-02 | 2026-01-02 10:00:00 | 15 | 1001 | ORD-0 | South | false |
| 2026-01-03 | 2026-01-03 10:00:00 | 20 | 1002 | ORD-1 | West | false |
| 2026-01-04 | 2026-01-04 10:00:00 | 25 | 1003 | ORD-1 | North | false |
| 2026-01-05 | 2026-01-05 10:00:00 | 30 | 1004 | ORD-2 | South | false |
| 2026-01-06 | 2026-01-06 10:00:00 | 35 | 1005 | ORD-2 | West | true |
| 2026-01-07 | 2026-01-07 10:00:00 | 40 | 1006 | ORD-3 | North | false |
| 2026-01-08 | 2026-01-08 10:00:00 | 45 | 1007 | ORD-3 | South | false |

1. In the Data tab, change Group dates by from `Month` to `Quarter`. The columns now cover whole quarters.
2. Change Operation from `Sum` to `Average`. Each column now shows the average revenue per row.
3. Open the Design tab and expand Value axis to change how the values are labeled.

## When to use

Use Columns to compare a value across categories with short labels, such as which month earned most. For long labels, use Horizontal bars. To show the direction of change, use Line.

## Inputs

1 port

**Table**

Accepts: Tables.

Accepts one connection on this port.

## Settings

**Group by**

Column for the categories on the X axis. Auto picks a readable one.

**Group dates by**

How dates in this field are grouped, such as by day, month or year.

Default: `Day`

Options: Exact, Second, Minute, Hour, Day, Week, Month, Quarter, Year, Month of year, Day of week, Hour of day.

**Grouping**

Groups each number on its own, or into equal-width ranges.

Default: `Individual values`

Options: Individual values, Fixed-width ranges.

**Bar value**

Column calculated into the height of each bar or point. Auto picks one with varied values. Called Point value on line and area styles, and Segment value on stacked column styles.

**Operation**

How the value column is calculated for each category. Columns that aren't numeric are counted.

Default: `Sum`

Options: Sum, Average, Median, Minimum, Maximum, 25th percentile, 75th percentile, 90th percentile, 95th percentile, Percentile, First by time, Last by time, Count values, Count distinct, Count rows, Count true, Percentage true.

**Nested group**

Optional second category level on the main axis. Subcategories sit side by side within each category.

**Use secondary axis**

Adds a second value on a right-hand axis.

Default: `false`

**Callout value**

Column used for the label on each point. Leave empty to hide callouts.

**Operation (Callout)**

How values are calculated for each point. Distinct text joins the labels that aren't blank with commas.

Default: `Sum`

Options: Sum, Average, Median, Minimum, Maximum, 25th percentile, 75th percentile, 90th percentile, 95th percentile, Percentile, First by time, Last by time, Count values, Count distinct, Distinct text, Count rows, Count true, Percentage true.

57 more settings

**Sort by**

Default keeps categories in source order and dates in time order. Choose a plotted field to sort by it.

Options depend on the connected data and configuration.

**Period size**

Number of units in each period. Hours, minutes and seconds count fixed intervals from 1970-01-01 in the chart's time zone. Calendar periods follow local boundaries.

Default: `1`

**Missing periods**

Missing periods

Default: `Leave empty`

Options: Omit, Leave empty, Fill with zero.

**Current partial period**

Keeps or leaves out the current period, which hasn't finished yet.

Default: `Include`

Options: Include, Exclude.

**Source timezone**

IANA time zone for timestamps without an offset, such as Europe/Copenhagen. Ambiguous local times need an explicit offset.

Default: `UTC`

**Chart timezone**

IANA time zone used for grouping and display. Vista filters keep their own time zone.

Default: `UTC`

**Week starts**

Day the week starts on.

Default: `Monday`

Options: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.

**Fiscal year starts**

Month the fiscal year starts in. Sets quarter and year boundaries.

Default: `January`

Options: January, February, March, April, May, June, July, August, September, October, November, December.

**Show**

Shows every category, only the top or bottom N or the latest N periods.

Default: `All categories`

Options: All categories, Top N, Bottom N, Latest N periods.

**Show tooltip**

Shows or hides values when you hover over a mark.

Default: `true`

**Tooltip**

Text shown when you hover over a mark. Write it in the editor and insert values from Values.

**Values**

Values you can insert into the text. Each row calculates a value from a source field or, in charts, shows a chart value, and can have its own number or date format.

**Title**

Title shown inside the chart. Leave empty to hide it.

**Title color**

Color of the title.

**Title size (Advanced title)**

Size of the title, in pixels.

Default: `24`

**Title alignment (plot)**

Alignment of the title.

Default: `Left`

Options: Left, Center, Right.

**Bar width**

Bar thickness as a percent of the space for each category. At 100, bars touch.

Default: `80`

**Title (Category axis)**

Title of the X axis. Leave empty to use the field names.

**Label size (Category axis)**

Size of the X axis labels, in pixels.

Default: `12`

**Label angle (Category axis)**

Angle of the X axis labels. Auto turns them when they don't fit.

Default: `Auto`

Options: Auto, 0°, 45°, 90°.

**Title size (Advanced category axis)**

Size of the X axis title, in pixels.

Default: `12`

**Title distance (Advanced category axis)**

Extra space between the X axis labels and the title, in pixels.

Default: `4`

**Title (Value axis)**

Title of the Y axis. Leave empty to use the field names.

**Range**

Sets fixed limits for the value axis.

Default: `Auto`

Options: Auto, Min only, Max only, Min & max.

**Scale**

Unit for value labels. Every tick is divided by it.

Default: `None`

Options: None, Thousands (K), Millions (M), Billions (B).

**Prefix**

Text before each value label.

**Suffix**

Text after each value label.

**Decimal places**

Most decimal places shown on value-axis labels and in tooltips.

Default: `2`

**Always show decimal places**

Pads values to the decimal places, so with 2, 2630 shows as 2,630.00.

Default: `false`

**Thousands separators**

Groups digits, so 2630 shows as 2,630.

Default: `true`

**Label size (Advanced value axis)**

Size of the Y axis labels, in pixels.

Default: `12`

**Label angle (Advanced value axis)**

Angle of the Y axis labels.

Default: `Auto`

Options: Auto, 0°, 45°, 90°.

**Title size (Advanced value axis)**

Size of the Y axis title, in pixels.

Default: `12`

**Title distance (Advanced value axis)**

Extra space between the Y axis labels and the title, in pixels.

Default: `4`

**Background**

Card background color. Auto follows the theme.

**Plot padding**

Space between the card edge and the chart, in pixels.

Default: `0`

**Grid lines**

Shows or hides grid lines.

Default: `false`

**Axis frame**

Shows or hides the axis lines around the plot.

Default: `true`

**Frame sides**

Edges of the plot that get an axis line.

Default: `Bottom & left`

Options: Bottom, Left, Bottom & left, Full box.

**Axis titles**

Shows or hides the titles on both axes.

Default: `true`

**Tick color**

Color of the axis labels.

**Axis title color**

Color of the axis titles. Auto matches the axis labels.

**Frame color**

Color of the axis lines.

**Time spacing**

Equal periods gives every period the same space. Elapsed time spaces periods by real time.

Default: `Equal periods`

Options: Equal periods, Elapsed time.

**Date labels**

How dates are written in the chart labels.

Default: `Auto`

Options: Auto, Iso, Date, Datetime, Custom.

**Time extent start**

Optional ISO date or time. Rounded down to the selected period.

**Time extent end**

Optional ISO date or time. Rounded up to include the whole period.

**Tooltip dates**

How dates are written in tooltips.

Default: `Iso`

Options: Auto, Iso, Date, Datetime, Custom.

**Long labels**

Whether long category labels wrap, get cut off or are handled automatically.

Default: `Auto`

Options: Auto, Wrap, Truncate.

**Maximum label width**

Widest a category label can be before it wraps or is cut off.

Default: `140`

**Maximum label lines**

Most lines a wrapped category label can use.

Default: `3`

**Show every Nth label**

At 0, Vista picks how many labels to show. 1 shows every label.

Default: `0`

**Value tick density**

Roughly how many ticks the value axis aims to show. Value tick interval overrides it.

Default: `5`

**Value tick interval**

0 is automatic. A set interval overrides the density.

Default: `0`

**Reference lines and bands**

Average and median use the bars that aren't missing, before any zoom.

**Corner radius (px)**

Corner radius in whole logical pixels.

Default: `0`

**Border width (px)**

Border width in whole logical pixels.

Default: `0`

## Columns FAQs

**How do I switch from columns to a line?**

Select the visual and choose another style in the dropdown at the top of Properties. Your fields are kept.

**Where are line and area charts in Vista?**

They are styles of the same visual as Columns, so you can switch between them in Properties. The palette lists them under Lines & areas.

### Chart your data. Build it in Vista.

Vista opens in your browser, with no account.

[Open Vista](https://oplema.com/editor?path=%2F%3Fopen%3Dvista) [About Vista](https://oplema.com/vista)
