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: https://chercher.tech/files/
- 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.