How to create a Gantt chart with Copilot: step-by-step guide (2026)

Microsoft Copilot is an AI assistant built into Microsoft 365 that uses large language models to help generate, organize, and refine content. Instead of starting from scratch in a spreadsheet or project tool, you can ask Copilot to outline your project structure, list tasks with dates, and format the results into a table.

Copilot works directly with Microsoft apps like Excel, so once it generates your schedule, you can easily convert that data into a Gantt chart using built-in Excel chart tools. 

However, Excel-based Gantt charts are static and require manual updates. For ongoing project management, you can move the same task list into GoodDay and switch to Gantt view. This allows you to manage dependencies, adjust timelines with drag-and-drop editing and track progress in real time.

In this guide, we’ll walk you step-by-step how to use Copilot to create a Gantt chart. But if you have any questions that are not covered in this article, you can always reach out to our team at info@goodday.work 

Steps to create a Gantt chart with Microsoft Copilot

To create a Gantt chart in Microsoft Excel with Copilot, first ensure your data is properly formatted into a table with columns for Task Name, Start Date, and Duration. Then, open the Copilot pane and use a specific prompt to let AI build and format a stacked bar chart for you, such as: “Create a Gantt chart showing each task by start date and duration using a stacked bar chart.”

Step 1: Prepare your data

Open Excel and create columns for Task Name, Start Date, and Duration. Enter all tasks with accurate dates and estimated timeframes.

Step 2: Format your data as a table

Select the data range and press Ctrl+T to format it as a table. This allows Copilot to properly recognize and analyze your structure.

Step 3: Activate Copilot

Click the Copilot button in the Excel ribbon. This opens the assistant panel where you can enter your request.

Step 4: Enter a clear prompt

Type a specific instruction such as: “Create a Gantt chart using this data.”  The clearer your request, the better the result.

Step 5: Insert the generated chart

Review the chart created by Copilot. If it looks correct, select “+ Add to a new sheet” to insert it into your workbook.

Step 6: Move your schedule into a project management tool

Excel Gantt charts are static and require manual updates when timelines change. To manage dependencies, track progress, and coordinate teams, you can move your task list into a project management platform like GoodDay.

Build your Gantt chart in minutes with GoodDay

GoodDay is a comprehensive project management software with powerful Gantt charts. It is trusted by Fortune 500 companies, growing startups, and established organizations worldwide. The platform has been recognized as top software in 12 Capterra shortlists.

With GoodDay, you can:

• Manage dependencies
• Drag and reschedule tasks directly on the Gantt timeline
• Connect Gantt charts to goals, tasks, and team workload
• Plan and monitor multiple projects
• Track progress in real time

Teams choose GoodDay because its Gantt charts can be fully connected to all your project data. You can build your Gantt chart in a few clicks using GoodDay. 

And if you have questions about building your Gantt chart or would like to explore how GoodDay can support your workflows, you can always contact our team at info@goodday.work 

FAQs

What Copilot can do?

Microsoft Copilot acts as an AI companion, boosting productivity by summarizing, drafting, researching, and generating content across Microsoft 365 apps and the web. It operates in browsers and apps, assisting with tasks like drafting emails, creating images, analyzing Excel data, and summarizing Teams meetings, acting on user prompts to streamline workflows.

What is a Copilot in Excel?

Copilot in Excel is an AI-powered assistant designed to help users analyze, format, and visualize data using natural language prompts. It works within the Excel ribbon to automate complex tasks, such as generating formulas, creating charts, highlighting trends, and cleaning data, without requiring advanced formula knowledge. It uses the spreadsheet context to understand your goal, reduce manual effort, and help streamline work with practical tips.

What Copilot can do in Excel?

Copilot in Excel acts as an AI assistant to analyze, format, and edit data using natural language prompts, capable of creating formulas, generating charts, and highlighting insights within tables. It streamlines workflows by automating complex tasks like text extraction and data filtering, functioning on files stored in OneDrive or SharePoint.

How do I enable Copilot in Excel?

To enable Copilot in Excel, ensure you have a Copilot Pro or Commercial subscription, then save your file to OneDrive/SharePoint, use the AutoSave feature, and look for the Copilot icon on the Home tab ribbon. If it’s missing, update your license in File > Account > Update License. You may need to upgrade your Microsoft plan, confirm account access, and check whether Copilot is available for your future workflow.

Can Copilot make charts in Excel?

Yes, Microsoft Copilot can create graphs and charts in Excel, including line charts, column graphs, scatter plots, and pie charts, based on your data. It can analyze datasets, suggest visualizations, and generate them directly into the sheet, provided the data is formatted as a table. For example, you can use clear commands to discover patterns and transform raw data into a visual summary.

Can Copilot make Gantt charts in Excel?

Yes, Microsoft Copilot can create Gantt charts in Excel by automatically generating them from your structured project data. By prompting Copilot to “create a Gantt chart” based on tables containing task names, start dates, and durations, it can build the visualization, saving time on manual formatting. You can use it to map a week of work, define the key timeline, and support project execution.

How to use Copilot in Excel table?

To use Copilot in an Excel table, ensure your file is saved on OneDrive or SharePoint and formatted as an Excel table (Ctrl + T). Open Copilot from the Home ribbon, choose between Chat or App Skills, and simply type your prompt to analyze or edit your data. You can customize table outputs, add comments for review, and collaborate with teammates in a clearer direction.

How to use Copilot for data visualization?

Using Microsoft Copilot for data visualization is all about using natural language prompts to generate, analyze, and format visual data without needing to write complex formulas or build charts manually. The process is essential when you want to focus on insights instead of building every chart by word-by-word instructions.

Can Copilot help me create a Gantt chart?

Yes, Microsoft Copilot can help create charts inside Microsoft Excel when your data is properly structured. By entering clear prompts, it can generate a Gantt-style timeline from a formatted table. The result is helpful for visualization but remains spreadsheet-based. For advanced planning and tracking, GoodDay provides stronger built-in Gantt functionality.

Can Copilot generate a chart?

Copilot can create charts directly from organized data in Microsoft Excel. It interprets natural language prompts and converts table data into visual output. This makes it easier to save time when preparing timelines or summaries. However, these visuals do not automatically manage updates across larger workflows.

Can Copilot create a project schedule?

Copilot can draft a project plan by organizing specific tasks into a structured table. It can suggest timelines and arrange data clearly for review. The schedule must still be reviewed and adjusted manually. Dedicated project management platforms offer more control over ongoing updates.

Does Copilot have a project management tool?

Copilot is an AI assistant integrated into Microsoft 365 applications. It does not function as a standalone project management system. It helps with drafting, formatting, and data analysis tasks. For full-scale coordination, GoodDay is designed specifically as project management software.

What’s the best tool to create a Gantt chart?

Microsoft Excel can be used to build a Gantt chart based on formatted data. However, managing task dependencies, updates, and workload planning requires more specialized functionality. GoodDay provides interactive Gantt charts connected to tasks, goals, and team activity. It is built to support structured project tracking at scale.

Is Copilot the same as ChatGPT?

Copilot and ChatGPT both use AI technology, but they serve different purposes. Copilot is embedded within Microsoft applications, while ChatGPT is a standalone conversational assistant. Their workflows and integrations differ even though both rely on advanced AI models. Each tool supports different use cases.

How do I organize project tasks before creating a Gantt chart?

Start by listing all project tasks with clear start dates and durations. Break large goals into smaller, manageable items to improve clarity. Structure the data in a clear table format before generating the timeline. This preparation improves accuracy and reduces confusion later.

How can I track project progress using a Gantt chart?

A Gantt chart helps you track project progress by showing completion percentages across tasks. It provides a visual overview of project status and highlights delays. Monitoring the critical path helps identify which tasks directly affect deadlines. GoodDay updates progress automatically when tasks change.

Can Copilot automatically create charts from my task list?

Yes, Copilot can create charts from structured data when you provide clear prompts. It uses your formatted column layout to build visual outputs. The generated chart can then be edited inside Excel. For more advanced dependency management, project management software is more suitable.

How to turn meeting notes into action items and add them to a Gantt chart?

You can use AI tools to extract action items from meeting notes. After identifying tasks, add them into a structured table with dates and durations. Then convert that data into a timeline view. In GoodDay, those tasks can be directly connected to dependencies and tracked over time.

How do project managers use Gantt charts for planning and reporting?

Project managers rely on Gantt charts to plan timelines and monitor dependencies. They generate reports to share updates with stakeholders and provide an executive summary. These visuals help highlight priorities and potential risk areas. GoodDay simplifies reporting with customizable dashboards and timeline views.

How does a Gantt chart improve resource allocation across multiple tasks?

A Gantt chart improves resource allocation by showing how resources are distributed across tasks. It helps identify when a team member is overloaded or underutilized. This visibility supports better scheduling decisions. GoodDay provides a unified view across projects to optimize resource allocation effectively.