line chart.

[Mad101daN]

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

[oldchippy]

Hi,

Does this link help?

http://peltiertech.com/Excel/Charts/StackedLine.html

[Mad101daN]

thx for he reply old chippy but that not quite what I am looking for.

I will attach a copy and I think that will make things alot easier.

Cheers

Dan

[oldchippy]

Hi,

May be this, it's in 2007, so you may need a viewer

http://support.microsoft.com/kb/925180

[Mad101daN]

Thx for helping here chippy.

Unfortunatey you encoutered the exact same problem I did, the graph ends up with many different series on it, when in fact it is just one series, which is 'time'.

The chart should have just one line, (all be it very long) as all the data is incrumental, its all just 5 second intervals.

The other way I thought we could get round the problem is turn have a way to turn it into one long column, but my lack of excel skills, are not helping me to do this, without a very long copy and paste.

This is just one heart rate reading, I am going to be comparing many different ones. so the copy and paste isnt really applicable.

If anyone has any ideas please let me know.

Thanks again.

Dan

[oldchippy]

Hi,

Try this one