Need to find out if this possible in Excel

[Ron]

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]

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