Building an Excel Bullet Graph

Bullet charts are excellent devices for clear data visualization. They have become part of the graphing toolset for a number of dashboard and business intelligence graphing software applications.

Did you know that you can build them yourself for use in Excel?

Here are a couple of great tutorials for doing so.

The first comes from Micheal Alexander of Excel 2007 Dashboards & Reports For Dummies fame.

He has a video at DataPigTechnologies.com on exactly how to create bullet graphs in Excel.

Here is a screenshot from the video. Click on the image to enlarge it.



Another great tutorial on Excel bullet chart construction is from Charley Kyd of ExcelUser.com.

His page on bullet graphs is quite excellent. Here is a screenshot of a part of the tutorial. You can also download example excel worksheets with the bullet charts so be sure to visit the link.