Tableau Gantt Chart – An Easy Way to Track your Data Trend
This Tableau tutorial focuses on learning to use Gantt charts in Tableau. In our tutorial, we will start with learning the definition of the Gantt chart and then learn the process of creating a Gantt chart in Tableau software.
What is a Gantt chart?
A Gantt chart is a horizontal bar chart that shows the duration of an event for multiple values. You can have a detailed yearly, quarterly, monthly, weekly or even daily representation of your data values using a Gantt chart.
Also, we can assign different colors for each year or month so that it is getting easier for us to track the data trend for value over time. Gantt charts are extremely useful as they have the ability to represent data in great detail.
Wait!! have you checked our previous article on LOD expression in Tableau, to deal with the complex data.
How to create a Gantt chart in Tableau?
Before we start making our Tableau Gantt chart, take note of a few things that you must keep in mind and select while creating the chart.
- Mark type: Gantt bar or automatic
- Column shelf: Date or time field (continuous measure)
- Rows shelf: Dimension
- Size: Continuous measure
Follow the steps given below to create a Gantt chart in your Tableau worksheet. Please note that we are using our sample data set for electronic sales to make this chart. You can understand the basics of this chart and create your own Tableau Gantt Chart with your dataset.
Step 1: Drag Order Date Dimensions to Columns Section
Open your Tableau Desktop and open a new worksheet in it. You will find a list of Dimensions and Measures in the Data pane on the left. We drag the Order Date dimension to the Columns section as shown in the screenshot below.
Step 2: Drag another Dimension in Rows Section
Step 3: Add Order Date in Marks Card
Step 4: Add Measures in the Marks Card
Step 5: Simple Tableau Gantt Chart
This gives us a simple Tableau Gantt chart showing the total quantity sold for each brand or Sub-category in the span of five to six years. As you can notice in the screenshot attached below, there is a separate bar with distinct colors for each year so that you can get the value of the total quantity for each brand in each year specifically.
Step 6: Add Detail in Tableau Gantt Chart
We can add as much detail in our Gantt chart as we like. For instance, we change the years to months. As you can see, the chart became more detailed showing distinct bars for total quantities sold each month.
This will show only the maximum quantities sold for each brand in each year distinctively.
Step 7: Set Filters on Date Measures
Know more different types of filters in Tableau.
Step 8: Check Data in Gantt Chart
Thus, this Gantt chart is showing data only for the years 2018 and 2019.
Now!! Jump into the steps for creating a Tableau Funnel Chart.
So this concludes our tutorial on Gantt charts in Tableau. We hope you can now easily create Tableau Gantt charts with your dataset for analysis. If you have any queries in any of the steps, do mention in the comment section. We will be happy to help you.