Click and 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. Click OK. 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:. 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:. You have really built a Stacked bar chart. Now we need to format it so it looks like a Gantt chart. To do that, we must make the blue parts of each task bar transparent so only the orange parts will be visible.
- Development Life Cycle Gantt Chart!
- How to Make a Gantt Chart!
- flat top buffer brush mac;
These will become the tasks of your Gantt chart. To select all of the tasks bars at once, click on the blue part of any bar in your Gantt chart, then right-click and select Format Data Series , which will bring up the Format Data Series window in Excel. Don't close the Format Data Series task pane because we're going to use it in the next step.
Excel Gantt Chart Maker
You probably also see that the tasks on your Gantt chart are listed in reverse order with the last task on top of the Gantt chart and the first Task listed at the bottom. This is easy to change in Excel. To do so click on the list of tasks along the vertical axis of your Gantt chart. This will select them all and it will also open the Format Axis task pane. What are you looking for? Project Management. Learn how to create Gantt Charts on Mac fast. It is extremely easy and unexpectedly fast to do it with professional and powerful diagramming software.
You can change the priority by clicking on the symbol. To hide a column, right click on a column and choose Hide Column.
How to create a gantt chart
Edraw Infographic. Visio alternative. Electrical symbols. Flowchart symbols.
Find reseller. Edraw Max. How it works. About Edraw. About us.
Excel Gantt Chart Maker – Management Tools
Follow Us. All rights reserved.
- Creating a Gantt chart.
- Excel Gantt chart tutorial + Free Template + Export to PPT!
While planning a project, you may also want to use a yearly calendar or project budget worksheet. This download provides the same functionality as the original free gantt chart template above. The main difference is the formatting. Note : This new design is available for the Pro version as well, but only as an alternative to one of the main files.
One of the reasons why Excel is a useful tool for creating Gantt Charts is that task dependencies can be defined by using Excel formulas. Gantt Chart Template Pro is designed to make this easier than entering your own formulas, but here are a few simple examples you can try:. D10 containing the END date of the predecessor task. The problem with only using formulas is that you can't see the dependencies between tasks when you view or print the chart.
Other Gantt chart software may show dependencies as lines connecting the bars in the gantt chart, but I've never found a simple way for Excel to do that and the lines can get really messy. The simple approach is to list the WBS number of the Predecessor in another column , like in the critical path example above. If you want to try doing this on your own, here is a formula to get you started:.
Gantt Chart Pro uses a formula like this, but it allows up to three predecessors and it accounts for work days. Some Gantt charts are designed to show the critical path and available slack or float time for each task. If every task must be done in sequence, every task is critical and there is no slack time because if one task is delayed, it delays the entire project. However, if some tasks can be done in parallel and have some available slack time, then the project manager may be able to free up some resources to devote to the more critical tasks.