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

Blood Pressure Tracking:
Free Templates for Graphing Your Own Blood Pressure,
Pulse Rate, and Pulse Pressure in Microsoft Excel


Free Blood Pressure Charts (Version 2.5) for
One Month and One BP Reading A Day
(Link for One Month, Two BP Readings A Day)
(Link for One Month, Three BP Readings A Day)

See the instructions below  to record and automatically graph your own blood pressure, pulse rate (heart rate), and pulse pressure,
plus download your own Blood Pressure 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 Blood Pressure Tracker Form For Your Own Data Entry

Download This BP Example

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

Version 2.5 includes the option to either include or omit the display/printing of the pulse rate and/or pulse pressure data from the "Basic 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.

This version retains some additions and changes in the previous version 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 and pulse rate (heart rate) tracking data:

  1. Download and save the Blood Pressure Tracker Form from the link above.  (You are also encouraged to download the example.)

  2. Open the saved file in Microsoft Excel.  (The files are in Micosoft Excel 2007 .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 "BP Data Sheet."  Also enter your pulse rate (heart rate) into the appropriate column.

  4. The associated graphs will automatically update themselves (and automatically adjust their blood pressure scales, if necessary).

  5. Display a graph by clicking on a tab at the bottom of the data entry page.  Graphs available are "Basic Graph in Color, "Basic Graph in Black and White," "Running AVG in Color," "Running AVG in BW," "Extras in Color,", and "Extras in BW."  (See below for "Extras" explanation.)  You may return to the data entry page by clicking on the "BP Data Sheet" tab at the bottom right of a page with a graph.  (If the "BP Data Sheet" Tab is covered up by the horizontal scroll bar on the bottom right, you may need to grab the left edge of the scroll bar and move it to the right to show the data sheet tab.)

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

  7. To change the 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.  Color charts as well as black and white charts of the data are provided to account for the capabilities of different printers.  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.  Version 2.5 includes the option to either include or omit the display/printing of the pulse rate and/or pulse pressure data from the "Basic 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 "BP Data Sheet."

"In addition to Blood Pressure, the display and printing of Pulse Rate on the Basic 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 Basic 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 .  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 "BP Data Sheet."  The continuing 4-day running averages will be included at the beginning of the current month automatically.

11. The "Extras" charts provide the opportunity to add symbols representing different medications and/or activities onto copies of the Basic 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 "BP 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.

Definitions:

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/ency/article/003398.htm .)

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

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

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.

 

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
O'Clock

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

  2011 Ray L. Winstead
eXTReMe Tracker