ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-26-2005, 06:15 PM
wvincent642
Guest
 
Posts: n/a
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.
Reply With Quote
  #2  
Old 05-26-2005, 06:15 PM
Mark
Guest
 
Posts: n/a
RE: Chart to monitor Blood Pressure readings and date

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.

Reply With Quote
  #3  
Old 05-27-2005, 02:05 PM
wvincent642
Guest
 
Posts: n/a
RE: Chart to monitor Blood Pressure readings and date

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.

Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 11:27 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0