Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I need to create a chart to represent the time an event is scheduled to occur
vs when it actually occurred. sched date/time act date/time diff comment 2/5/08 1:30 AM 2/5/08 1:45 AM 15 late start 2/6/08 1:30 AM 2/6/08 12:00 AM -90 early start 2/7/08 1:30 AM 2/6/08 11:45 PM -105 early start 2/8/08 1:30 AM 2/7/08 11:55 PM -95 early start 2/9/08 1:30 AM 2/9/08 2:00 AM 30 late start The chart should have a static line for series 1 (scheduled) at 1:30 am The line for series 2 should move above and below 1:30, depending on if the event started late (rows 1,5) or early (rows 2-4). The best I have been able to accomplish is a chart w/x axis as dates and y axis as the difference in minutes between scheduled start and actual start. The series 1 line is 0's, series 2 is a positive # (if late start) or negative # (if early start) But that's not what I need. I would like to y axis to display times so that a quick look will show, for example, the event occurred at 12:00 on day 2, not that it occurred at -90 (minutes). Any guidance will be appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
time and date charting | Charts and Charting in Excel | |||
Time-Series Charting | Charts and Charting in Excel | |||
Real Time Charting | Charts and Charting in Excel | |||
Charting Time | Charts and Charting in Excel | |||
Charting time? help please... | Charts and Charting in Excel |