TabCharts.com

An on-line library for creating different chart types in Tableau



Bullet Graph






Tableau Canvas Layout:





A bullet graph is a bar chart with a target line. A typical bar chart will have one or more dimensions on the Rows and a Measure on the Columns for a horizonal bar chart, or vice-versa for a vertical bar chart. Adding a Reference Line will create the target line for the bullet graph. This can be based on Measure which is placed on the Details of the Marks Card. In addition, bullet graphs can have performance bands. The performance bands are created using Distribution Bands.


Data Set: Coffee Chain Data



Building a Bullet Graph


Using the Coffee Chain data:

     Double-click Product Line to move it to Rows.
     Double-click Product Type to move it to Rows.
     Double-click Product to move it to Rows.
     Move Sales to Columns.
     Move Budget Sales to Details on the Marks card.
     Click the Analytics.
     Move Reference Line to the Tableau Canvas and drop it on Cell.
     Set the Line Value to "Sum (Budget Sales).
     Set Label to None and click OK.

You should now have a bar chart with a target line similar to the image below.




Adding Performance Bands


     From the Analytics tab Move Distribution Band to the Tableau Canvas and drop it on Cell.
     On the Edit Distribution Band screen, check "Fill Above" and "Fill Below"
     Change the Value from 60%, 80% as desired.
     Right-click in the chart area and select "Format". Click the "Line" icon and the Columns tab and set Gridlines to "None".





You should now have a bullet graph similar to the image below.




Related Material:


Bar Chart
Tableau 201: How to Make Bullet Graphs by Ryan Sleeper


Return to the TabCharts.com chart gallery