Variants
Basic
One dimension on the X axis, one measure on the Y axis. Each category gets a single bar.Grouped
Each series renders as a separate cluster of bars side-by-side at every X-axis value. Best for comparing absolute values across multiple series at each category.Stacked
Series are stacked on top of each other at each X-axis value. Use when you want to show both individual contributions and the total at a glance.Percentage stacked (Stack %)
Each stack is normalized to 100%, showing each series as a proportion of the total per X-axis value. Use when relative distribution matters more than absolute values.Horizontal
All three vertical variants are also available horizontally. Horizontal bars work well for long category labels, many categories, or when a left-to-right reading direction feels more natural.Composite (bar + line)
Assign one series to the right Y axis and set its mark type to Line in series configuration. This creates a dual-axis chart — useful for overlaying a rate on top of volume data (e.g. order count as bars, revenue per order as a line).Stacking
Stacking behavior is set in the Color & stacking section of the Style tab:| Option | Behavior |
|---|---|
| Automatic | Cube picks the best option based on your data |
| Stack | Series at the same X value are stacked |
| Group | Series at the same X value are placed side-by-side |
| Overlay | Series are drawn on top of each other (rarely useful for bars) |
| Stack % | Series are stacked and normalized to 100% |
Data labels
Bar charts support totals labels on stacked charts — showing the aggregate value above each full stack. Enable Data Labels in the Fields tab, then configure:- Format — number format applied to the label value
- Font size — size of the label text
- Position — Outside end, Inside end, Inside center, or Inside base