Horizontal bar chart alignment with rows

Hello everyone,

I have been facing this issue for a long time now. I'm trying to align my horizontal bar charts with my data in a particular cell range. Following pictures correctly explain what I want to achieve.

1909247.png

Target_MS_regions.png

Would be great if anyone can suggest a possible way through VBA or any add-in because I am finding it very difficult to do the same by trial and error.



Thanks.

Am I alone on this? :P