Single line graph from hamster data

Hi I'd like to produce a single line graph from several rows of data eg.

25 24 34
12 37 89
93 56 43

but I always get three series or three lines.

If it were all in one row that would be ok but the data is being passed from a vb.net 2d array.

Any pointers would be great.

(the data set is much larger and represents timing info from a hamster wheel)

Thanks

I'm passing a 2d array to a range.

The reason that I'm using a 2d array rather than a 1d is that there are going to be a lot of values in the real application (about 100,000 to 300,000) so a single row or column will not be sufficient.

Please Login or Register  to view this content.

Yes I think so. Would that be a help in getting a large amount of values into excel.

I decided on a 2d array because if I use a 1d array and pass it to excel as a single row or column there would not be enough cells in a single row or column to hold all the data samples.

The data is, believe it or not, coming from a hamster wheel - well an opto sensor on an eight segment disc attached to the wheel.

So if hammy is doing 4 rev/sec

4X8X60=1920 timings per minute

=1920x60x12= 1,382,400 timings to be stored in a 12 hour period.

All this is not fixed in granite as it's a project under development.

I can see that I may have to do a more data processing in the vb.net prog before passing to excel to get my fancy graphs. Just wanted to get it in excel early as vb.net is something I am still weak on.