BULLET CHARTS
A bullet chart is a variation of a bar chart. It juxtaposes two measures and shows their relation to each other; one is shown using bars, and the other using reference lines that cut across the bars. By plotting these two measures on the same axis, you can easily make a visual assessment. The differences in the two values—as indicated by the gap between the bars and the vertical reference lines—are immediately apparent. The simple, slim design of the bullet chart means a lot of information can be packed into a small space. Therefore, it also lends itself to more crowded dashboards.
For a bullet chart, you need two different measures. A common use case is to plot sales revenue and compare it with an annual or quarterly sales target.
In the sample dataset, you have Sales, but you don't have any target values. So, let's create a little table with sales targets for the four geographic regions of the Superstore data set. Open a blank spreadsheet in Excel...
