How to make a grouped stacked plot?

How would one do in calc a plot like this (grouped-stacked):

image description

thank you!

One possibility (not perfect) is to use two sets of data and two graphs superimposed. This will allow to change values once finished.

Data series spacing set to 0%.

The first/lower one with Y Axis and X Axis values font color set to white.

The last/upper one with the Chart Area color set to none; Y Axis Mayor Grid deleted.

Legends must be separated.

image description

See sample file.

A non-dynamic graph can be done exporting two stacked bars graphs to Draw, and manually intermingle them there.

Made with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.