First of all, make sure « Show Budget » option is ticked: In front of each task or sub-task, you will see budget cells. Simply fill your estimated or planned budget then, whenever you have new information, fill-in the actual consumed budget. Other cells will adjust automatically. You can change the currency using the usual Excel Formatting. Important notice : When you …
FAQ Category: technical
How to Show/Hide the Column for « Comments » ?
Simply tick or untick « Show Comments »: Or from the ribbon menu: Doing so will unhide/hide the column where you can input free comments for each task: Did you find a solution to your question ? Link to the contact form Back to the top of the page
How to Automatically Share the Latest Schedule by Email ?
This Excel Gantt Chart Maker has a nice feature that allows you to share your Excel file by email. Click on « Tools » then « Share by email ». A message will prompt asking you if you would like to pre-fill the recipients field automatically from the members list or not. This is meant to avoid you sending the schedule to all the …
How to add a new gantt chart in the same file ?
It is possible to have multiple Gantt Charts in the same file. To add a new Gantt Chart, click on icon « New Gantt Chart » from the ribbon menu. It is also possible to use the usual copy-paste function of an existing sheet. Did you find a solution to your question ? Link to the contact form Back to the top of …
How to Reach the support page from the Gantt Chart Maker ?
From the ribbon menu, click on the icon « About » and then « Help ». You will be transferred to the support page which contains a FAQ that is regularly updated. You may also use the right click menu: Did you find a solution to your question ? Link to the contact form Back to the top of the page
Is it possible to input task durations in weeks or months ?
It is possible to input task durations in days, weeks or months. Ideally it is better to input these durations in days but if your planning does not allow such precision level you can input them in weeks or in months. Next to any duration there is a letter “d” which means “days”. If you double click on it you …
What is the purpose of a “Milestone”
Milestones are tools used in project management to mark specific points along a project timeline. These points may signal anchors such as a project start and end date, a need for external review or input and budget checks, among others. In many instances, milestones do not impact project duration. Instead, they focus on major progress points that must be reached …
How to copy/paste tasks between different gantt charts ?
When you copy/paste tasks from different gantt charts, you will get a warning message similar to the one below: Just click on the button “Yes”: it will not have any impact on your file. Did you find a solution to your question ? Link to the contact form Back to the top of the page
I can’t see the ribbon menu (Excel 2007 & Mac 2008)
Due to technical reasons, the ribbon menu is not available on Excel 2007 (PC) and 2008 (MAC). Ideally, if you could upgrade to at least Excel 2010, you will benefit from a much better user experience. However if you can’t migrate from Excel 2007 or 2008 (e.g: company policy) you may still use the Gantt Chart Maker through the right …