KNOWLEDGE BASE

Create a Barbell Chart


Published: 22 Aug 2017
Last Modified Date: 24 Aug 2017

Question

How to make a barbell chart. This chart is also known as a dumbbell chart, a DNA chart, or a connected dot chart.

User-added image

Environment

  • Tableau Desktop 9.0+

Answer

A DNA chart can be created with a dual axis Gantt bar and Circle chart.

The attached example workbook uses the example data set Superstore to demonstrate the following directions:

  1. Drag [Sales] to the Columns shelf

  2. Drag [Sub-Category] to the Rows shelf

  3. Drag [Order Date] to Color on the marks card

  4. Drag [Order Date] to the Filter shelf

  5. In the Filter Field dialog, select Years and click Next >

  6. In the Filter dialog, check only 2014 and 2015 and click OK

  7. On the marks card, in the dropdown, select Circle

  8. Create a calculated field with a name like "2015 Sales" with a calculation similar to the following:

    { FIXED [Sub-Category] : SUM

    (

    IF YEAR([Order Date]) = 2015

    THEN [Sales]

    END

    ) }

  9. Create a calculated field with a name like "Difference" with a calculation similar to the following:

    { FIXED [Sub-Category] : SUM(

    IF YEAR([Order Date]) = 2014

    THEN [Sales]

    END

    ) }

  10. Drag [2015 Sales] to the Columns shelf.

  11. Click [2015 Sales] on the Columns shelf to open the SUM(2015 Sales) marks card.

  12. In the SUM(2015 Sales) marks card, do the following:

    • In the dropdown, select Gantt Bar

    • Remove YEAR(Order Date) from Color

    • Drag [Difference] to Size

    • Optional: click Size and adjust the thickness of the bar with the slider.

  13. Right-click [2015 Sales] on the Columns shelf and select Dual Axis

  14. Right-click the Sales axis at the bottom of the view and select Move marks to front

  15. Right-click [2015 Sale] on the Columns shelf and uncheck Show Header

Did this article resolve the issue?