Dr. Ray L. Winstead
Professor of Biology (retired), Indiana University of Pennsylvania

Vital Signs Tracking:
Free Templates for Graphing Your Own Blood Pressure,
Pulse Rate, Pulse Pressure, Body Temperature, and Respiratory Rate in Microsoft Excel

Three Readings A Day for One Month
(Link for One Reading A Day for One Month)
(Link for Two Readings A Day for One Month)

See the instructions below  to record and automatically graph your own blood pressure, pulse rate (heart rate), pulse pressure,
body temperature, and respiratory rate (breathing rate), plus download your own Vital Signs Tracker Form and the example.
(Also see the notes below for a link to the original Legacy Version 1.0 website
and using OpenOffice.org spreadsheet "Calc.")

Download Vital Signs Tracker Form For Your Own Data Entry

Download This Example

(Downloads are free for personal use but may not be sold.)

This version includes cumulative, summary statistics (average, standard deviation, highest, and lowest values) for measurements of Vital Signs as suggested by Jack Hargraves in New Zealand.  These statistics are presented just under your data on the Data Sheet.

This version retains graphs for body temperature as suggested by Leah Biondo in Melbourne, Australia.  Graphs for respiratory rates have also been added, so that now graphs are available for tracking all the "Vital Signs," in addition to the original blood pressure graphs of earlier versions.  See below for basic definitions of the "Vital Signs."

This version retains the earlier option to either include or omit the display/printing of the pulse rate and/or pulse pressure data from the main graph displaying blood pressure and pulse rate.  This is especially useful when the pulse rates and pulse pressures overlap.  They can then be displayed/printed separately with the blood pressure readings.

This version retains some additions and changes in earlier versions based on suggestions and comments by Laura Renfree from London, England; Michael Robichaud from Montreal, Canada; Margaret Dangoor from Richmond-upon-Thames, England; Neal Snitow; Ron Langbeckert from Astoria, Oregon, and Ed Winstead from Brevard, North Carolina.  I thank them for their contributions.

Instructions for entering and displaying your own blood pressure, pulse rate (heart rate), body temperature, and respiratory rate (breathing rate) tracking data:

  1. Download and save the Vital Signs Tracker Form from the link above.  The Vital Signs Tracker Form will open in "Protected View," so you will need to click the button "Enable Editing" to enter your own data.  (You are also encouraged to download the example.)

  2. Open the saved file in Microsoft Excel.  (These files are in 2012 Micosoft Office 365 Excel .xlsx format.  However, earlier versions of Excel can read these files but MAY require a conversion addon available from Microsoft.  (See http://www.microsoft.com/downloads/en/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en.))

  3. After taking your blood pressure, fill in the Systolic Pressure and Diastolic Pressure values into the appropriate columns in the "Data Sheet."  Also enter your pulse rate (heart rate), body temperature, and respiratory rate into the appropriate columns.  (Missing or unwanted data points can just be left out.)

  4. The associated graphs will automatically update themselves with the new data points.  The graphs will automatically adjust their scales based on the new data points, if necessary.  Record Body Temperature in EITHER degrees Fahrenheit OR degrees Celsius to the nearest tenth of a degree, and the appropriate scale will be displayed.  Just be consistent.

  5. Display a graph by clicking on a tab at the bottom of any page/screen.  Graphs available for three readings a day are "Daily Averages BP, PR, PP," "Daily Averages Body Temperature," "Daily Averages Respiratory Rate," "Systolic BP," "Diastolic BP," "Pulse," "Body Temperature," and "Respiratory Rate."  Graphs for "Daily Averages" require all three measurements for the day, however the other graphs will still show any data for the day, even if some data points are missing.  You may return to the data entry page by clicking on the "Data Sheet" tab at the bottom left of a page with a graph.  (If the "Data Sheet" Tab or some other tab is covered up, you may need to use the arrows at the bottom left of each screen to view the tabs.)  ("Extras" and Four-day Running Averages are available only for once and twice a day graphs.)

  6. Save the file with a different name, e.g., bp-yourname-date.

  7. To change a graph title, e.g., to Blood Pressure, Pulse Rate, and Pulse Pressure Record - YOURNAME - Month and Year: Click once on the title to select the title, then click again on the title to be able to edit the title.  Edit the title and save.  (The title may be moved before or after editing by clicking and dragging the title text box.)

  8. The data set and graphs may also be printed.  Individual graphs may be printed, or the entire Excel Workbook of all graphs and data may be printed at one time to take to a physician.

  9.  This version includes the option to either include or omit the display/printing of the pulse rate and/or pulse pressure data from the "BP, PR, PP Graphs."  This is especially useful when the pulse rates and pulse pressures overlap.  They can then be displayed/printed separately with the blood pressure readings.  The following instructions are on the "Data Sheet."

"In addition to Blood Pressure, the display and printing of Pulse Rate on the BP, PR, PP Graphs are the default settings. However,
for not displaying or printing Pulse Rate click on the default "Yes" below and change the "Yes" to "No" in the drop-down list that will appear."

"In addition to Blood Pressure, the display and printing of Pulse Pressure on the BP, PR, PP Graphs are the default settings. However,
for not displaying or printing Pulse Pressure click on the default "Yes" below and change the "Yes" below to "No" in the drop-down list that will appear."

10. Note that graphs of Four-Day Running Averages for Blood Pressure values, Pulse Rate values, and Pulse Pressure values are also provided (for the files for one reading a day and two readings a day, but not for three readings a day).  OPTIONAL :  If you wish, you may continue the 4-day running averages using the data at the end of the preceding month at the beginning of the current month by recording the LAST THREE READINGS from the PRECEDING month at the BOTTOM of the "Data Sheet."  The continuing 4-day running averages will be included at the beginning of the current month automatically.

11. The "Extras" charts (available only for once and twice a day graphs) provide the opportunity to add symbols representing different medications and/or activities onto copies of the BP, PR, PP Graphs, i.e., a visual representation of these events can be placed on the graphs themselves.  Note the example above.
            a) Choose whether you want to use the color "Extras" graph or the black and white "Extras" graph, since each chart must be modified separately.
            b) To place a particular symbol onto the graph, first select the symbol you want at the bottom of the chart by RIGHT clicking on it.  (Be careful not to click on the text box below the symbol.  If you do select the text box by mistake, just click elsewhere on the page and start over.)  RIGHT clicking on the symbol will bring up a long menu that includes "Cut," "Copy," and "Paste" at the top.  Click on "Copy."  (If a small menu with "Move Here" and "Copy Here" appears, then ignore this menu and RIGHT click there a second time, and this will bring up the longer menu you need.) 
            c) Move the cursor, which will now have a "modified plus sign" associated with it, to the top of the chart to the left of the chart title. (If you try this part of the process elsewhere, it is likely you will get some bizarre changes to the original graph.  If this happens, just click on the Undo arrow at the top of the page.)
            d) RIGHT click and the "Cut, Copy, Paste" menu will appear.  Click on "Paste" and the selected symbol will appear in the top left corner of the graph.
            e) Drag the new symbol to where you want it onto the graph, e.g., onto the vertical blood pressure icon for that date.  See the example above.
            f) You can change the "Med/activ #" notation for that symbol at the bottom of the graph, if you wish, to the actual name or abbreviation of the medication or the event, e.g., an exercise activity. "Med/activ #" is inside a textbox under the symbol.  Click in the textbox and note that you will then be able to edit the text to what you want.

12. A place is provided on the "Data Sheet" for time and additional notes for each day.


The original Legacy Version 1.0 website is still available.

That website provides graphs for one week, two weeks, three weeks, and a month, each also giving an option for one record a day or for two records a day.   Those files are in Excel .xls format and can be opened using Microsoft Excel or the free OpenOffice.org spreadsheet "Calc."  To download the free OpenOffice Suite go to http://download.openoffice.org/.  Initial attempts were made to convert the updated versions for one month into OpenOffice "Calc" format, but the symbols and formatting lost was substantial and has not been pursued further.


Vital Signs Vital signs are used to measure the body’s basic functions. These measurements are taken to help assess the general physical health of a person, give clues to possible diseases, and show progress toward recovery (http://my.clevelandclinic.org/health/healthy_living/hic_Pre-participation_Evaluations/hic_Vital_Signs).  There are four main vital signs: blood pressure, body temperature, pulse (heart rate), and respiratory rate (breathing rate). (For example, see http://my.clevelandclinic.org/health/healthy_living/hic_Pre-participation_Evaluations/hic_Vital_Signs and http://www.emergencycareforyou.org/VitalCareMagazine/ER101/Default.aspx?id=500 .)

Blood Pressure is the force of the blood on the walls of the arteries, i.e., the force in the circulatory system that circulates the blood throughout the body.  (For example, see http://www.bloodpressure-drs-practical-guide.com/index.html and http://www.mayoclinic.com/health/high-blood-pressure/DS00100 .)  A normal blood pressure is about 120/80, where the top number is the systolic pressure and the bottom number is the diastolic pressure.  The unit of measurement is in millimeters of mercury (mmHg).  (For example, see http://www.nlm.nih.gov/medlineplus/highbloodpressure.html .)

Systolic Pressure is the maximum blood pressure when the heart contracts.  (For example, see http://www.nlm.nih.gov/medlineplus/highbloodpressure.html .)

Diastolic Pressure is the minimum blood pressure when the heart is not contracting between beats.  (For example, see http://www.nlm.nih.gov/medlineplus/highbloodpressure.html .)

Hypertension means high blood pressure.  (For example, see http://www.webmd.com/hypertension-high-blood-pressure/guide/hypertension-overview-facts .)

Pulse Pressure is the difference between systolic pressure and diastolic pressure, e.g., if your systolic pressure is 120 and your diastolic pressure is 80, then the pulse pressure is 40.  More recently, researchers are finding that pulse pressure may even be a better predictor of cardiovascular problems than hypertension.  For example, see http://www.bloodpressure-drs-practical-guide.com/pulsepressure.html Dr. Vincent R. Moloney states that when pulse pressure is greater than 60 mm HG there is an increased incidence of adverse cardiovascular events, especially in the older population.  Diastolic pressure is more predictive of possible cardiovascular problems in people less than 50 years old.  At 50 - 59 years of age systolic pressure is most predictive, while after 60 the pulse pressure is most important.  As one ages there is a gradual shift in the strength of prediction of risk from diastolic pressure to systolic pressure to pulse pressure.  Also see http://www.mayoclinic.com/health/pulse-pressure/AN00968 and http://www.healthcentral.com/high-blood-pressure/c/58370/110775/pulse.

Pulse Rate (Heart Rate) is the number of times the heart beats in one minute.  (http://my.clevelandclinic.org/health/healthy_living/hic_Pre-participation_Evaluations/hic_Vital_Signs and http://www.emergencycareforyou.org/VitalCareMagazine/ER101/Default.aspx?id=500 . )

Body Temperature Normal: 98.6°F (37°C); greater than 100.4°F (38°C) is considered a fever.  (http://my.clevelandclinic.org/health/healthy_living/hic_Pre-participation_Evaluations/hic_Vital_Signs and http://www.emergencycareforyou.org/VitalCareMagazine/ER101/Default.aspx?id=500 . )

Respiratory Rate (Breathing Rate A person’s respiratory rate is the number of breaths you take per minute. The normal respiration rate for an adult at rest is 12 to 20 breaths per minute.   (http://my.clevelandclinic.org/health/healthy_living/hic_Pre-participation_Evaluations/hic_Vital_Signs and http://www.emergencycareforyou.org/VitalCareMagazine/ER101/Default.aspx?id=500 . )


Also check out

Human Circulatory System - Blood Pressure by Dr. Ray L. Winstead

 Lifestyle Recommendations for Long Term Health by Dr. Andrew C. Browe

Click to check out FREE Memory Aid for Tracking Pills
Simple Solution to answering the question "Did I already take that pill earlier today?"

Back to Dr. Winstead's Homepage

Current Percentage Metric Time is

Send comments to Dr. Ray L. Winstead
Direct e-mail Link: rw@raywinstead.com

©  2011 Ray L. Winstead
eXTReMe Tracker