I'm not sure exactly what you have tried. Here's what I did:

1) I need to build a table for the chart data with 5 columns for 5 data series. I will build this table in column L:P
2) In L1, I enter "base" to indicate this as the "base" series for the stacked bar chart. In M1, I enter "RO consumed". In N1, I enter "Contract consumed." In O1, I enter "allocated." In P1, I enter "unused."
3) In L2, I enter something like =SUM(M$1:N1).
4) In M2, I enter =E2. Copy into M2:O2.
5) In P2, I enter =C2.
6) Select L2:P2, note the mix of relative and absolute references, and copy/paste into L3:P4.
7) Select A1:A4,L1:P4 -> Insert stacked bar chart.
8) Evaluate the bars to see if they are accurately showing what you want to see. If so, then format chart elements as desired. In particular, format the "base" data series to be invisible.

Did I understand what you wanted?