T
Tony
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
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