"Thank you for this brilliant tutorial. I created a Gantt chart in ten minutes and my boss was impressed. The other videos on this subject want you to add formulas and conditional formatting, the whole process takes a day and you end up with a broken Gantt chart. I love this automated template. Gonna ask my team to get the Pro version for our PM needs."
Hi John, Thank you very much for your video. I tried this template and I am deciding to upgrade to PRO version but I have a quesion how many users can use this Excel file. Do I have to buy the license per user?
Dear sir. This interface is really awesome....im planning to buy this pro..... could we have additional tracking information for the delays....im facing delays from planning team....by not getting material delivery sometime....by this where our targets get's buffered...
I bought the ExcelPro, and very useful for me. i'm a production engineer and reviewing this, and planning to recommend to my Manager. I have some request: 1. (I bought the "Day" version), but how can I edit the to have this increment of half day (.50), quarter (.25) . 2. There is an option of adding "column", how can I move the column in the worksheet, e.g. - adding description column to a task.
Thank you buying the Pro version. We currently can set the duration as a whole number. The developers are working on a version that will allow fraction of days/ hours. You can unhide the notes column in the Settings window under the columns tab. You can also move columns around as well or insert new custom columns.
@@GanttExcel , thanks for updates. to the uprev version, how can we uprev our current version? Are we getting patches or a notification to updates to new version?
Hi John, Thanks for your informative video. I have the pro license and I've been trying to remove some tasks by removing the raws, but it keeps showing the below message: "Please do not insert/delete cells, rows and columns. You can insert tasks by clicking.. etc." please let me know how i can remove some or the whole tasks on one time. Thanks
Hi John, Thanks for your informative video. I have been trying out the hourly view template and it works very well. I realize I'll need to invest in the Pro version BUT I noticed that the GANTT chart get really very long if all 24 hours are in the chart. Is it possible to NOT display NON WORKING hours so the GANTT chart will be more than 75% shorter. If there is anyone else out there that can assist, please do not hesitate to provide some pointers. Thank you
Frits, You are most welcome. You can click on the daily view if you have the project running over several days. We have a new feature to hide weekend and holiday columns as well in Hourly and Daily view. We will also work on hiding Non Working hours as well.
Hi, your tool is really awsome. I'll ask my boss to allow me for the Pro version soon. I have 2 questions: 1) In the free version, if I make a mistake and want to Undo it, the Undo option is not active in the template. It also does not work with CNTRL + Z. What can I do? 2) Some of my task names are too long and are hidden by the next cell (indicating the Priority). It does not work if I simply try to make the make the cell bigger by pulling it on the right side. How can I view the full task name?
Thank you Junaid. You can try increasing the task column width and then try wrapping the text. The excel Undo button unfortunately go one step back at a time whereas the automation would have done a thousand changes in a few milliseconds and hence can't be used.
Thanks for your tutorial, and I would like to clarify if there is any possibility to change the weekend days or to adjust ot to a single off day only. ?
Yes you can change the work days for the Organization or for a single resource. Please click on the Resource button in the Gantt menu to set workdays and holidays. th-cam.com/video/lfcySPYoWgM/w-d-xo.html&t
i've been looking for this for a long time. thank you so much for this efforts. may I know what are differences between between free and registered version?
Hello, You are most welcome. The differences between the free and Pro version are listed at the link below. www.ganttexcel.com/gantt-chart-template-download/
Dear sir....in this gantt... could we have additional information...planned start, end and Actual start, end... Where the Gant bar to be formated to show the task like...completed, pending, ongoing,delayed, extended, early completion..... Pls check these features can we able to incorporate into this Gantt excell....
We have this feature where you can track baseline and actual dates. We also have a status field to track completed, in-progress, planned etc. And the next version will allow you to add custom status using your own formulas.
Hi I have used a paid version of the product for sometime now version 2.49.8, Wondering if it's worth updating to Pro2021 version??? are there significant changes in the new version?
Okay, I have purchased Pro. If I want to set tasks, like framing, to a standard "task" with it's own color say brown, then another standard task, like electrical, to yellow...etc. etc., how do I do that so I use the same common tasks against multiple projects? Then how can I sort all of the tasks from all projects in a single Gantt? In other words, I want to see the framing needs from 10 different projects so I can see where, given current staffing, there is a conflict of resource. That would mean I would have to change timelines or add staff to keep all projects framing needs as is....
David, you can double click a task to set the task color for that particular task. We are planning to integrate resource capacity planner into Gantt Excel later this year.
Hello, The tool is very good and helpful. I would like to ask you to make actual start date and actual finish. When you put times in actual start date and actual finish date to visualize how long in really taks. A lot of time it happens that when you start some task actual time to finish is longer that what you plan.
In the free version the timeline does not adjust automatically, I can only see till Aug month...pls let me know how to do that. as I want to plan project till end of the year..
Rachit, please click on 'Setup Timeline' button to select the start date and end date of the timeline and the timeline will automatically update. You can view this video to setup the timeline - th-cam.com/video/grKoPsLcV1Y/w-d-xo.html
Hello, I tried to ask you a question through your website but there is no reach point before being a customer. I hope I can get to someone. I would like to use your product as a production schedule tool. If I can manage to set dependencies automatically I believe it will work without any modification. Is there a way that I can set the dependency of a task to the task one row above it. So every new task (Product that needs to be produce) will be dependent finish to start the one above. But if I move the task one row below dependency should be changed automatically. Is there a way to do that?
@Namik Nam - All our versions support task dependencies. You can watch this video for task dependencies in Gantt Excel th-cam.com/video/lXiT3jfsVag/w-d-xo.html | You can also reach out to our support team @ www.ganttexcel.com/
Sure, The dates automatically should show up in German if you have set the language in regional settings to German. You can also reach out to our support team on our website for additional help.
Please check out our Quick start guide at the link below and if you face any issues please visit our website to raise a support ticket. www.ganttexcel.com/how-to-create-a-gantt-chart-in-excel/
Hi! I am trying to add a long sentence in the "Task name" section but it doesn't show. Does anyone knows how to make the task name bar longer? How to expand it? I want the whole sentence to show
Hi, You can purchase the Pro version at www.ganttexcel.com/gantt-excel-pro/ . Also please contact us at support @ ganttexcel dot com for further assistance.
![เปิดใจ "อาจารย์เบียร์ คนตื่นธรรม" อดีตเคยสุดทุกทาง ถ้าใช้หนี้หมดไปบวชแน่ l [Nickynachat]](http://i.ytimg.com/vi/IxeE0xVhy08/mqdefault.jpg)
"Thank you for this brilliant tutorial. I created a Gantt chart in ten minutes and my boss was impressed. The other videos on this subject want you to add formulas and conditional formatting, the whole process takes a day and you end up with a broken Gantt chart. I love this automated template. Gonna ask my team to get the Pro version for our PM needs."
Glad it helped! Thank you for your kind words.
finally find the best one excel ganttchart... thanks a lot
Your are most welcome. Glad you love it!
Hi John, Thank you very much for your video.
I tried this template and I am deciding to upgrade to PRO version but I have a quesion how many users can use this Excel file. Do I have to buy the license per user?
Please reach out to our support team on our website for Pro licensing.
It's just wondrefull, Thank you for this video!
Glad you enjoyed it!
Thank you so much ,this was very helpful
You are most welcome!
Thank-you so much, this is gonna be really really helpful
Dear sir. This interface is really awesome....im planning to buy this pro..... could we have additional tracking information for the delays....im facing delays from planning team....by not getting material delivery sometime....by this where our targets get's buffered...
Thanks you. Yes, you can track delays by turning on the 'Show overdue tasks' in the Settings form.
can we purchase this software in india
Terima kasih atas tutorialnya, salam dari Indonesia
You are most welcome. We are glad you found it helpful.
This is excellent, thank you very much!
You are most welcome :)
I bought the ExcelPro, and very useful for me. i'm a production engineer and reviewing this, and planning to recommend to my Manager.
I have some request:
1. (I bought the "Day" version), but how can I edit the to have this increment of half day (.50), quarter (.25) .
2. There is an option of adding "column", how can I move the column in the worksheet, e.g. - adding description column to a task.
Thank you buying the Pro version. We currently can set the duration as a whole number. The developers are working on a version that will allow fraction of days/ hours.
You can unhide the notes column in the Settings window under the columns tab. You can also move columns around as well or insert new custom columns.
@@GanttExcel , thanks for updates. to the uprev version, how can we uprev our current version? Are we getting patches or a notification to updates to new version?
Please raise a ticket at ganttexcel.com and we will help you out.
Great tutorial. Thank you
You are welcome!
Hi John, Thanks for your informative video.
I have the pro license and I've been trying to remove some tasks by removing the raws, but it keeps showing the below message:
"Please do not insert/delete cells, rows and columns. You can insert tasks by clicking.. etc."
please let me know how i can remove some or the whole tasks on one time.
Thanks
Dear Yousef, You can select the task and then click the 'Delete task' button in the Gantt menu.
Hi John, Thanks for your informative video.
I have been trying out the hourly view template and it works very well.
I realize I'll need to invest in the Pro version BUT I noticed that the GANTT chart get really very long if all 24 hours are in the chart.
Is it possible to NOT display NON WORKING hours so the GANTT chart will be more than 75% shorter.
If there is anyone else out there that can assist, please do not hesitate to provide some pointers.
Thank you
Frits, You are most welcome. You can click on the daily view if you have the project running over several days. We have a new feature to hide weekend and holiday columns as well in Hourly and Daily view. We will also work on hiding Non Working hours as well.
Frits, thank you for your feedback. Happy to inform you that we have added a new feature to hide non-working hours in the Hourly view.
Wonderfull!. Thanks!
Thank you for such a concise tutorial. Is there a way to import tasks or copy and paste several tasks?
Hi, your tool is really awsome. I'll ask my boss to allow me for the Pro version soon.
I have 2 questions:
1) In the free version, if I make a mistake and want to Undo it, the Undo option is not active in the template. It also does not work with CNTRL + Z.
What can I do?
2) Some of my task names are too long and are hidden by the next cell (indicating the Priority). It does not work if I simply try to make the make the cell bigger by pulling it on the right side. How can I view the full task name?
Thank you Junaid. You can try increasing the task column width and then try wrapping the text.
The excel Undo button unfortunately go one step back at a time whereas the automation would have done a thousand changes in a few milliseconds and hence can't be used.
Thanks for your tutorial, and I would like to clarify if there is any possibility to change the weekend days or to adjust ot to a single off day only. ?
Yes you can change the work days for the Organization or for a single resource. Please click on the Resource button in the Gantt menu to set workdays and holidays. th-cam.com/video/lfcySPYoWgM/w-d-xo.html&t
Thanks for the tutorial, it is super helpful! :). How can I get the pro version?
You are most welcome. We are glad you found it helpful. You can download the pro version at the link below.
www.ganttexcel.com/gantt-excel-pro/
Great Video !!
Thank you. We are glad you found it helpful.
i've been looking for this for a long time. thank you so much for this efforts. may I know what are differences between between free and registered version?
Hello, You are most welcome. The differences between the free and Pro version are listed at the link below.
www.ganttexcel.com/gantt-chart-template-download/
Amazing video
Thanks!
very practical tool and easy to use
@Muhammad Ali - Thank you for your kind feedback
So Nice.
Thank you! Cheers!
Dear sir....in this gantt... could we have additional information...planned start, end and Actual start, end...
Where the Gant bar to be formated to show the task like...completed, pending, ongoing,delayed, extended, early completion.....
Pls check these features can we able to incorporate into this Gantt excell....
We have this feature where you can track baseline and actual dates. We also have a status field to track completed, in-progress, planned etc. And the next version will allow you to add custom status using your own formulas.
Thank you!!
is there a possibility to add the S-curve for this?
Thank you for your feedback, we will try to add this to our next major release.
wonderfull
Thank you! Cheers!
In order to show dependencies of task do you always have to create a child- parent task?
Not really, you can setup task dependencies between normal tasks as well.
www.ganttexcel.com/gantt-chart-template-task-dependencies/
Amazing!
Thank you! Cheers!
Thank you so much dear just one question
how can I add Gantt Menu in Menus bar?
The Gantt Menu will automatically show up in all Gantt Excel files when you open the file and enable macros.
Hello can I download a Gantt excel file separately
Sure Precious, You can download it at this link - www.ganttexcel.com/
Hi I have used a paid version of the product for sometime now version 2.49.8, Wondering if it's worth updating to Pro2021 version??? are there significant changes in the new version?
Dear Tony - Our support team will get in touch with you at the email address used while purchasing the Pro version.
Okay, I have purchased Pro. If I want to set tasks, like framing, to a standard "task" with it's own color say brown, then another standard task, like electrical, to yellow...etc. etc., how do I do that so I use the same common tasks against multiple projects? Then how can I sort all of the tasks from all projects in a single Gantt? In other words, I want to see the framing needs from 10 different projects so I can see where, given current staffing, there is a conflict of resource. That would mean I would have to change timelines or add staff to keep all projects framing needs as is....
David, you can double click a task to set the task color for that particular task. We are planning to integrate resource capacity planner into Gantt Excel later this year.
Hello. If my project runs non stop 24 hours 365 days a year, how can I apply that into my calendar?
You can extend the timeline by clicking the Setup Gantt Timeline button in the Gantt menu
Hello,
The tool is very good and helpful.
I would like to ask you to make actual start date and actual finish.
When you put times in actual start date and actual finish date to visualize how long in really taks.
A lot of time it happens that when you start some task actual time to finish is longer that what you plan.
@Kiril - You can unhide the actual date columns in the Settings window> Columns. You can also turn on "Show Actuals bar" in the Settings window.
How to have this Gantt Excel Template
Here is the download link - www.ganttexcel.com/gantt-chart-template-download/
I don't have gantt chart button... is this kind of extra future?
Mago Faes, enable content (macros) when you open the file. The Gantt Chart Excel Menu will load and you should be good to go.
@@GanttExcel Thank you!
In the free version the timeline does not adjust automatically, I can only see till Aug month...pls let me know how to do that. as I want to plan project till end of the year..
Rachit, please click on 'Setup Timeline' button to select the start date and end date of the timeline and the timeline will automatically update. You can view this video to setup the timeline - th-cam.com/video/grKoPsLcV1Y/w-d-xo.html
Hello, I tried to ask you a question through your website but there is no reach point before being a customer. I hope I can get to someone. I would like to use your product as a production schedule tool. If I can manage to set dependencies automatically I believe it will work without any modification. Is there a way that I can set the dependency of a task to the task one row above it. So every new task (Product that needs to be produce) will be dependent finish to start the one above. But if I move the task one row below dependency should be changed automatically. Is there a way to do that?
@Namik Nam - All our versions support task dependencies. You can watch this video for task dependencies in Gantt Excel th-cam.com/video/lXiT3jfsVag/w-d-xo.html | You can also reach out to our support team @ www.ganttexcel.com/
Jhon i can't find Gant chart menu in Excel (2007) how can i find it?
Gultiaz please reach out to our support team at support.ganttexcel.com/
Nice product! Do you have any plans to show the critical path in future releases?
Thank you. We will be adding Critical Path in 2021
@@GanttExcel Hello, has this been updated/added?
Is it posdible to change the date formats to german?
Sure, The dates automatically should show up in German if you have set the language in regional settings to German. You can also reach out to our support team on our website for additional help.
@@GanttExcel thanks! I just shiwed this to my biss and he was interested. I might buy a copy to test it for our mid sized construction company
Hi I downloaded the free version.And I could not enter the Project Sheet name and the duration in the project details.Please advice.
Please check out our Quick start guide at the link below and if you face any issues please visit our website to raise a support ticket. www.ganttexcel.com/how-to-create-a-gantt-chart-in-excel/
Hi! I am trying to add a long sentence in the "Task name" section but it doesn't show. Does anyone knows how to make the task name bar longer? How to expand it? I want the whole sentence to show
Marta you can increase the task column width and click on Wrap text or turn it off based on your preferences.
Is there a way to hide non work days such as Saturdays and/or Sundays?
We will be adding this feature in a few months.
How can I change the currency from the dollar to the Saudi riyal?
Please click on the Settings button in the Gantt Menu and change the currency under the 'General' tab.
How to get report in parent task complete percentage in report sheets
You can click the Export to XLSX button and filter by parent tasks or modify the project dashboard with new charts.
what is the process to purchase the pro version. How does new features affect the old one purchased.
Hi, You can purchase the Pro version at www.ganttexcel.com/gantt-excel-pro/ . Also please contact us at support @ ganttexcel dot com for further assistance.
how to add gantt menu i have no gantt menu in my excel sheet
Muqadas, The Gantt Menu will automatically show up in all Gantt Excel files when you open the file and enable macros.
How to get this GANTT button?
You can watch this tutorial - th-cam.com/video/97Imycm8QzU/w-d-xo.html
How to report problem at Gantt Excel
Please raise a ticket at GanttExcel.com
i don’t have a gantr chart tap in my excel
Please click on the Enable Macros button when you open the file - th-cam.com/video/apQgBSgeQ6c/w-d-xo.html
Do you have tutorials in French?
Dear Donald, we will be creating video tutorials in French and Spanish later this year.