Gantt chart excel help

[williamkeith]

Hello Everyone,

I have a question and that I don't know if excel 2003 can do. I have a need to make a Gantt chart. The problem is I can make it, it's just I only have 5 tasks. Say they are numbered 1-5. Well these tasks are repeated but not at the same time but at different time frames. The problem comes in when I get back to task 1 I want it to go up on the line that task 1 is originally at. Instead excel wants to cascade them. Thats not what I want it to do. I dont want it to be 100 lines down. I want it to be 5 lines down (tasks) and 100 wide (time frame/duration). Is this possible with excel, and how if so? I do have a picture of what I would like it to look like.

Thanks

 

[sous2817]

Hello,

Here is a laundry list of Gantt chart links that should help you on your task:

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

 

[shemayisroel]

You can also try

http://www.mrexcel.com/articles/gantt-chart-with-conditional-formatting.php

Also, the below thread is a little long winded to try and get the answer but eventually the correct answer is given, it's worth a read.

http://www.mrexcel.com/forum/showthread.php?t=359334