First change the values in Draft!G7 and G8 to be percentages rather than integer values.

Although the data in column B and C is linked to a workbook on your pc the formula is working.

If you change B10 to 127 and C10 to 127 you will get a different bar showing.