I need to take the following information and make a timeline chart in excel Date Completed/scheduled Milestone 1 Date1 Milestone 2 Date2 Milestone 3 Date3 In addition to doing this timeline, I need to find out a way to automate this process so that if the information is load from another source into excel that it can be processed automatically into a timeline chart. I have many projects and need to find a way to track them with a simple timeline. Hope someone can help -Ron
Hi, Have a read of Jon Peltier's article on gantt charts http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343 Cheers Andy Ron wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info