Build a Bullet Graph

A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures. Below is a single bullet graph showing how actual sales compared to estimated sales.

Follow the steps below to learn how to create a bullet graph.

  1. Connect to the World Indicators data source.
  2. Navigate to a new worksheet.
  3. Hold down Shift on your keyboard and then, on the Data pane, under Development select Tourism Inbound and Tourism Outbound.
  4. In the upper-right corner of the application, click Show Me.
  5. In Show Me, select the Bullet Graph image.
  6. Click Show Me again to close it.
  7. From the Data pane, drag Region to the Rows shelf.

    The graph updates to look like the following:

    A viz with a bullet graph representing inbound tourism by region.

Check your work! Watch steps 3 - 7 below:

Create a bullet graph in Tableau.

Note: In Tableau 2020.2 and later, the Data pane no longer shows Dimensions and Measures as labels. Fields are listed by table or folder.

Swap reference line fields

Sometimes you might want to swap the reference lines fields. For example, the actual sales is shown as a reference distribution instead of a bar.

To swap the two measures, right-click (control-click on the Mac) the axis and select Swap Reference Line Fields.

Bullet graph context menu with the Swap Reference Line Fields option highlighted

Edit the distribution

Right-click (control-click on the Mac) the axis in the view and select Edit Reference Line, and then select one of the reference lines to modify.

Edit Reference Line, Band, or Box dialog with the computation value option selected to show that percentages of 60 and 80% of average budget sales is set.