Bullet chart in Excel

A bullet chart is a relatively new kind of chart invented by Stephen Few.  I was pleasantly surprised to see one in a recent copy of  The Wall Street Journal.  A bullet chart looks like a column chart “within” a column chart.  It is a great way to compare 2 series of data together. For example, sales figures from 2 different years.

During our “Creating Executive Dashboards in Excel” course, I’m going to talk in detail how to create such bullet charts in Excel. They are a very compact way to display key performance indicators (KPIs).  It can compare actual performance with “Poor Performance”, “Satisfactory Performance” and “Excellent Performance” levels all within a tiny bullet chart.

Bullet charts from Wall Street Journal

Bullet chart in Excel

Learn more about our Excel training course Creating Dashboards in Excel.

Related posts:

1. Dashboard ideas from Wall Street Journal The Wall Street Journal have a lot of good looking charts which I draw my dashboard ideas. You can hardly find any in BusinessWeek or...
2. A magazine quality chart in Excel I know the idea of creating beautiful charts in Excel seems unfamiliar, but I assure you Excel is a very capable platform to do so....
3. Excel Line Charts with Elegant Dates I came across this stock chart in the Kuala Lumpur’s edition of the Business Times while I was in Malaysia. The chart has an elegant...