Creating bullet charts in Excel can be a bit tricky. This slidedeck lays out a step-by-step approach to creating bullet charts in Excel. The approach was first made public by Jorge Camoes. An alternative version was published in early 2011 by Jon Peltier.

Here is the Excel file you can use to create your own bullet chart.