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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]John[/TD]
[TD]Fred[/TD]
[/TR]
[TR]
[TD]10 am[/TD]
[TD]3[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]10:09 am[/TD]
[TD][/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]11 am[/TD]
[TD]6[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]11:23 am[/TD]
[TD]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1 pm[/TD]
[TD][/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]1:56 pm[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.