Gantt Chart in Tableau

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

For this we are going to use the Data Source that we created in our previous article. Please visit Data Labels in Tableau Reports article to understand the Data Source.

Gantt Chart in Tableau Example

There are multiple ways in creating a Tableau Gantt Chart

Create a Gantt Chart in Tableau – First Approach

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

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

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

Once you select the Gantt from Show Me window, Gantt Chart will be displayed as shown in below screenshot.

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

Now you can see the gantt chart that is displaying Weeks information

Next we have to specify the Gantt size. So, Drag and Drop the Order Quantity from Measures region to Size Card present in Marks Shelf.

Now you can see the proper Gantt Chart

Create a Gantt Chart in Tableau – Second Approach

First, Drag and Drop the Country Name, Color fields from Dimensions Region to Rows Shelf, and Order Date from Dimensions Region to Columns Shelf. Next, Let me change the Order date value from Year to Week Number present in each year to see the detailed information

This will automatically generate a Gantt Chart for you.

If this is not the case then, Please change the Marks field from Automatic to Gantt Chart

Next, let me add Color Dimension to Color Card, and Order Quantity to Size Card.

Generally we use 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

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

This time we will add Table Calculation that will calculate the Order Quantity Difference. In order to add, Please click on the Order Quantity and select the Quick Table Calculation option and then select the Difference as shown below

And you can see the result

Hover Over a block to see the information