We just need to refer to Pivot Table values to get first three columns (Activity, Start and Finish).
The left side portion of our project plan is rather simple to make. Step 4: Making the left side of gantt chart Feel free to adjust the number of columns based on your needs. In a new worksheet, set up gantt chart outline like below. Step 3: Create a gantt chart empty outline Related: Learn how to create Pivot Tables in Excel.