Through this article, I wanted to share with you a Gantt chart I developed on Microsoft Excel. There are multiple reasons why I wanted to do so :
- Why should we pay a MS Pr**** licence and use only few functions of it
- Excel files are becoming standard in the industry and your window person will for sure not struggle opening an Excel file
- I like Excel ! It’s much more user-friendly than other software programs
- And maybe most motivating reason : I didn’t find a free Gantt chart I really liked on the web !
Just before I share with you link to the file, hereafter some customer expectations I considered :
- Free from Visual Basic macros : main reason is to make people downloading this file confident that there are no viruses or spyware.
- Easy to use / user-friendly : including the way you add & remove tasks or sub-tasks
- Accurate : the chart should reflect user intention/input
- Free download !
Download latest version:
To download the file, click on the link below (version 4.1) :
http://www.box.net/shared/jl0c6yy8qa
Tutorial file is available in the following link :
http://www.box.net/shared/uz2onz8iy9
Presentation Video (apologies for the accent ! ):
Screenshot:
Related articles you may like:
Diagramme de Gantt : 10 erreurs à éviter ( French)
Visual Board : Suivi des tâches avec des post-it ( French)
Poll:
History:
Version 4: http://www.box.net/shared/jl0c6yy8qa
Version 3: http://www.box.net/shared/tk38gpgioo -See screenshot
You like it ? Share it !
http://www.box.net/shared/jl0c6yy8qa
[...] [Download] Free Excel Gantt Chart [...]
Hi, I don`t get to change the working days for only 5 day…. It always stay with the 7 days week. What is wrong?
Hi Leonardo,
Which Excel version are you using ? Excel 2007, 2010, 2003?
Thanks
Hi, I`m using Excell for MAC 2011…. The options for working day doesn`t work.
Thank Leo for your feedback. I must apologies, I did not try this chart in Mac plateform during my error-proof trials.
At a first glance, I can say there is a difference on how Windows & Mac handle dates : Windows reference date is 1/1/1900 and Mac is 1/1/1904.
It is reported on the net that the formula “WORKDAYS” is impacted by this difference (see: http://groups.google.com/group/microsoft.public.mac.office.excel/browse_thread/thread/7f5b4222cc3a263c).
1) I would need to get hold of a mac to make some trials and fix the bug. If the bug is consistent, a simple tweak on the formula would solve it. Best case, I will find a formula that fits both Win & Mac. However, getting a mac may take me some time and therefore I can’t promise quick fix.
2) As a quick fix, may I suggest you to change the date system to the 1900 system (Go to Preferences/Calculation, uncheck the 1904 date system checkbox). Please let me know if it worked and if you have any side effects. In parallel I will work on item #1.
Apologies again for all fans of Mac
BR
If I uncheck this what is the possible problems in my mac?? Do you know ?
My first post!
Hi, I changed my 1900 system for mac and din`t get any difference. Do you have any other way to try?
Hello Leonardo,
I need to have a look at it with mac. As soon as I have a reply, I will post it.
Apologies did not check that major plateform during the error-proof.
BR
Sorry, but I downloaded the “latest version” from the link above, and it turned out to be in French, not English. I could work with that, but I am not so sure about my colleagues.
I think there is an option to choose English! I was able to choose, however, there are no bar graphs appearing on my Gantt chart and so am a bit disappointed, is it because I am using Excel 2010, please help!
Hi, just wondering if you have fixed the 5 day workday issue? I’ve tried unchecking the 1904 date system option but didn’t make any difference. Cheers, Miri.