Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gantt Chart! | Charts and Charting in Excel | |||
Gantt Chart - Grouping? | Charts and Charting in Excel | |||
Gantt Chart | Charts and Charting in Excel | |||
Gantt Chart | Charts and Charting in Excel | |||
gantt chart | Excel Programming |