Conditional Gantt chart

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
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

santeria

Well-known Member
Joined
Oct 7, 2003
Messages
1,844
Is a Gant Chart going to be what you want for this ??

Seems like the Gant chart will deal with the items you want on a time Basis, so the items seem irrelavent.

Do you have a working Gant Chart at the moment?

In what way exactly is it failing?

Can you show an example using the Colo Html maker?

Ta

(y)
 

novicehacker

New Member
Joined
Mar 9, 2004
Messages
34
car example.htm
ABCDEFGHIJ
2ThedataIhaverightnowshowsas:
3
4STARTEND8:00AM9:00AM10:00AM11:00AM12:00PM1:00PM2:00PM
5CARA8:00AM9:00AM
6CARA10:00AM11:00AM
7CARB9:00AM12:00AM
8CARB1:00PM2:00PM
9CARA12:00AM1:00PM
10
11Iwouldliketheabovetoshowas:
128:00AM9:00AM10:00AM11:00AM12:00PM1:00PM2:00PM
13CarA
14CarB
15
16
Sheet1



the above shows what i'd like to do, basically i'd like to show all the instances in which one car was used on the same row instead of on different rows, this is just a sample, in my actual example i have about 40 cars, who i'm tracking every day over the past year.....
 

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638

ADVERTISEMENT

Hi,

1. I changed your data a little bit as I don´t think your upper and lower charts says the same thing.

2. The formulas you see in the cells are not supposed to be there. Its the ones you are supposed to use in contitional formatting.
Book1
ABCDEFGHIJ
1ThedataIhaverightnowshowsas:
2
3STARTEND08:0009:0010:0011:0012:0013:0014:00
4CARA08:0009:001100000
5CARA10:0011:000011000
6CARB09:0012:000111100
7CARA13:0014:000000011
8CARB12:0013:000000110
9
10Iwouldliketheabovetoshowas:
1108:0009:0010:0011:0012:0013:0014:00
12CarA1111011
13CarB0111210
14
Sheet1
 

novicehacker

New Member
Joined
Mar 9, 2004
Messages
34
thanks, i'm convinced there will be a fair degree of programming involved to do this, time i just don't have at the moment.
 

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
No No

Just one formula to put into conditional formatting for the new table. :biggrin:

=SUMPRODUCT(($A$4:$A$8=$C12)*(D$11 > =$B$4:$B$8)*($C$4:$C$8 > =D$11))
 

Watch MrExcel Video

Forum statistics

Threads
1,123,463
Messages
5,601,800
Members
414,477
Latest member
Ben2000

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top