doctors orders - excel

  blackjohn 11:49 21 Sep 2004
Locked

my doctor has asked me to provide a graph of my blood pressure readings over 'say a two or three week period

I am a complete novice with regards to excel and haven't a clue how to do it.



I would need the X axis to cover from 50 to 180 & to randomnly enter on the y axis the date and time the readings would be taken (i.e. on average i take the readings 3 times a day but it does vary and sometimes i miss a day or two

I would like to display the diastolic pressure in red & the systolic in green and also a dotted line in the same colours to show the average.

is this to 'tall an order' or is it possible

  VoG II 12:22 21 Sep 2004

To follow convention you should plot date/time on the X (horizontal) and Pressure on the Y axis (vertical).

In Column A enter the date and time of each reading in the format

21/09/2004 10:15:00

Excel should recognise this as a date/time automatically.

Enter the corresponding readings in Columns B and C.

When you have entered all of the data, select it all and click the Chart Wizard toolbar button. This will guide you through creating the graph.

  VoG II 12:25 21 Sep 2004

P.S.

Once you have constructed the basic graph we can talk you through the colours, showing the averages, changing the scaling and so on. But I suggest that we proceed one step at a time.

  Baledor 12:50 21 Sep 2004

when I read your post, which you are welcome to.

  end 13:22 21 Sep 2004

(am "medically- minded "so..

can I suggest you increase the "range" to read from 40 to 200; if you are going to be taking your blood pressure frequently and often ( how often and who is taking it?), something is "not right" and the readings could well vary beyond your requested paremeters; hopefully your original request will be sufficient, but a wider margin cannot harm the graph ( though may not be too good for your physical health!!)

sorry to butt in,,, carry on "doctoring " excell-wizards::))

  VoG II 13:40 21 Sep 2004

Excel will scale the graph automatically to fit the range of the data. However, you can then change the scaling as you wish to get a better "look".

  blackjohn 15:31 24 Sep 2004

thanks for the postings

sorry VoG I always get my X & Y's mixed up.

Baledor If its not too much trouble I will have your 'knocked up version', as I said i am a complete novice with regards to excel and anything which helps me with regards to taxing my 'old' brain would be of help.

I off on holiday for a few weeks from next tuesday and will look at any suggestions more carefully when I get back.

so don't stop the postings as i will try all the suggestions

  Baledor 16:53 30 Sep 2004

I am not keen to post my email address on a public forum, nor for you to post yours, endless spam awaits those who do! Racking my brains at the mo, to think of a good way of contacting you outside of the forums...any ideas?

  VoG II 16:55 30 Sep 2004

Click the yellow envelope next to blackjohn's name to e-mail him.

  Baledor 10:19 01 Oct 2004

Cheers!

  blackjohn 11:03 21 Oct 2004

Thanks for the updates

just got back off holiday

baledor ........ i've checked my inbox on yahoo but haven't seen anything from you.

have you sent the information???

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HP Envy x2 review: Hands-on

How Sketch and InVision have revolutionised our design workflow

The best tech gifts for Christmas 2017

Les meilleurs jeux de société (2017)