Vertical value and range chart

[Data_Cognition_Ltd]

First time I'm creating a post as I think I'm usually okay at finding solutions in Excel, but this has got me scratching my head. I'm trying to create a chart that shows a vertical list of categories that each have a value, and whiskers that plot the range in which the category values should be within. I've attached a drawing of what i would like the chart to look like. My initial thought was line chart with high/low lines, but you cannot flip the axis. Any help/solutions appreciated.