Plotting a column chart with range bars/lines

Hi all, I am trying to generate a column chart with a high-low range overlay so that it looks like error bars. I've precalculated all values but cannot figure out how to add the high-low range lines. I've attached the spreadsheet.

I tried using custom error bars but it did not work. Any help would be greatly appreciated.
treg.xlsx

I see that up-down bars in analysis is not functional with this type of chart, but that is exactly what I want. Any suggestions?