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.
    connect-to-data-tableau
  • Then the Connect page will open, click on Microsoft Excel.
    click-on-connect-to-data-excel-file-tableau
  • Navigate to the downloaded files, select Sample Superstore.xls excel file, which is a saved excel file, and click on Open.
    connect-sample-superstore-to-tableau
  • You can download a Sample Superstore.xls file from the given link: https://chercher.tech/files/
  • Once the data source has been connected, open a new worksheet by clicking on sheet1.
    naviagte-to-sheet1-tableau
  • The Sample Superstore excel file contains the below details.
    sample-superstore-excel-file-tableau
  • 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.
      gantt-graph-with-order-date-and-sub-category-tableau
    • Next, right-click on the Order-date in the column shelf and select the Exact date option.
      select-excat-date-from-drop-down-tableau
    • Now, you can see the graph has been converted to the exact date as below.
      gantt-graph-converted-to-exact-date-tableau
    • Right-click on the Order-Date and select Edit the filter condition to select a range of dates.
      select-edit-filter-option-tableau
    • 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.
      select-order-date-range-tableau
    • 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.
      gantt-graph-in-tableau
0 results
Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions