How to Make a Gantt Chart in Microsoft Excel

How to Make a Gantt Chart in Microsoft Excel

In this tutorial, we will show you how to create a Gantt Chart using Excel. Excel doesn't actually have a default Gantt Chart, therefore we will modify a bar chart to turn it into a Gantt Chart. 
Step 1: First we need to enter our data such as the tasks, the start date, days completed and days remaining. See the image below and enter your data exactly as shown in the image.

Step 2: After entering your data into the cells, you can start building your Gantt Chart.

Step 3: Right click on the blank chart and select data.

Step 4: After clicking OK in the Start Date Series box the Select Data Source" box will appear again.

Step 5: Right click on the chart again. Select Data and add a new series. This time you will add the "days completed" to the chart. You will do the same thing you did for the start date. Enter "Days completed" in the Series Name and select all the cells (even the cell without content) listed under Days Complete. See Below.
Step 6: Now we will add another series to the chart for the Days Remaining column the same way we did the Start Date Series and the Days Completed Series. 

Step 7: In this step, we will hide the Start Date Bars because they are not needed for visual purposes in our Gantt Chart. 
Previous Post Next Post