Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gantt Chart! Scott_goddard Charts and Charting in Excel 1 April 9th 10 01:54 PM
Gantt Chart - Grouping? ant1983 Charts and Charting in Excel 1 August 1st 08 11:36 PM
Gantt Chart adel Charts and Charting in Excel 1 November 18th 06 02:38 PM
Gantt Chart centerNegative Charts and Charting in Excel 8 September 15th 05 05:05 AM
gantt chart vipin Excel Programming 3 July 26th 03 03:51 PM


All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"