100% Stacked Bar Graph with Label in the center of the Plot Area

Hi there Guys,

Am trying to implement a progress bar type graph showing the actuals VS the projected values for the month. I have met the basic necessity of mine, i.e., to show the comparison - by using a 100% stacked horizontal bar graph. Where the actual versus the projected is represented in a balance. Actual more towards right shows its above the projected ones and towards left more - it shows is within the projections but is lower in numbers.

My requirement : is to show the ratio (actual / projection) in the center of the graph.
My Workaround : As of now, am using a textbox from the drawing tab and entering the cell reference to show the ratio in the center. Its manually assigned and aligned to the center for each graph I make for the respective projects.

My request - is it possible I can use the data label of the graph itself to be aligned to the center of the plot or chart area? If yes, any guidance please. I have attached a sample of what I have done and what I need it to be like. I have a list of over 50-60 projects. For charts, my whole working is manual as of now. For cell reference for the chart, its quite fine and am okay with it, but for setting the reference of each textbox to the corresponding cell is becoming tedious and time consuming.

Any bright ideas to handle this.. Would be greatly appreciated.

Why are you not using the built-in data bars?
Or a single chart?

Add another series with fix value and use data point values as the secondary axis category labels.
You can then apply data labels to the dummy series.

Hey Andy, thanks much for fixing it up!

Actually, I had tried databars, but wasn't sure for what reason I was getting no output in the chart. Plus, I ain't that good in charts.. just a beginner and have been getting amused with the way they're implemented.. So just tried that as well.

Thanks a lot buddy!