---
title: "Horizontal bar chart in Vista | Oplema"
description: "Make a horizontal bar chart in Vista: compare one calculated value across categories with room for long or numerous labels."
url: "https://oplema.com/docs/vista/bars-columns/horizontal-bars"
updated: "2026-11-04"
---

# Horizontal bars

Horizontal bars groups your rows by one column, calculates one value per group and draws it as a bar running sideways, so each label gets its own row.

## Show revenue by month, sideways

The same 180 orders are summed per month, with one row per month, so each label sits beside its bar and not under it.

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, expand Category limits and change Show to `Top N`. Only the largest bars stay on the chart.
2. Change Operation from `Sum` to `Average`. Each bar now shows the average revenue per row.
3. Open the Design tab and expand Title to rename the chart.

## When to use

Use Horizontal bars when the labels are long, such as product or country names that would collide under a column. For short labels or a time axis, use Columns.

## Inputs

1 port

**Table**

Accepts: Tables.

Accepts one connection on this port.

## Settings

**Group by**

Column for the categories on the left 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**

Number column calculated along the horizontal axis. Auto picks one with varied values. Called Point value on line and area 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.

**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 Y axis. Leave empty to use the field names.

**Label size (Category axis)**

Size of the Y axis labels, in pixels.

Default: `12`

**Label angle (Category axis)**

Angle of the Y 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 Y axis title, in pixels.

Default: `12`

**Title distance (Advanced category axis)**

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

Default: `4`

**Title (Value axis)**

Title of the X 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 X axis labels, in pixels.

Default: `12`

**Label angle (Advanced value axis)**

Angle of the X axis labels.

Default: `Auto`

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

**Title size (Advanced value axis)**

Size of the X axis title, in pixels.

Default: `12`

**Title distance (Advanced value axis)**

Extra space between the X 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`

## Horizontal bars FAQs

**When should I use Horizontal bars instead of Columns?**

Use Horizontal bars when labels are long or numerous, because each label gets its own row. The two share the same way of working, with the axes swapped.

### 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)
