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.

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.

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 the Dimensions Region to the Columns Shelf.

Create a Gantt Chart in Tableau

Let me change this Text Label to this. To do so, Please expand the Show Me window and select the Gantt Chart from it. Please visit Data Labels in Reports and Text Label article to understand the Tableau Data Source.

Open Show Me Window to Change Matrix

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 Tableau Show Me Window

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

Now you can see that it is displaying Weeks’ information.

Gantt Chart in Tableau Showing weekly information

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.

Next, add the Color field to the Rows shelf to further divide the chart. Now you can see the Gantt Bar (I mean, the Proper one).

Gantt Chart in Tableau With Colors

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.

Change Date from Year to Week Number

It will automatically generate a Gantt Chart for you. If this is not the case, please change the mark type from Automatic to Gantt Bar mark.

Change the Marks type from Automatic to Gantt Bar

Next, add Color Dimension to the Color Card and Order Quantity to the Size shelf in a Tableau Gantt chart. 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

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

View tooltip to check the information

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

And you can see the result of this. Hover Over a Gantt chart block to see the information.

Tableau Gantt Chart Tooltip to View details