> For the complete documentation index, see [llms.txt](https://docs.chartsql.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.chartsql.com/chartsql-studio/creating-charts/stacking.md).

# Stacking

Grouping series together to show relationships to part of a whole

Stacking refers to combing series values into a single value while retaining their name. It is useful when you want to compare values as part of a whole. Certain chart types support stacking, they are: line, area, column, bar and combo.

<figure><img src="https://4045370218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB0xzzR5x0BnQ6kHixlzd%2Fuploads%2FC1DVRbn2hnMiubOgRNUx%2Fimage.png?alt=media&amp;token=8af3f877-2e61-4fdc-b3d3-b6454901680c" alt=""><figcaption></figcaption></figure>

## Adding @stacks

Stacking is enabled for a chart by specifying the `@stacks` directive

```sql
-- @chart: column
-- @title: Stacking - Example column chart with stacking
-- @groups: Month, Channel
-- @subtitle: An example column chart that has a single stack
-- @formats: currency
-- @series: Sales
-- @stacks: Channel
SELECT 
	TRUNC(date_closed, 'MONTH') as Month,
    Channel,
	sum(amount) as Sales
FROM sales
GROUP BY TRUNC(date_closed, 'MONTH'), Channel
ORDER BY TRUNC(date_closed, 'MONTH') ASC;
```

## Stacking Examples

<table data-card-size="large" data-view="cards"><thead><tr><th data-card-target data-type="content-ref"></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden data-card-cover data-type="files"></th></tr></thead><tbody><tr><td><a href="/charts/area.md#area-chart-with-100-stacking">Area</a></td><td></td><td></td><td></td><td><a href="https://4045370218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB0xzzR5x0BnQ6kHixlzd%2Fuploads%2FpCMkyzIpQ2UXpsrZ2lpP%2Fimage.png?alt=media&amp;token=fabc46ca-2330-46a5-8972-627ef7c3c254">stacking_mode_100_example.png</a></td></tr><tr><td><a href="/charts/column.md#stacked-column">Column</a></td><td></td><td></td><td></td><td><a href="https://4045370218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FB0xzzR5x0BnQ6kHixlzd%2Fuploads%2FC1DVRbn2hnMiubOgRNUx%2Fimage.png?alt=media&amp;token=8af3f877-2e61-4fdc-b3d3-b6454901680c">stacking_example.png</a></td></tr></tbody></table>
