novicehacker
New Member
- Joined
- Mar 9, 2004
- Messages
- 34
HI all
i'm trying to create a conditonal gantt chart (similar to this example: (http://www.mrexcel.com/tip058.shtml)). Referring to the example, there is no event that repeats more than once, in my case i'm creating the scheduled use of cars, therefore the events repeat, i.e a car is taken out say 8 for one hour and then again at 10, i can't figure out how to put this on a conditional Gantt chart. E.g following is a schedule
Time Out Time in
Car A 8:00 9:00
Car B 8:00 9:00
Car B 10:00 11:00
Car A 11:00 12:00
Car A 12:00 13:00
I would like to show the above info in a Gantt chart as:
8:00 9:00 10.00 11.00 12:00 13:00
CAR A USED USED
CAR B USED USED
basically my query is how can you create a conditional Gantt chart for repititive events, (in my case the usage of a specific Car). I'm guessing i'll have to write some kind of VBA code, not exactly my strongest forte!
Any answers would be appreciated and win you a drink if you happen to come down to Toronto.
thanks
i'm trying to create a conditonal gantt chart (similar to this example: (http://www.mrexcel.com/tip058.shtml)). Referring to the example, there is no event that repeats more than once, in my case i'm creating the scheduled use of cars, therefore the events repeat, i.e a car is taken out say 8 for one hour and then again at 10, i can't figure out how to put this on a conditional Gantt chart. E.g following is a schedule
Time Out Time in
Car A 8:00 9:00
Car B 8:00 9:00
Car B 10:00 11:00
Car A 11:00 12:00
Car A 12:00 13:00
I would like to show the above info in a Gantt chart as:
8:00 9:00 10.00 11.00 12:00 13:00
CAR A USED USED
CAR B USED USED
basically my query is how can you create a conditional Gantt chart for repititive events, (in my case the usage of a specific Car). I'm guessing i'll have to write some kind of VBA code, not exactly my strongest forte!
Any answers would be appreciated and win you a drink if you happen to come down to Toronto.
thanks