Gantt Charts and Project Timelines in Excel: What Microsoft Documents

If you need a Gantt chart or project timeline in Excel, Microsoft's own support pages point you in two directions: free Gantt chart templates, or building a timeline graphic with SmartArt. This post explains what those pages document, what we could and could not verify, and how to lay out project data sensibly. Microsoft changes menus, names and availability between versions and licences, so check the current support pages for your version of Excel. If you also want to build your Excel skills more broadly, our guide to Microsoft Excel certification for Dublin professionals is a useful companion.

What Microsoft says about Gantt charts in Excel

Microsoft's support article "Present your data in a Gantt chart in Excel" says that "a Gantt chart helps you schedule your project tasks and then helps you track your progress". It states that Excel does not have a predefined Gantt chart type, and instead links to free Gantt chart templates. It also notes that a Microsoft 365 subscription offers Gantt chart templates with visual reminders and colour-coded categories.

The article lists Excel for Microsoft 365 (Windows and Mac), Excel 2024 (Windows and Mac), Excel 2021 (Windows and Mac), Excel 2019 and Excel 2016 as the versions it applies to. The page shows no "last updated" date in its visible text; its metadata lists a content date of 12/11/2025 and an update timestamp of 2026-06-25.

A limitation: the article's Windows and Mac tabs carry the step-by-step instructions, and we have not verified them, so we do not reproduce Microsoft's steps. Open the article for your version and follow it directly rather than relying on a summary from a third party.

Timelines are a different tool from Gantt charts

A Gantt chart usually shows tasks as bars with a start and a duration, so you can see overlap and sequence. A timeline, by contrast, shows a sequence of events or milestones. Microsoft has a separate article, "Create a timeline", which explains how to make a SmartArt timeline in Excel, Word, Outlook and PowerPoint.

According to that article, on the Insert tab you select SmartArt, choose Process, and double-click a timeline layout such as Basic Timeline or Circle Accent Timeline, then type or paste text into the placeholders or the Text Pane. Further steps cover adding and moving dates, changing the layout, changing colours and applying a style from the SmartArt Design tab. The article links to timeline templates and applies to Microsoft 365 versions and to 2024 and 2021 versions on Windows and Mac. Its metadata lists a content date of 04/04/2026 and an update timestamp of 2026-09-26.

Our suggestion: use a SmartArt timeline for a handful of milestones you want to show on one slide or page, and use a Gantt-style chart when the audience needs to see how tasks overlap.

Charts in Excel: the documented basics

Because a Gantt chart in Excel is, in effect, a chart built on a task table, it helps to know how Excel's chart creation is documented. Microsoft's article "Create a chart from start to finish" says to select the data, go to Insert, open the recommended charts option, preview a chart on the Recommended Charts tab, select it and choose OK. It adds that you can select your data and press Alt+F1 to skip the recommendations, though the result may not be the best fit, and that an All Charts tab lists every chart type. It mentions column, bar, pie, line and scatter charts. It applies to Excel for Microsoft 365, 2024, 2021, 2019 and 2016, and its metadata shows a content date of 01/27/2026 and an update timestamp of 2026-09-11.

That article does not describe building a Gantt chart. We mention it only so you know where the general chart documentation sits. If you want charts that serve an executive audience, see our guide to financial dashboards in Excel for executive reporting.

Setting up the plan data: our suggestions

These tips are ours, not Microsoft's. Whatever method or template you use, a Gantt chart is only as good as the table behind it. A practical approach for a finance or change project:

• One row per task. Keep task names short and specific, for example "Agree close calendar" rather than "Planning".
• Start date and duration in separate columns. Excel treats dates as numbers, so an end date can be calculated as start date plus duration. Decide whether durations are calendar days or working days and say which.
• An owner and a status column. These cost little and make the plan usable in a weekly meeting.
• Milestones as zero-length or one-day tasks. Label them clearly so they are not mistaken for work.
• A note on dependencies. A simple chart does not enforce dependencies automatically. If task B cannot start until task A ends, write that in a column and update dates by hand when A moves.

When you adopt a template, check how it expects dates to be entered and whether it recalculates when you change them. Read the template's own instructions rather than assuming.

Keeping the chart readable and accessible

Some general guidance that is documented elsewhere by Microsoft is worth applying to project charts. Microsoft's PowerPoint accessibility article advises that colour should not be the only way information is conveyed, suggests testing slides with the Windows grayscale colour filter, and says text should be readable in a high contrast mode. If you paste a Gantt chart into a presentation, those points apply to its colour-coded bars. Our suggestion is to add a text label, a pattern or a status column so the chart still makes sense without colour.

Also consider how many tasks to show. A chart with sixty rows is hard to read on a slide. Group detailed tasks under summary rows for the board view and keep the detailed plan on a separate sheet.

When Excel is and is not enough

Our suggestion: Excel is a reasonable place for a small plan with a modest number of tasks, particularly when the team already works in spreadsheets. As plans grow, with many dependencies, multiple teams or frequent rescheduling, maintaining dates by hand becomes error-prone, and you may want a purpose-built scheduling tool. That is a judgement for your team, and we are not recommending any product here.

If project planning is becoming a regular part of your role, you may also want to understand the professional route. Our guide to project management qualifications in Dublin compares the main credentials.

What this guide does not cover

• This guide does not describe Microsoft's step-by-step Gantt chart instructions for Windows and Mac; follow the current Microsoft page.
• We do not name individual templates, because the support article refers to the templates only generally.
• Menu names and availability depend on your version and licence. Check the current support pages.

Learnsignal's offices are off Baggot Street in Dublin, and we offer in-person training from there. For current details, see our CPD pages.

Frequently asked questions

Does Excel have a built-in Gantt chart type?

Microsoft's support article says Excel does not have a predefined Gantt chart type and points to free Gantt chart templates instead.

What is the difference between a Gantt chart and a timeline?

A Gantt chart typically shows tasks as bars against a time scale so you can see duration and overlap. A timeline shows a sequence of events or milestones. Microsoft documents a SmartArt timeline separately from its Gantt article.

Which Excel versions does Microsoft's Gantt article cover?

It lists Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 (with Mac editions of the first three), and the page has Windows and Mac tabs.

How do I keep a Gantt chart accurate when dates change?

Our suggestion: keep start dates and durations in cells and calculate end dates from them, so the chart follows the table. Record dependencies in a column and review them whenever a date moves.

Start with the plan data, then choose a template or timeline style to present it, and check the current Microsoft instructions for your version.