How to create a modified stacked bar chart for service consumption data, with roll-over?

You got me on the right track. Based on what you did, I was able to create an output that generated what I wanted.
Attachment 887527

The last thing I need to do is ensure the formulas are dynamic and able to adapt to contracts of different length, as well as variable purchased/consumed/allocated/rolled-over hours. Here are my formula sets and I think I've edited them appropriately, but could use a proofread. Specifically the part that I'm unable to account for is the formula change from "current year" (2) to "future year" (3) in column T.
Attachment 887529

Updated workbook uploaded.