Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Charting Run Times
Ok, here's the deal. I have a data table on sheet 1. It is organized like
this: Column A: Start Time "A" Column B: End Time "A" Column C: Start Time "B" Column D: End Time "B" Row 1: 8/30/2005 8:30:00 PM Row 2: 8/30/2005 9:07:00 PM Row 3: 8/31/2005 1:21:00 AM Row 4: 8/31/2005 3:31:00 AM What I am trying to do is chart this data as a stacked bar going from left to right so that the first section of the bar (furthest to the left) represents the time between column "A" and column "B", and the second/right section of the stacked bar represents the time between column "C" and column "D". What I have done so far is create additional columns that calculate the duration of each start and end time. Then I have a floating bar chart that charts the first start time and then charts the durations there after. The problem that I am encountering is that since my data is in mm/dd/yyyy hh:mm AM format (or at least that is how it is input into the data table), my floating bar chart can't pick them up becuase (I think) it is expecting that my dates and times are starting at 1/0/1900 12:00 AM instead of true/real times. Does anyone know how I can create a chart to do what I want. If I have left out details that you think are important, please let me know. -- Thanks a million, Nick Junod |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to calulate a sum for once a month X #days X #times used per. | Excel Worksheet Functions | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Dynamic charting problems (events) | Charts and Charting in Excel | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions |