Grouping on my Gantt Chart

[Jeepers321]

I thought this was going to be a simple task but it has escalated beyond the boundries of my mathmatical knowledge. Which isn't saying much.

I am trying to make a chart based on these items.

vehicle - (this is just an ID Number)
puDate - (this is the date the vehicle was received)
rDate - (this is the date the vehicle was returned)
duration - (this is the amount of time the vehicle was out)

I am getting this data from an access query so here is more data that I can retreive if it helps in any way.

cStart - (this is the date where I want the chart to start. ex. Value Y axis scale Min)
sEnd - (this is the date where I want the chart to end. ex. Value Y axis scale Max)

The reason I mentioned this is because some of the puDate's and rDate's will run off the chart.

Here is a somewhat replica of my table.

vehicle | puDate | rDate | duration
1 | 8/30/2004 8:00 AM | 9/07/2004 5:00 PM | 8.375
2 | 9/01/2004 8:00 AM | 9/03/2004 5:00 PM | 2.375
3 | 9/01/2004 8:00 AM | 9/02/2004 5:00 PM | 1.375
3 | 9/03/2004 8:00 AM | 9/04/2004 5:00 PM | 1

Lets just say that
cStart = 8/29/2004
sEnd = 9/04/2004

(I presently have it just pulling the current week so for easy purposes I am going to just use letters to represent the days of the week.)

Here is a somewhat replica of the chart I am getting.

|-----------------------------------|
| |
1 | {---------------------------|
| |
2 | {------------} |
| |
3 | {-------} |
| |
3 | {-------|
| |
|-----------------------------------|
S M T W T F s



Here is a somewhat replica of the chart I want.

|-----------------------------------|
| |
1 | {---------------------------|
| |
2 | {------------} |
| |
3 | {-------} {-------|
| |
|-----------------------------------|
S M T W T F s


Hope the charts make since.

Can anyone offer any suggestion, this is pretty much a typical gantt chart and I have found some pretty good examples on the web but so far I can't get any of them to group the vehicles data in my chart?

I have tried a pivot table as well but it couldn't group the vehicles in the chart either.

Please help!

TIA (Thanks In Advance)

Tony