This blog post from Stephanie Evergreen of Evergreen Data provides step-by-step guidance on creating bullet charts in Excel.
Each step of the process includes screen shots to make learning this method easier.
"There are usually areas of performance in the background (acceptable/unacceptable, in this case), a target line, and an actual bar the represents your real value. Bullet charts kick ass for showing part-to-whole relationships for single data points, especially in long lists of metrics, like dashboards."
Evergreen, S., (2014), Easy Bullet Charts in Excel, Evergreen Data. Retrieved from: http://stephanieevergreen.com/easy-bullet-charts-in-excel/
'Easy bullet charts in Excel' is referenced in: