Creating Horizontal Stock Charts

You create the chart using a mixture of bar chart and xy-scatter with error bars

First create a bar chart, which will display the Category labels.
Add another series and change to xy-scatter markers only.
Delete secondary axis
Add error bars to xy-scatter, delete y error bars.
Set the error bars so they use custom values for Postive and Negative values.

The source data has the Positive and Negative distances from average calculated by formula