How to create a stacked bar chart for not time series (Grafana 8.5.20)

Hi,
I am using the Grafana free version 8.5.20 and i want to build a stacked bar chart for gender distribution depending on age groups (like in the mockup below).
However, when I choose “Bar Chart” → Stacked → Normal it doesn’t stack the graph, that bars only come closer together.

How do I achieve a stacked bar chart for a visualisation that is not over time.

Screenshot 2023-12-27 093805