XY Line chart with an undetermined number of series

[sorka]

Been knocking my head against the wall trying to figure out how to chart this.

I have a csv file with the following columns:

1) Time in seconds (x-axis)
2) A numberic id(each unique id represents a series).
3) Memory used (the data).

I want to chart memory used over time for *each* process id. There are multiple entries for each id.

So the data looks something like this starting from say time 0.


0, 30, 50
0, 31, 60
0, 32, 60
1, 33, 80
1, 34, 90
1, 35, 10
2, 30, 51
2, 31, 61
3, 32, 59
3, 33, 78
3, 34, 91
4, 35, 11

This is a very simple example and this would just repeat. I have files with hundreds of thousands of lines with entries like this.

So in this example, there are 5 series named 31, 32, 33, 34, 35. I'd like a line chart for each series. Since series can come and go over time, a line chart with x being the entire range of time would show some lines starting and some stopping part way in the chart.

The time (first column) is the x-axis. The 3rd column represents the data (y-axis).

Would really appreciate help figuring this out. I'm totally stumped.

Thanks.