Stacked bar chart with 100% stack type and negative value

[litera]

I would like to know whether it's possible out of the box to have a stacked bar chart with 100% stack type, that would also display negative values. It seems that the individual bars always fit between 0 and 100% (as stack type 100% should be working).

I understand that I could accomplish this by doing all the calculations myself, to adjust bar sizes so that all stacks have the same height with adjusted individual bar heights and also adjust the y axis to show percentages. I could in this case add negative downward bars as well. but that would be more custom code so I'm asking for the simplest out of the box solution of this.

P.S. Well ideally I wold want stacked area chart with stack type 100% but that doesn't work. Only bar chart support this kind of rendering. With a custom solution I could accomplish for the same also with an area chart.