Table of content

Gantt Chart in Tableau

A Gantt chart shows the progress of the value of a task or resource over a period of time. Most commonly used in project management and other types of variation study over a period of time. Thus, in the Gantt chart, the time dimension is an essential field.

The Gantt chart takes at least a dimension and a measure in addition to the time dimension.

Creating the Gantt Chart:

  • Open Tableau and click on Connect to Data.
  • Then the Connect page will open, click on Microsoft Excel.
  • Navigate to the downloaded files, select Sample Superstore.xls excel file, which is a saved excel file, and click on Open.
  • You can download a Sample Superstore.xls file from the given link:
  • Once the data source has been connected, open a new worksheet by clicking on sheet1.
  • The Sample Superstore excel file contains the below details.
  • Here, we are going to find the variation of quantities of different SubCategory of products according to their ship mode over a range of time.
  • Follow the below steps in the Tableau worksheet:
    • Drag the dimension value, Order Date to the Columns shelf, and Sub-Category to the Rows shelf.
    • Next, add the order date to the Filters shelf.
    • Now, right-click on the order date to convert it to the exact date values as shown in the following screenshot.
    • Next, right-click on the Order-date in the column shelf and select the Exact date option.
    • Now, you can see the graph has been converted to the exact date as below.
    • Right-click on the Order-Date and select Edit the filter condition to select a range of dates.
    • You want an individual date value and there is a very large number of dates in the data.
    • Now, select the range below and click on OK.
    • Drag the dimension ship mode to the Color shelf and the measure quantity to the Size shelf under the Marks card. You can see the Gantt chart as shown below.
0 results
Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions