Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a Timeline
Hi all,
I need to create a timeline in excel with the following available data: Location Date / Time Equipment Equipment Activity Activity Duration I have created a 24hr timeline for every location in 5min intervals (using excel cells) showing what equipment was used in each location and the duration of every equipment activity. I have used colour formating and a custom made legend to represent each activity (See attached example, sorry for the poor picture quality, but the timetable for the different activities and the legend is visible). I want to create a timetable to show a weeks worth of data. The file will be 80Mb - 100Mb if I was to do a weeks worth of data for each location and will become unmanageable. Is there a way to use an XY-Scatter graph or any other graph to create these weekly timelines? Is there another function in Excel I can use? Any help would be appreciated. Cheers, Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
best timeline | Charts and Charting in Excel | |||
timeline | Excel Programming | |||
Creating automated timeline | Excel Worksheet Functions | |||
Creating an active timeline of data from cell input | Excel Worksheet Functions | |||
Creating formula for timeline | Excel Discussion (Misc queries) |