Filling in cells based on a start and end date

[Flaviking]

Good afternoon,

This is my first post and I have to admit, I'm not very skilled at excel. So I am hoping someone can help me out.

I have been searching for the last month on a solution to my problem and all i seem to come across are Ghatt sheets.

I am trying to show in a visual manner, the start and end dates of a task over a period of time. For example, I have a start date of 7/1/2014 and an end date of 9/28/2014. I would like to create a visual representation of that by having dates across the top of a worksheet and then a colored bar stretching from 7/1/2014 to 9/28/2014.

I would need to do this for multiple entries and have them each show independently from one another

task a in row 2, task b in row 3.

The ghatt chart doesn't really work for me as there are know sub tasks, which that seems to depend on.

If anyone can help< i'd really appreciate it. Thanks!

 

[skywriter]

I think what you are referring to is a Gantt chart. What you describe sounds exactly like a Gannt chart and I think that is actually what you want. I don't think you need sub tasks for a Gantt chart you can have only one task represented on each line.

Search Google or whatever your preference is and you will find tutorials either written or video on how to make them and also probably fine some ready made templates.