I am trying to create a stacked bar chart 2 separate columns for each data point starting from 0. Attached is what i have managed to achieve. I the second stack group to start from 0. Any suggestions on how to do this? I have set the first series of the second stack of data (the green one) to as combinemode.cluster which has moved the green data to start from zero however the purple and grey elements then just hover in a 3rd column at the same height as they are in the attached.
Also the green bar is as tall as the blue+yellow combined, however the chart UI doesn't seem to be auto sizing the chart correctly for this view, so there could be a bug here.
Thanks in advance