creating a gantt chart automatically

[Sue W]

I have a table that gets imported to Excel that has
project numbers, begin and end dates. I want to be able
to create a gantt chart for this automatically on another
sheet when this data gets imported to the first. It would
also be nice to be able to have one sheet be by days,
another by weeks, and another by months. Can anyone tell
me if there is an existing wizard to do this. Maybe point
me in the right direction to find information on this?

Thanks,
Sue

 

[Jon Peltier]

Sue -

The best I can do is point you to a list of Gantt chart links I've amassed:

http://peltiertech.com/Excel/GanttLinks.html

- Jon

 

[Susan W]

Jon - I get an error on that - Invalid link. I went to
http://PeltierTech.com/Excel/ (which by the way is really
cool) and then clicked on the Gantt Charts from there and
got the same thing.
Sue

 

[Debra Dalgleish]

This link should work:

http://www.peltiertech.com/Excel/Charts/GanttLinks.html