I have the same question, but the answers don´t address the original question. I want to make graphics like the one shown below. These types of graphs have multiple applications and should be easy to do. I found some complicated ways to do them.
I take a more extreme view compared to many here: One should avoid stack bar charts at all costs and double stacked bar charts sounds like real bad dream. Not making double stacked bar charts easy to do I'm sure is not by design but I'm glad it's hard to do.
I believe that the incentive to have stacked bar charts is to attempt to display several aspects of the data in a single figure. But usually the resulting display does not convey any of the multiple aspects very well. Unless you have some limitation on pages, one should have separate figures for each objective. Maybe in the olden days where things were printed, there was the need to cut down on the number of figures. But not any more.
Do a Google search for "alternatives to stacked bar charts" and you'll see alternatives and why stacked bar charts (and bar charts for that matter) have undesirable properties.
Thank you Jim.I still think sometimes stacked bars may be useful to illustrate some phenomena. Please see the following application I did: https://www.wolframcloud.com/env/ricardomar/Published/AnalizadorTablerosControlPRODI_v20.nb
Even though it is in Spanish, you can see that there are a lot of stacked bar charts showing a lot of information about each water utility. You can compare the performance of the different water utilities by looking at the total production of water ("P"), the amount billed ("F") and the amount actually collected (revenues) ("C"). Non revenue water is a very important problem all over the world. The stacked bars show how much water (or money) is lost in each concept.
The concepts are here: https://www.researchgate.net/figure/Standard-IWA-Water-Balance_fig1_228707498 the illustration is a sort of stacked bar chart.
Any ideas on how to show the balance in another way.
But how can you have double stacked chartbars? For example, how can you show supply and demand for multiple locations? How can you show, for different regions, the supply and demand of water (e.g. on one side runoff and infiltration and on the other side use in agriculture, use in industry, use for public water supply)?