Create a Gantt chart with several clicks in Excel

A Gantt chart is a horizontal bar chart which can help you to track the projects in project management applications, with this type of chart, you can see the priorities of the tasks and the estimated completion of the project at a glance. But, create a Gantt chart may need a complex of steps in Excel, this article, I will introduce an easy tool-Kutools for Excel’ Gantt Chart, with this feature, you can quickly create a Gantt chart with only several clicks.

Create a Gantt chart based on start date and end date in Excel

Create a Gantt chart based on start date and duration in Excel

Create a Gantt chart based on start date and end date in Excel

If you have a task list with start date and end date as below screenshot shown, to create a Gantt chart, please do with the following steps:

1. Click Kutools > Charts > Point in Time > Gantt Chart, see screenshot:

2. In the Gantt Chart dialog box, please do the following operations:

• Select the range of cells that contains the task names from the Task Name box;
• And then, choose the list of start date cells under the Start Date/Time box;
• At last, select End Date/Time option, and select the end date cells from the data table.

3. Then, Click Ok button, a prompt box will pop out to remind you a hidden sheet will be created as well, see screenshot:

4. Click Yes button, a Gantt chart will be created immediately based on the start and end date, see screenshot:

Create a Gantt chart based on start date and duration in Excel

Sometimes, you have a range of data which include the start date and duration, you can also apply this feature.

1. Click Kutools > Charts > Point in Time > Gantt Chart to apply this feature, and in the Gantt Chart dialog box, do the following operations:

• Select the range of cells that contains the task names from the Task Name box;
• And then, choose the list of start date cells under the Start Date/Time box;
• At last, select Duration option, and select the duration cells from the data table.

2. Then, click Ok button, a prompt box will pop out to remind you a hidden sheet will be created as well, see screenshot:

3. Click Yes button, a Gantt chart will be created at once based on the start date and duration, see screenshot:

Note: In the first time you apply the Gantt Chart feature, you can click the Example button in Gantt Chart dialog box to open a new workbook with the sample data and sample Gantt Chart to know how it works.

Demo: Create a gantt chart with several click in Excel

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...

---

Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages

✅ Trusted by 500,000+ users and 80,000+ businesses worldwide

🚀 Compatible with all modern Excel versions

🎁 30-day full-featured trial — no registration, no limitations

Try It Now!See PricingUnlock Full Features