I'm with Ron - much easier with dedicated specific software. MSProject is expensive to buy and not simple to learn, but it is "standard". There are plenty of alternatives, both cheaper and more extravagent.

There are also available on the 'net many attempts to do the job in excel, not many of them elegant.

Good luck!!