{"id":3202,"date":"2026-05-12T10:56:19","date_gmt":"2026-05-12T14:56:19","guid":{"rendered":"https:\/\/www.goodday.work\/blog\/?p=3202"},"modified":"2026-05-16T08:27:39","modified_gmt":"2026-05-16T12:27:39","slug":"how-to-create-a-gantt-chart-with-copilot","status":"publish","type":"post","link":"https:\/\/www.goodday.work\/blog\/how-to-create-a-gantt-chart-with-copilot\/","title":{"rendered":"How to create a Gantt chart with Copilot: step-by-step guide (2026)"},"content":{"rendered":"\n

Microsoft Copilot<\/a> 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.<\/p>\n\n\n\n

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. <\/p>\n\n\n\n

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<\/a>. This allows you to manage dependencies, adjust timelines with drag-and-drop editing and track progress in real time.<\/p>\n\n\n\n

In this guide, we\u2019ll 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<\/a>\u00a0<\/p>\n\n\n\n

Steps to create a Gantt chart with Microsoft Copilot<\/h2>\n\n\n\n
\"How<\/figure>\n\n\n\n

To create a Gantt chart in Microsoft Excel with Copilot<\/a>, 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.”<\/p>\n\n\n\n

Step 1: Prepare your data<\/h3>\n\n\n\n

Open Excel<\/a> and create columns for Task Name, Start Date, and Duration. Enter all tasks with accurate dates and estimated timeframes.<\/p>\n\n\n\n

Step 2: Format your data as a table<\/h3>\n\n\n\n

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

Step 3: Activate Copilot<\/h3>\n\n\n\n

Click the Copilot button in the Excel ribbon. This opens the assistant panel where you can enter your request.<\/p>\n\n\n\n

Step 4: Enter a clear prompt<\/h3>\n\n\n\n

Type a specific instruction such as: \u201cCreate a Gantt chart using this data.\u201d  The clearer your request, the better the result.<\/p>\n\n\n\n

Step 5: Insert the generated chart<\/h3>\n\n\n\n

Review the chart created by Copilot. If it looks correct, select \u201c+ Add to a new sheet\u201d to insert it into your workbook.<\/p>\n\n\n\n

Step 6: Move your schedule into a project management tool<\/h3>\n\n\n\n

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<\/a>.<\/p>\n\n\n\n

Build your Gantt chart\u00a0in minutes with GoodDay<\/h2>\n\n\n\n
\"project<\/figure>\n\n\n\n

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<\/a>.<\/p>\n\n\n\n

With GoodDay, you can:<\/p>\n\n\n\n