Gantt charts are most commonly used in project management as these charts show various activities and tasks with the time required to complete those tasks. Gantt charts are even more useful when they show dependencies among various tasks. This type of chart is very helpful when the number of activities is low (around 20-30), otherwise the chart becomes too big to be understood easily.
Let's use the sample file Sample – Superstore Sales (Excel)
. Open a new worksheet and select Sample – Superstore Sales (Excel) as the data source.
Once the data is loaded, perform the following steps to create a Gantt chart:
Click on Analysis from the top menu toolbar, and if Aggregate Measures is checked, click on it again to uncheck that option.
Click on the Show Me button to bring the Show Me toolbar on the screen.
While holding the Ctrl key, click on Order Date and Category (under Products) from Dimensions and Time to Ship from Measures.
Click on the Gantt chart...