Tableau Gantt Chart

The Tableau Gantt Chart is to display the duration of an activity or an event visually. In this article, we will show you how to create a Gantt Chart with an example.

Create a Gantt Chart in Tableau

There are multiple ways of creating a Tableau Gantt Chart. We will use the Data Source we created in our previous article for this demo.

Show Me window and Sql data Source 1

To create a Tableau Gantt Chart, First, Drag and Drop the Country Name and Color fields from Dimensions Region to Rows Shelf.

Please visit Data Labels in Reports and Text Label article to understand the Tableau Data Source.

Add Two Dimension Fields to Rows Shelf 2

Next, Drag and Drop the Order Date from the Dimensions Region to the Columns Shelf.

Add Date to Columns Shelf 3

Let me change this Text Label to this. To do so, Please expand the Show Me window and select the Gantt Chart from it.

Open Show Me Window to Change Matrix 4

Once you choose it from the Show Me window, the Tableau Gantt chart from the start date and end date will be displayed in the data pane, as shown in the screenshot below.

Choose Gantt Chart From Show Me Window 5

Let me change the Order date value from Year to Week Number present each year to see the detailed information.

Change Year to Week Number in Columns Shelf 6

Now you can see that it is displaying Weeks information.

Gantt Chart in Tableau 7

Next, we have to specify the Tableau Gantt chart size. So, Drag and Drop the Order Quantity from the Measures region to the Size shelf present in the Marks card.

Change Size by adding Measure to Size Shelf 8

Now you can see the Gantt Bar (I mean, the Proper one)

Gantt Chart in Tableau 9

The second approach to create a Tableau Gantt Chart

To create a Gantt chart, Drag and drop the Country Name and Color fields from Dimensions to Rows Shelf and Order Date in Dimensions section to Columns Shelf. Next, Let me alter the Order date value from Year to Week Number present each year to see the detailed information.

Alter Date 10

It will automatically generate a Gantt Chart for you.

Gantt Chart 11

If this is not the case, please change the Marks type from Automatic to Gantt Bar mark.

Change the Marks type from Automatic to Gantt Bar 12

Next, add Color Dimension to the Color Card and Order Quantity to the Size shelf in a Tableau Gantt chart.

Add Color dimension to Color shelf 13

Generally, we use the Count Function for Order Quantity. So, let me change the Default Sum to Count. To do so, click the down arrow of SUM(Order Quantity) to open a drop-down menu. Here, Select Measure (Sum) and then Select Count.

Change Size Measure from Sum to Count 14

Highlighting a specific block will show you the information about that Tableau Gantt chart block.

View tooltip 15

This time, we will add a Table Calculation that will calculate the Order Quantity Difference. To add, please click on the Order Quantity, select the Quick Table Calculation option, and then select the Difference as shown below.

Add Quick Table Calculation Difference for size 16

And you can see the result of this.

Tableau Gantt Chart 17

Hover Over a Gantt chart block to see the information.

Tooltip to View details 18