Scatterplot with multiple x and y values.

[solan]

Hi,

I have a question regarding a way to organize many scatter plots 'easily'. I am working on improving it to handle different time series and have not found a simple way for it to auto-update yet.

let's say I would like to compare 500 time series that look something like this:


[TABLE="width: 336"]
<COLGROUP><COL style="WIDTH: 48pt" span=7 width=64><TBODY>[TR]
[TD="class: xl68, width: 64, bgcolor: transparent"]Identifier[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Time A[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Value A[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Time B[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Value B[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Time C[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] Value C[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0,17[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]22[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0,13[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]32[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0,09[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]12[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0,15[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]23[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0,12[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]30[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0,1[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]13[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0,11[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]26[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0,08[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]39[/TD]
[TD="class: xl67, bgcolor: transparent, align: right"]0,05[/TD]
[/TR]
</TBODY>[/TABLE]


Also they could be anything from 5 pairs to 100 pairs long.

I have tried organizing the data in two sheets, but I'd like to not have to plot each individual series.
Any suggestions?