Present Borehole Depth data as a visual Bar Graph

Hi All,

I was wondering if someone could help me with the following, sorry if this has been posted before.

I am trying to present borehole geology i.e. sand unit 1 and clay unit 2 on a bar graph with depth (y axis) per location (x-axis). I.e. for Borehole 1 show in red Unit1 from 0m to 1m then Unit 2 in yellow from 1m to 2m, then for Borehole 2 show Unit 1 at 0m to 5m, and so on. However, I am struggling to do this on a clustered bar graph as it always Sums or averages my depth data.

I have an example of what I after in the following link on the right in the first few seconds, but this is a custom visual. An example of the data I would like to present is attached below. https://www.youtube.com/watch?v=2QNKP-CX4Dc 

Any help would be much appreciated!