Creating a Box and whisker or stacked column graph with given values

Hello,

So I'm working on creating 5 box and whisker/stacked column graphs with given min, median, max, Q1, and Q3 IRR values however I realized that box and whisker needs to have the original data set to make a chart in excel. I'm also using Power BI but that really isn't working out for me either. My main issue with the stacked column graph is that it's using the total values of the IRR instead of finding the difference.

So I used the differences to make a stacked column but now I'm encountering the issue that my min values and some of Q1 values are negative so they aren't stacking the right amounts or a certain quartile will just get cut off at zero and not have the right gap size.

If anyone knows how to do this in Power BI or excel that'd be greatly appreciated.

Thanks!