Hi

I have some data from a heart rate monitor, which is my heart rate every 5 seconds. I want to graph this with a line chart.

I am struggling because the data is not in a single column or row but in a grid. So each heart rate is very five seconds and the each new minute is in the next row.


e.g.

65 70 85 80 87 80 87 68 89 88 87 56 54
55 68 89 88 87 56 54 80 87 80 87 68 89

So I just want to plot all this in a line chart so I can see how it looks, the actual data is for 90 mins so there is alot of figures.

Thx in advance.

Dan