line chart.

**Mad101daN** · 02-05-2008, 11:22 AM

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** · 02-05-2008, 12:37 PM

Hi,

Does this link help?

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

**Mad101daN** · 02-05-2008, 06:08 PM

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** · 02-05-2008, 06:22 PM

Hi,

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

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

**Mad101daN** · 02-06-2008, 05:00 AM

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** · 02-06-2008, 06:41 PM

Hi,

Try this one

**Mad101daN** · 02-07-2008, 05:30 AM

Thats great, can I ask what command you used to copy them all into the one line ?

Thank you very much for your help.

One last point is the time increases by 5 seconds each reading. I would like it to be displayed as minutes and seconds, rather than going to 100 seconds if you see what I mean.

Thanks again for your help, I see your in Worcester Im in Tewkesbury at the moment

Cheers

Dan

**Mad101daN** · 02-07-2008, 07:37 AM

Just to prove Im not totally thick, I have worked out how to do the time, in the proper increments.

Still would like to know a method of copy all the data in a row.

Cheers

Dan

**oldchippy** · 02-07-2008, 08:05 AM

Hi Dan,

All I did was to put a formula in N2 and drag it to the right, until a zero came up then I changed the formula to pick the next line up and repeated that across row 2 until I'd picked them all up. Ok it took a few minutes (someone could come up with a vba routine for this) but now the formulas are in place if you need to do the test again then just replace the data in B2:M108 and the graph should still work for you.

I see you have sorted out the time in hh:mm:ss

Has the water gone down yet!

**Mad101daN** · 02-07-2008, 08:16 AM

Thx Chippy

I hadnt noticed that it was formulas in the cells.

The water was pretty high a couple of weeks ago, but luckily didnt do any damage. (this time) last year all the office down stairs was flooded. Not all bad, we all got shiney new computers from it.

Thx for your help again, very good of you.

Cheers

Dan