100% stacked horizontal bars
100% stacked horizontal bars stretches every bar to the full width and divides it into shares, so you compare the mix per category at a glance.
See each day's drink mix, sideways
Every row fills the width, so tea's share reads straight across: a third of Monday, half of Tuesday and three quarters of Wednesday.
100% stacked horizontal bars interactive example
Loading interactive example…
The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.
| Day | Drink | Cups |
|---|---|---|
| Mon | Tea | 10 |
| Mon | Coffee | 20 |
| Tue | Tea | 20 |
| Tue | Coffee | 20 |
| Wed | Tea | 30 |
| Wed | Coffee | 10 |
- In the Data tab, change Stack by to another column to change what the shares are made of.
- Open the dropdown at the top of Properties. It shows
100% stacked horizontal bars. ChooseStacked horizontal barsto bring back the difference in totals. - Open the Design tab and expand Legend to change where the drink names appear.
When to use
Use 100% stacked horizontal bars when the labels are long and the mix matters, such as survey questions split by answer. If readers also need to see how many people answered, use Stacked horizontal bars.
Inputs
- Table
Accepts: Tables.
Accepts one connection on this port.
Settings
Values must not be negative, and a bar whose segments total zero has no percentage.
- 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:
DayOptions: 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 valuesOptions: 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:
SumOptions: 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.
- Stack by
Column whose values become the stacked series.
- 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:
SumOptions: 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.
56 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 emptyOptions: Omit, Leave empty, Fill with zero.
- Current partial period
Keeps or leaves out the current period, which hasn't finished yet.
Default:
IncludeOptions: 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:
MondayOptions: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.
- Fiscal year starts
Month the fiscal year starts in. Sets quarter and year boundaries.
Default:
JanuaryOptions: 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 categoriesOptions: 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:
LeftOptions: 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:
AutoOptions: 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.
- Scale
Unit for value labels. Every tick is divided by it.
Default:
NoneOptions: 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:
AutoOptions: 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 & leftOptions: 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 periodsOptions: Equal periods, Elapsed time.
- Date labels
How dates are written in the chart labels.
Default:
AutoOptions: 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:
IsoOptions: Auto, Iso, Date, Datetime, Custom.
- Long labels
Whether long category labels wrap, get cut off or are handled automatically.
Default:
AutoOptions: 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
100% stacked horizontal bars FAQs
- Why can a 100% stacked bar show no percentage?
- A category whose total is zero has no share to show. Negative values aren't supported either.
Chart your data. Build it in Vista.
Vista opens in your browser, with no account.