Stacked bar

Overview

The stacked bar widget stacks values of multiple dependent variables horizontally for each item (independent variable). It allows you to see both the total sum and the internal composition ratio of each item at a glance, making it suitable for comparing the distribution of sub-items across categories.

For general information about query widgets, see Query widget.

Chart settings

Select Stacked Bar as the chart type in the pivot table editor and click the chart settings button.

Variables

• Independent Variable: Select the field to use as bar labels.
• Auto-Select: Automatically select all numeric fields as dependent variables.
• Dependent Variable(s): Specify dependent variables manually.

View

• Zoom-In: Select the direction for drag-to-zoom (default: None, options: x, y, xy).
• Concatenate Empty Values: Set how to handle empty value intervals.

Chart

• Headline: Enter a chart title and subtitle.
• Chart Area: Set the background color, border thickness, and border color.

Axis

• X-axis: Set the title and format.
• Y-axis: Set the title, format, min, and max.

Series

• Chart Type: Override the series chart type (default: Auto).
• Series Color: Set the series color.

Label

• Label All Series: Display values in each stacked segment.

Legend

• Show: Set whether to display the legend.
• Legend Arrangement: Options: Horizontal, Vertical.
• Horizontal Align / Vertical Align: Set the legend position.

Event

Configure click events.