Find out how to make a Gantt Chart using Microsoft Excel - as used by professional project managers.
- Firstly, set your timeline across the top. Each column should be a time unit – e.g. week / month.
- Secondly, allocate a row underneath the timeline for “Milestones”.
- Then, 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.
- Alternate the row colour with 2 light shades of grey to make it easy to read.
- Set out your deliverables in time order, first one at the top.
- Plot your deliverables in the rows, using at least 2 different colours so that they are easy to understand when you glance at the Gantt.
By Business Documents UK Ltd Team . Published: 2019/09/29 8:55:13 AM, Last Updated: 2019/09/29 3:48:18 PM 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.