Any chart our there that can handle non-time-aligned but related data?

[ThomasJak]

By "non-time-aligned" I mean...

I am getting data for say 2 columns of similar categories but there may not be data for both categories for the same time. Very hard to explain.

Time	John	Fred
10 am	3	5
10:09 am		9
11 am	6	2
11:23 am	7
1 pm		5
1:56 pm	2

<tbody>
</tbody>

So the chart has to be clever enough that at say 10:09 am John is still 3 because there is no new info about him.
T 11:23 am Fred is still 2.

Thanks in advance.

 

[pgc01]

Hi

Use an auxiliary table where you fill the gaps.