A bullet graph/chart is a variation of Bar chart. In this chart, we can compare the value of one measure with another measure value in the context of finding the variation in the first measure within a range of variations in the second measure.
It is like drawing two bars upon one another to indicate their individual values at the same position in the graph. It is like combining two graphs as one, to view a comparative result to understand it easily.
Creating a Bullet graph:
- Open Tableau and click on Connect to Data.
- Then the Connect page will open, click on Microsoft Excel.
- Navigate to the downloaded files, select Sample Superstore.xls excel file, which is a saved excel file, and clicks on Open.
- You can download a Sample Superstore.xls file from the link: https://chercher.tech/files/
- Once the data source has been connected, open a new worksheet by clicking on sheet1.
- The Sample Superstore excel file contains the below details.
- Here, we are going to find the size of profits for the respective sales figures in each Sub-Category.
- To achieve this, follow the below steps in the Tableau worksheet:
- Drag and drop Sub-Category value to the column shelf.
- Drag and drop the measure values Profit and Sales to the Row shelf.
- Now, the following chart shows you, two measures as two separate categories of bar charts, each representing the values for sub-categories.
- Now, drag the sales measure to the Marks card.
- Choose the bullet graph from Show Me.
- The following chart will appear.