Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
deant
 
Posts: n/a
Default Time and motion chart


I am looking for help in creating a “time and motion” chart for up to 4
people and each person has 4 activities that they perform throughout
their day.

For argument sake, each person is required to perform the following
activities.

Stack boxes
Pack boxes
Unload truck
Load truck

I would like to put together a time and motion type of chart that shows
each persons activity by time of day. Each person performs all
activities throughout their day at different times. There maybe two
people unloading the truck while one person stacks boxes and the other
is loading the truck for example. Each person can start and stop any
of the activities at any time.

I was thinking that something similar to a stacked bar chart in that a
different colour represents a different activity and along the X axis
is a time scale that shows the time of the day. The time logged
against each activity is the time that activity started, so that total
time that that activity lasts is that time it started to the time the
next activity starts. The Y axis displays the people’s names.

I would appreciate if someone could point me in the right direction.


--
deant
------------------------------------------------------------------------
deant's Profile: http://www.excelforum.com/member.php...o&userid=27427
View this thread: http://www.excelforum.com/showthread...hreadid=469435

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
watch a curve change over time like a movie RandyBarrett Charts and Charting in Excel 6 February 19th 05 06:00 AM
xy scatter graph with a scrolling time element Brad Charts and Charting in Excel 2 January 7th 05 02:53 PM


All times are GMT +1. The time now is 10:34 PM.

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"