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.
- Business Plan Template
- Gantt Chart Excel Template
- Action Plan Excel Template
- Project Schedule Excel Template
- Risk Register Template for Excel
- Project Bar Chart Excel Template
- Procurement Plan Excel Template
- Resource Planning Template for Excel
- Project Management Plan Excel Template
- Project Quality Management Plan Template
- Project Proposal and Planning Excel Template
- Risk Analysis and Management Plan Excel template
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.
Post a Comment