Skip to main content
D
davidc0015
March 19, 2026
Solved

How to Make Stacked Column Chart with Multiple Series?

  • March 19, 2026
  • 11 replies
  • 0 views

Hi Appian Community!

I have a requirement where in the column chart below, I need to show a breakdown of the data for each bar of all the series based on the date.

I had to manipulate the dataset so using a record type was not possible. Now I have my data structured where  x-axis is dates, and y-axis is the percentage of each area of the office's seat booking. How do I show within each bar, a breakdown of say half is booking type A and the other half is booking type B?

Best answer by shubhama926776

Doesn’t support grouped + stacked simultaneously.
Workaround you can try : Use 2 separate stacked column charts side by side in a a!columnsLayout:
Chart 1: Office areas stacked (your original)
Chart 2: Booking type breakdown stacked
Same date x-axis on both - user can visually correlate between the two charts.

11 replies

stefanhelzle0001
stefanhelzle0001
March 19, 2026

I assume you tried setting the "Stacking" parameter to NORMAL or PERCENT_TO_TOTAL?

If yes, I am not sure what exactly you try to achieve.

D
davidc0015Author
March 19, 2026

hi Stefan, always good to hear from you. Yes I tried those but the result is my 3-5 bars will be stacked into 1 for each day.

I want to keep them separate. and within each bar, show stacking of 2 booking types.

stefanhelzle0001
stefanhelzle0001
March 20, 2026

Then try to prepare the data in a way that the column chart can display it. If you want two columns for each day, create two data points for each day.

shubhama926776
shubhama926776
March 19, 2026

Use stacking: "NORMAL" in a!columnChartField and define one a!chartSeries per breakdown type:

a!columnChartField(
  categories: local!dates,
  series: {
    a!chartSeries(label: "Type A", data: local!typeAData, color: "GREEN"),
    a!chartSeries(label: "Type B", data: local!typeBData, color: "BLUE")
  },
  stacking: "NORMAL"
)

Each data array must be index-aligned with categories.

D
davidc0015Author
March 19, 2026

Thanks for the code sample. Let me try with 2 chart series for each day

Terms & ConditionsAccessibility statement