Stacked Column Chart

Stacked column charts are a visualization used to display data values as vertical bars divided into multiple segments. Each segment represents a portion of the total value, showing how individual components contribute to the whole across different categories. This layout helps visualize both the overall total and the breakdown of each part within it.

You can use stacked column charts to compare category totals while also showing the contribution of subcategories, making it easier to identify dominant groups, proportional changes, or distribution patterns across time or categories.

This article explains the requirements for creating stacked column charts and provides an overview of key properties and configuration options in Wyn Notebooks.

You can use stacked column charts to display sales by product category and region, analyze expenses by department and cost type, or visualize survey responses broken down by demographic groups — all within the same visualization.

This topic explains how to create and customize column charts and explains the most frequently used properties. Refer to the reference for all the column chart properties and configuration options.

Create a Stacked Column Chart

To create a column chart, click on the Plus (+) button, opening the dropdown from which you can select your chart.

Bind Data to Stacked Column Chart

For a basic stacked column chart, you need to determine:

Values (Y-Axis): The quantitative data displayed on the y-axis. Typically, this represents numeric measures such as Sales, Profit, or Quantity.
Axis (Category / X-Axis): The categorical data displayed on the x-axis. Typically, this represents time-based or grouped categories, such as Month, Region, or Product.
Legend (Series): The dimension that defines how each column is divided into stacked segments. Each unique value in this field creates one segment within a column.

Once your data source is selected, all data attributes appear in the Data Binding tab. You can drag the following to the binding slots of the chart:

Data attribute: Drag and drop any field from the data source.
Measure: Hover over the data source table name, click the gear icon (⚙), and select Add measure…. Define a name and an expression, click OK, then drag the measure to a binding slot.
Calculated column: Hover over the data source table name, click the gear icon (⚙), and select Add calculated column…. Define your calculation, click OK, then drag it to a binding slot.

Add Aggregations

You can control how data is aggregated and labeled in the chart:

Aggregation method: Click the gear icon (⚙) next to a bound data attribute, and select an aggregation type (e.g., Sum, Average, Count).
Rename data attribute: Click the gear icon (⚙) next to a bound data attribute and select Rename to modify how it appears in the chart.

Set Chart Title

By default, Wyn generates a chart title based on the selected data attributes.

You can modify this title in the Inspector Panel:

Click the gear icon (⚙) next to the Data Binding tab to open the Inspector Panel.
Under Title, type a custom title for your chart.

Note: Once a custom title is entered, changes to the data attributes will no longer automatically update the chart title.

To include more details in the chart’s tooltip, drag one or more data attributes into the Tooltip binding slot. Tooltips appear when hovering over chart elements, providing contextual details without cluttering the chart area.

Customize Colors

You can adjust the color scheme of your column chart in Inspector Panel > Chart Style > Palette.

Choose from:

Theme: A seven-color palette based on a theme.
Standard: A set of predefined seven-color palettes.
Custom: Define your own palette to match brand colors or visualization standards.

Build a Chart Trellis

A trellis column layout (also known as a small multiples view) creates a set of individual charts arranged horizontally. Each chart represents a subset of the data, determined by the field you assign.

To create a series of trellis column charts, drag a data attribute into the Trellis Columns binding slot. Each unique value in that field generates a separate chart displayed in columns across the dashboard.

A trellis row layout arranges multiple charts vertically, each showing a subset of data for a particular category or group.

To create a series of trellis row charts, drag a data attribute into the Trellis Rows binding slot. Each unique value generates an individual chart displayed in rows down the dashboard.