Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Greeting,
I would like to build a chart for scheduling workers. What I would like is a chart with time across the top and workers down the left side. There are a number of jobs to be done each day. These jobs range from 1 to 20 hours, most are 2 to 4 hours. The time is broken down by 12 minute intervals. I need to assign each worker as many jobs as they can handle. I saw a chart that was set up with time across the and workers down the side and the jobs are blocked off in the time the job took, in the row of the worker. Each worker is blocking off from 1 to 4 jobs a day. Something like this: 8 9 10 11 12 1 2 3 4 5 Time |----|----|----|----|----|----|----|----|----| Worker A |----|< 3 |--< 8 |--< 9 -| Worker B |< 1 |--< 5 |----|----| Worker C |----|----|< 2 |----| Job 1 is 4 hours in the AM Job 2 is 6 hours starting at 10:00 AM Job 3 is 2 hours any time Job 4 Cancelled Job 5 is 2.5 hours any time Job 6 Cancelled Job 7 Cancelled Job 8 is 2.5 any time Job 9 is 2 hours in the afternoon My first question is: What is this kind of chart called? And my next question is: How do I create one? Anyone have any ideas? Any help would be appreciated/ TIA -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Timeline Chart? | Charts and Charting in Excel | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel |