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 Example

There are multiple ways of creating a Gantt Chart in Tableau. For this demo, we are going to use the Data Source that we created in our previous article.

Show Me window and Sql data Source 1

To create a 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 Dimensions Region to 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 Tableau Gantt Chart from it

Gantt Chart in Tableau 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 below screenshot.

Choose Tableau Gantt Chart From Show Me Window 5

Let me change the Order date value from Year to Week Number present in 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 Measures region to Size shelf present in Marks card.

Change Tableau Gantt Size by adding Measure to Size Shelf 8

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

Gantt Chart in Tableau 9

Approach 2

To create a Tableau Gantt chart, Drag and drop the Country Name, 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 in Tableau 11

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

Change the Marks type from Automatic to Gantt Bar 12

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

Tableau Gantt Chart 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

By highlighting specific block will show you the information about that Gantt chart block

Tableau Gantt Chart 15

This time we will add Table Calculation that will calculate the Order Quantity Difference. To add, please click on the Order Quantity and 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 Tableau Gantt chart block to see the information.

Tooltip to View details 18