I've a table with this format :
StartedTime | EndedTime | Speed
And I want to make a graph showing the speed over time. The thing is that I can have the same StartedTime and EndedTime for multiples rows (with different speed).
Do I need to compute by myself the values making a new table with a unique timestamp before making the graph or excel can do it for me ?
And what if I've got some row where StartedTime and EndedTime are crossing each other ? (example below :)
StartedTime | EndedTime | Speed 001 | 004 | 1 002 | 007 | 1
In this example the graph should show a speed of 1 between 1-2, 2 between 2-4 and 1 between 4-7. Is it possible ?