Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a list of scheduled tasks. In one column is the time the task
started. In the next column is the time the task ended. Many of these tasks overlap. (Two or more task are running at the same time, starting and ending at different times.) I want a chart that shows how the tasks overlap. I'm thinking of a chart that has a standard time line for both x and y axis. The for each time on the x axis where a task began there are two dots connected by a line. The lower dot is when the task started, the upper dot when it ended and the line represents the duration. Then I could scan my eyes across the chart and see where the tasks are overlapping. Anyway, this is just my idea of how it should look. I'd welcome any suggestions on how to represent this data. tod |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Give File Time to update Pivot Table when started bij Macro | Excel Discussion (Misc queries) |