A bullet chart is a variation of Bar chart. In this chart, we compare the value of one measure with another measure in the context of finding the variation in the first measure within a range of variations in the second measure. It is like two bars drawn upon one another to indicate their individual values at the same position in the graph. It can be thought of as combining two graphs as one to view a comparative result easily.

Creating Bullet Graph

Using the Sample-superstore, plan to find the size of profits for the respective sales figures in each Sub-Category. To achieve this objective, following are the steps.

Step 1 − Drag and drop the dimension Sub-Category from the data pane into the column shelf.

Step 2 − Drag and drop the measures Profit and Sales to the Rows shelf.

The following chart appears which shows the two measures as two separate categories of bar charts, each representing the values for sub-categories.

Step 3 − Drag the sales measure to the Marks card. Using Show Me, choose the bullet graph option. The following chart shows the bullet graph.