Abstract charts on a blue background

Gantt charts

Visualize a project to schedule timings or dependencies with free online Gantt chart templates in Microsoft Excel.

Keep project tasks on schedule with Gantt chart templates

Use free Gantt chart templates in Excel to visualize task progress over time. Customize pre-built charts with task categories, risk levels, progress, start dates, and more. Create a central hub to communicate project status with stakeholders.

Save time with online templates

Start with template examples that automatically create horizontal bars based on your tasks. Customize parameters like planned start, actual start, duration, category, assignee, and progress.

A manufacturing gantt chart template on a green background

Track project progress

Track a sequence of critical tasks along with floating activities across a timeline. See on-track or at-risk status with bar colors. View your progress with completion percentages and a column highlighting the current day or period.

A project tracking chart on a green background

Manage project resources

Assign resources like team members, equipment, and materials to tasks. See where certain resources might overlap, and modify the schedule to avoid bottlenecks or unused resources.

A woman working on a laptop at a cafe

Provide accurate reporting

Use a Gantt chart in Excel to easily communicate milestone completion to stakeholders like executives, clients, and sponsors. Show the sequence of actions your team is taking to execute the plan on time.

Charts with modern green abstract blocks

Powerful customization tools

Use Excel functions like conditional formatting to highlight dependent tasks and dropdown lists for assignee and status. Easily transform data from a project plan in Excel to create your Gantt chart spreadsheet.

A spreadsheet with a dropdown menu

Use Copilot for online help

Chat with Microsoft Copilot in Excel to extend timeline columns or create a column for task dependencies. Ask Copilot to customize the time scale to fit your project to then make a Gantt chart based on your task table.

A man working on spreadsheets across three monitors

Share Gantt charts online

Use comments and tags to collaborate with team members in Excel online. Create sharing links for easy syndication and specify access and editing permissions for selected users. Set expiration dates for sharing links over a specific timeframe to control access to sensitive information.

A man with a laptop in a garden alongside a comment in a spreadsheet from a coworker to resolve the data

Personalizable Gantt charts template designs

  • Project managers: visualize tasks and resources across a timeline.

  • Construction managers: create construction schedules to manage phases and subcontractors.

  • Event planners: schedule logistics and vendor activity leading up to an event.

  • Software teams: plan development milestones and feature rollouts.

  • Consultants: track client deliverables to meet deadlines.

Gantt chart templates on a green background

How to create a Gantt chart in Excel 

  1. Start with a Gantt chart template or use Copilot to build a data table and stacked bar chart

  2. Verify the time scale matches your needs or modify it

  3. Add the name, starting date, duration, and status of each task in the data table

  4. See stacked bars automatically reflect your data

  5. Record actual task durations and statuses during your project

User interface for creating a blank spreadsheet

Frequently asked questions

Create Gantt charts with Microsoft Excel