Bullet graphs are used to compare one value, represented by a horizontal bar, to another value, represented by a vertical line, and relate those to qualitative ranges.

The general idea of bullet graphs is that they can be included directly where they are needed, in the context of a graphical table or in a text area, to provide information at a glance. In the example below, the bullet graph resides in a graphical table:

It compares sales performance for spices in different regions this year to sales performance last year. The background color ranges are qualitative ranges. In the example above they may for example indicate that if the bar is within the leftmost color range, sales performance is poor, while if it is within the rightmost color range, sales performance is good. For general information about colors, see Working with colors.

In the Bullet graph settings, you specify what to show in the bullet graph. Calculate values using specifies the desired column, hierarchy, or expression to base the horizontal bar on, while Calculate comparative values using defines the values for the vertical line.

You can also adjust the Range. Min determines the lower bound of the scale and Max determines the upper bound of the scale. If left blank, the range will automatically adjust to the currently lowest and highest values in the filtered data. Click Set to Current Range to set the min and max to the currently filtered values. The option Include origin makes sure that the value 0 is always included in the bullet graph, regardless of filtering. For general information about scales and labels in visualizations, see Adjusting scales on axes.

Bullet graph in text areas

In the text area, the bullet graph can be shown with a scale, as seen below:

You can customize the scale in different ways in the Bullet graph settings. In the Scale labels section, you can specify whether the scale labels should be visible be selecting Show labels. You can show the scale labels either Horizontally or Vertically, and choose the Max number of labels to improve readability on scales with many values.

Bullet graphs can be configured to be limited by markings, filtering or expressions like any traditional visualization, or they can be locked to show fixed values using the settings in the Data properties for the Bullet graph.