Find out how to make a Gantt Chart using Microsoft Excel - as used by professional project managers.
- Set your timeline across the top. Each column should be a time unit – e.g. week / month.
- Allocate a row underneath the timeline for “Milestones“.
- Setup a row for each deliverable, as a list of line items underneath your Milestones row.
- Make the first column larger to allow for deliverable titles.
- Set out your deliverables in the rows arranged in time order, with the first one at the top.
- Alternate the rows with two different colours or shades so that they are easy to differentiate at a glance.
- Test it on a friend. Ask them “Is this easy to understand?” and optimise it with their feedback.
By Business Documents UK Ltd Team . Published: 2019/09/29 8:55:13 AM, Last Updated: 2020/06/17 7:51:32 AM Answer URL
Avoid common mistakes
- Don’t make your Gantt Chart too complex! It should fit on one side of A4.
- Keep it up to date! Things change as a project rolls out, so make sure you update it regularly.
- Keep the number of milestones manageable! Too many milestones makes people lose focus.