Documentation

    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.

    The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.

    Result
    Order datePurchased atRevenueCustomer IDOrder IDRegionRefunded
    2026-01-012026-01-01 10:00:001000North
    2026-01-022026-01-02 10:00:00151001ORD-0Southfalse
    2026-01-032026-01-03 10:00:00201002ORD-1Westfalse
    2026-01-042026-01-04 10:00:00251003ORD-1Northfalse
    2026-01-052026-01-05 10:00:00301004ORD-2Southfalse
    2026-01-062026-01-06 10:00:00351005ORD-2Westtrue
    2026-01-072026-01-07 10:00:00401006ORD-3Northfalse
    2026-01-082026-01-08 10:00:00451007ORD-3Southfalse
    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.