How to Create a Gantt Chart in Excel? Step-by-Step Tutorial for Creating a Gantt Chart in Excel We all love Microsoft Excel and we use it almost every day for everything — from a simple calculator to tracking massive projects. For this reason, we created Gantt Excel, an automated excel template that allows you to create professional-looking Gantt Charts in Excel. Before we begin, what is a Gantt Chart?
Creating Excel Gantt chart takes approximately: List your project schedule in an Excel table Break down the entire project into chunks of work, or phases. These will be called project tasks and they form the basis of your Gantt chart.
In Excel, orenter your data by listing the Start Date and Finish Date of each task, and also it's Duration count of days required to complete that task. Also include a brief description of the task. Make sure to sort these tasks in order, by placing the earliest start date first and the latest start date last.
Begin making your Excel Gantt by setting it up as a Stacked Bar chart From the same worksheet that your Excel table is on, click in any blank cell.
In the Charts section of the ribbon, drop down the Bar Chart selection menu. Click on the Add button to bring up Excel's Edit Series window Gantt chart here you will begin adding Task data to your Gantt chart.
Now we're going to add your task data. First we need to name the data Series we will be entering. Click Gantt chart place your cursor in the empty field under the title Series name, then click on the column header that reads Start Date in your table. Staying in the Edit Series window move down to Series value.
This is where you will enter your Task start dates. It is easy to do. To the right of the Series values field you will see an icon which looks like a spreadsheet with a red arrow on it.
Click on it the one by Series values and Excel will open a smaller Edit Series window. Now simply click the first start date in your task table and drag your mouse down to the last start date. This highlights all of the start dates for your tasks and inputs them into your Gantt chart.
Make sure you have not mistakenly highlighted the header or any extra cells.
When finished, click on the small spreadsheet icon again the one with the red arrow which will return you to the previous window called Edit Series. Your Gantt should now look like this: Here we will add the duration data to your Gantt chart.
In the Edit Series window, click in the empty field under the title Series Name, then click in your Task table again, on the column header that reads Duration.
Staying in the Edit Series window move down to Series value and click on spreadsheet icon with a red arrow on it again. Select your Duration data by clicking on the first Duration in your project table and drag your mouse down to the last duration so all durations are now highlighted.
To exit, once again click on the small spreadsheet icon with the red arrow to which will return you to the previous window. Click OK again to build your Gantt chart which should now look something like this: Add the descriptions of your Tasks to the Gantt chart Right-click on one of the blue bars in the Gantt chart, then click on Select Data again to bring up the Select Data Source window.
Select the Edit button to bring up a smaller Axis Label windows. Again, click on the small spreadsheet icon. Be careful not to include the name of the column itself.
When you are done, exit this window by clicking on the small spreadsheet icon again.
Your chart should now look something like this:Options for making a Gantt chart. Microsoft Excel has a Bar chart feature that can be formatted to make an Excel Gantt chart. If you need to create and update a Gantt chart for recurring communications to clients and executives, it may be simpler and faster to create .
Gantt Charts are a popular project management tool for planning and scheduling projects. Learn how to use them with our five-step process and video. What is a 'Gantt Chart' A Gantt chart is a graphical depiction of a project schedule.
It's is a type of bar chart that shows the start and finish dates of several elements of a . A Gantt chart, commonly used in project management, is one of the most popular and useful ways of showing activities (tasks or events) displayed against time.
On the left of the chart is a list of the activities and along the top is a suitable time scale. Gantt applications will generally allow you to reflect the project hierarchy in the Gantt's task list at the left of the chart.
Gantt chart task hierarchy Mind mapping software, which encourages creative thinking, will help you to develop a work breakdown structure and ensure that nothing is .
What Is a Gantt Chart? The Gantt chart is one of the most popular scheduling tools in project management. It’s a horizontal bar chart that shows progress on a project schedule.