Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 108
Default Chart type for machine timing diagram?

Does Excel have a good chart type to use for a machine timing diagram? A
timing diagram is typically made up of multiple data series, each plotted in
separate plot areas. The plot areas are stacked vertically to layout the
timing of each function within the machine. I would like to select the
entire data range chart the data. I suppose I could chart each data series
(each machine function) separately but I do not know how to perfectly align
the X axis gridlines of multiple charts.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 9,101
Default Chart type for machine timing diagram?

One method is to create packets of time to compare events instead of
carefully aligning the charts. this is similar to the old telphone trunk
line problem. A company wnat ot figure out how may trunk line they need
based on phone usagge. Phone calls start and end at various different times
and different lengths. to solve this problem you create a time line of 5
minutes time periods (or what ever is apllicable to the problem)

Call 1 - 12:01 AM 10 minutes
Call 2 - 12:02 am 15 minutes
Call 3 - 12:07 am 20 minutes

5 minute time line
Time Number of calls
12:00 - 12:05 2
12:05 - 12:10 3
12:10 - 12:15 3
12:15 - 12:20 2


You don't need to allign the start time of the calls. All you really care
about is the range of time. the time period doesn't havve to be fixed,
instead it can be a delta time.

Suppose you had two projects at work and one started in January and the
other started in April. You want to to compare the two jobs. You can
compare the by the number of weeks from the start date. Compare tthe 1st
week of job A against the first week of job B. Then compare the 2nd week of
both jobs, and the 3rd week of each job.



"Russ" wrote:

Does Excel have a good chart type to use for a machine timing diagram? A
timing diagram is typically made up of multiple data series, each plotted in
separate plot areas. The plot areas are stacked vertically to layout the
timing of each function within the machine. I would like to select the
entire data range chart the data. I suppose I could chart each data series
(each machine function) separately but I do not know how to perfectly align
the X axis gridlines of multiple charts.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,180
Default Chart type for machine timing diagram?

Excel 2007
Single chart with multiple data series
for multiple processes with multiple start/stop times.
Uses PivotTable and Tables.
http://www.mediafire.com/file/lgmmrw...11_15_09a.xlsm
  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,180
Default Chart type for machine timing diagram?

Excel 2007
Multiple processes Gantt chart.
Added labels, count of concurrent processes.
http://www.mediafire.com/file/i5lern...11_15_09b.xlsm
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
Bubble Chart - Venn Diagram Bill Hall Charts and Charting in Excel 4 September 26th 06 06:01 PM
Counting&Sorting multiple serial numbers per machine type Dark_Templar Excel Discussion (Misc queries) 5 June 17th 06 09:06 AM
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. [email protected] Excel Discussion (Misc queries) 6 February 28th 06 06:15 AM
Timing Chart sveasie Charts and Charting in Excel 1 February 18th 05 03:01 AM
Adding a line Chart Type to a stacked-clustered Chart Type Debbie Charts and Charting in Excel 2 January 6th 05 12:25 AM


All times are GMT +1. The time now is 11:17 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"