Home |
Search |
Today's Posts |
#1
|
|||
|
|||
blood pressure charting
Blood pressure needs two readings, a Systolic and a Diastolic reading. Does
any one know how I can display readings that I have kept ove the months of my own hypertention. The readings need to give the date, time and the two readings, usually with a line joining the two readings. a tipical example of a reading is: date 11/2/05 time 20.15 sys 130 dia 74 many thanks Mike |
#2
|
|||
|
|||
Mike,
Here is another example: http://www.pdbook.com/index.php/exce...ressure_chart/ ---- Regards, John Mansfield http://www.pdbook.com "MIke" wrote: Blood pressure needs two readings, a Systolic and a Diastolic reading. Does any one know how I can display readings that I have kept ove the months of my own hypertention. The readings need to give the date, time and the two readings, usually with a line joining the two readings. a tipical example of a reading is: date 11/2/05 time 20.15 sys 130 dia 74 many thanks Mike |
#3
|
|||
|
|||
Many thanks for the many suggestions suggestions.
I have found that if you create a line chart and format the data series you can remove the lines and on the options tab, put in up/down bars on the upper reading, this give a chart with the systolic and diastolic joined for each reading. I have'et found a way to add in the pulse readign to this chart yet. Mike "MIke" wrote in message ... Blood pressure needs two readings, a Systolic and a Diastolic reading. Does any one know how I can display readings that I have kept ove the months of my own hypertention. The readings need to give the date, time and the two readings, usually with a line joining the two readings. a tipical example of a reading is: date 11/2/05 time 20.15 sys 130 dia 74 many thanks Mike |
#5
|
|||
|
|||
Mike -
Add the pulse, but change the pulse series to an XY Scatter series (select the series, choose Chart Type from the Chart menu), then if necessary remove any secondary axes Excel provides for you (choose Chart Options from Chart menu, then Axes tab). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ MIke wrote: Many thanks for the many suggestions suggestions. I have found that if you create a line chart and format the data series you can remove the lines and on the options tab, put in up/down bars on the upper reading, this give a chart with the systolic and diastolic joined for each reading. I have'et found a way to add in the pulse readign to this chart yet. Mike "MIke" wrote in message ... Blood pressure needs two readings, a Systolic and a Diastolic reading. Does any one know how I can display readings that I have kept ove the months of my own hypertention. The readings need to give the date, time and the two readings, usually with a line joining the two readings. a tipical example of a reading is: date 11/2/05 time 20.15 sys 130 dia 74 many thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for average recorded blood pressure readings in 1 column . | Excel Worksheet Functions | |||
Importing MM:SS From Tab Delimited File and Charting | Charts and Charting in Excel | |||
Dynamic charting problems (events) | Charts and Charting in Excel | |||
Charting time? help please... | Charts and Charting in Excel | |||
True XYZ axis 3-D charting Add-In for Excel | Excel Worksheet Functions |