Two ways to create a bullet chart in Tableau Desktop (Bullet chart)

A bullet chart, as the name implies, is a way of thinking about the trajectory of a bullet when it is shot out. At first, the bullet chart was developed to replace the kind of odometer that is common on the instrument panel, such as the speedometer, which is based on circular information expression. The non-modified linear representation of a bullet chart allows us to express rich data in a small space, especially in a newspaper medium with an inch-size gold. Similar to commonly seen odometer or speedometer, each unit's bullet chart can only display a single source of data information, and by adding a reasonable measure ruler to display more accurate periodic data information. In addition, the bullet chart through the optimization design can also be used to express a number of similar data comparisons, such as the actual consumption of this year compared with the actual consumption last year, for example, can also express a data and different goals of the proofreading results, such as very good, satisfactory, not good, such as goals. At the same time, as far as our human reading habits are concerned, the linear expression of information is similar to that of the text we are accustomed to, and it has a greater efficiency advantage over the information transmission in relation to the circular composition.

Method 1 Manual production

1. Drag the Product type,product dimension to the Rows panel. The sales metric is dragged to columns with the following effect

2. Add a reference line

A) Right-click on the horizontal axis and click Add Reference Line

b) There are four kinds of formats, here simply add line

c) Do some formatting changes after clicking on the OK application, the effect is as follows, each product category add a mean reference line

d) Remove the reference line, and then we'll compare it with the projected sales.

e) Drag the budget sales to the details panel so that you can select budget sales in the Add Reference Line dialog box

, you can determine whether the sales reach the standard

f) Add a distribution band

Select Fill Up Down

Method 2 Automatic Production

A) Add Product type,product,sales,budget Sales to the corresponding rows and columns, respectively

b) Click Show Me and select the bullet chart icon

The software automatically generates the effect as follows, if not satisfied can be modified by itself.

Two ways to create a bullet chart in Tableau Desktop (Bullet chart)