Hi,

Have a read of Jon Peltier's article on gantt charts
http://pubs.logicalexpressions.com/P...cle.asp?ID=343

Cheers
Andy

Ron wrote:
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


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info