Grouping in a chart (Gantt Chart)
 

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

Grouping in a chart (Gantt Chart)
 

(Tony) wrote in message . com...
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


Would ProjeX do this for you (www.waa-inc.com/projex)? It is an Excel
add-in to generate Gantt charts.

Regards,

Mike Witcombe