ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart to monitor Blood Pressure readings and date (https://www.excelbanter.com/charts-charting-excel/27890-chart-monitor-blood-pressure-readings-date.html)

wvincent642

Chart to monitor Blood Pressure readings and date
 
Does any one have any ideas on how to set up a chart to show daily readings
of Blood Pressure? I want to chart readings over one month intervals. Need
to figure out how to insert variables (123/82) and date of reading and get a
meaningful representation.

Mark

Do you intend to capture BP once a day or more often?

If, for example, you want to take a reading every morning and one every
night then you would set up your spreadsheet with 5 cloumns (date, am
diastolic, am systolic, pm diastolic and pm systolic (can't remember which of
the two is the higher, but you get the drift).

Then, autofill the date column (edit-fill-series... with your month's range).

Select the whole rectangular area and click on the chart wizard. select line
chart and so forth and you should get 4 lines. Add titles etc and decide
where you want the chart to appear. play with colors, line weight etc till
you're happy.

As you fill in the data, the lines will crawl across the chart.

Hope this helps,
Mark

"wvincent642" wrote:

Does any one have any ideas on how to set up a chart to show daily readings
of Blood Pressure? I want to chart readings over one month intervals. Need
to figure out how to insert variables (123/82) and date of reading and get a
meaningful representation.


wvincent642

Thanks for the info. I will give it a try and hopefully, be able to show the
Doc on my next visit how things look. I really appreciate the help!

"Mark" wrote:

Do you intend to capture BP once a day or more often?

If, for example, you want to take a reading every morning and one every
night then you would set up your spreadsheet with 5 cloumns (date, am
diastolic, am systolic, pm diastolic and pm systolic (can't remember which of
the two is the higher, but you get the drift).

Then, autofill the date column (edit-fill-series... with your month's range).

Select the whole rectangular area and click on the chart wizard. select line
chart and so forth and you should get 4 lines. Add titles etc and decide
where you want the chart to appear. play with colors, line weight etc till
you're happy.

As you fill in the data, the lines will crawl across the chart.

Hope this helps,
Mark

"wvincent642" wrote:

Does any one have any ideas on how to set up a chart to show daily readings
of Blood Pressure? I want to chart readings over one month intervals. Need
to figure out how to insert variables (123/82) and date of reading and get a
meaningful representation.



All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com