Gantt chart excel free template how to#
Gantt chart excel free template full#
Gantt chart excel free template download#

It’s basic and clearly shows the timescales for each task and provides completion indicator.

Gantt chart excel free template how to#

This template prduces a timeline automatically according to start and end dates as inputted manually or you can edit the formula to input the number of days a task is expected to take (you’ll need to know how to manipulate the formula bar). This Gantt Chart has been produced by Vertex24, who provide a whole range of Excel documents and templates.

The simple/medium complexity Gantt Chart template

Gantt chart excel free template full#

Both the below examples automatically map tasks by start and end dates into a cascade on an self-generated calendar to produce a full project timeline. Self-mapping Gantt Charts are where we really start to experience the benefits of a good template. Medium complexity, self-mapping Gantt Charts ‘Notes’ can be used to provide additional information, and stars can be dragged and dropped to highlight key events and meetings.ĭownload the template here: Simple-ish non-Gantt Chart template It does require a some artistic flare and Excel skill to create something visually interesting, but there’s n o complex formulas to accidentally break. Instead of additional lines for each task, this chart illustrates tasks along a horizontal line, showing lifespans of entire workstreams and activities adjacent to each other.

This template allows you to illustrate complex projects in a way that’s quickly and easily digestible. It probably wouldn’t suit an audience of professional, detail-oriented project managers. It’s especially useful for PowerPoint presentations where space is limited, highlight reports and high-level briefings. This is not strictly a Gantt Chart as it presents data horizontally and doesn’t cascade individual tasks, but it does present projects in a visually interesting and condensed format. The amount of time I’ve spent reformatting charts to get them into a Word report… Aargh!ĭownload it here: Super-simple Gantt Chart template The simple(-ish) non-Gantt Chart Gantt Chart template Ok, so it’s not technically a Gantt Chart, so sue me… (or don’t, whichever) You don’t have to be an Excel expert to use it – and that’s what makes this so useful.Īnd the best thing: doesn’t make a fuss about copy and pasting into a word document – so you can stick it in your report to management board with minimum of fuss. It doesn’t have any fancy formulas so you can’t ‘break it’. It doesn’t show detailed data, such as resource availability, worktime requirements or even exact start and end dates. There’s no clever bells and whistles it’s a basic colour-by-numbers chart, keeping it simple and user friendly. This type is often used where little detail is required or known, such as early procurement bids and high-level reports. You can see all constituent tasks, the time in months they’re expected to be delivered and how they relate to each other. It’s easy to use and easy to understand, giving relevant information without overdoing it on data. The most common Gantt chart type I encounter. The Super-Simple Gantt Chart template The super-simple Gantt Chart – it doesn’t get any easier than this without the use of a crayon

Gantt chart excel free template download#

Each tried, tested and improved though practice.Ī link to download these templates and further information about each is available below. Excel is often the project management tool of choice but finding an intuitive and capable Excel Gantt Chart template can be surprisingly challenging.Ī Google search produces a multitude of template charts (as well as a multitude of adverts) from simple colour-by-numbers grids, to complex formula-based tools, some free, others not.īelow you’ll find a range of free template Gantt Charts, from the super-simple to the more complicated, scaled on a range of complexity depending on Excel skill and level of detail required. Working in the public sector regularly means I don’t have access to Microsoft Project or similar dedicated project management software.