Check out Jon Peltier's web site. Here is a link to his discourse on Bullet charts
https://peltiertech.com/bullet-charts-in-excel/
I am not much of charter myself. I do have a spreadsheet (attached) that demos how to make a thermometer chart. You might be able to modify to meet your needs.