It’s a perfect chart to use when you need to present single point target Vs. Achievement.

According to Wikipedia:

A bullet graph is a variation of a bar graph developed by Stephen Few. Seemingly inspired by the traditional thermometer charts and progress bars found in many dashboards, the bullet graph serves as a replacement for dashboard gauges and meters.

And in today’s post, I’m going to share with you how to make a bullet chart in Excel using simple steps.

Sample File

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.