Log in  \/ 
x
or
x
x
Register  \/ 
x

or

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 ExcelGantt 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 > Gantt Chart, see screenshot:

2. In the Gantt Char 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 > 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.


Create a gantt chart with several click in Excel

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.