(Select the chart, then click the 3-dots in the upper right of it. You could also move the chart to it's own tab to make it much larger. You can then hide columns A through G if you just want the chart. The only other setup you need to do is fill in the gray items on the BPC tab which set the "goal" lines and some conditional formatting (green if you are less than or equal to the goal). Just change the 'Form Responses 1' bits to whatever new tab it provides. If you put them in this order you should be able to quickly adjust the formulas on the "Blood Pressure Charts" tab, yellow highlighted cells, to refer to the new tab it creates, "Form Responses 3" probably, and it should be automatic. The form should have 5 questions that are all "Short answer text" type questions, although you could have the first 4 be numbers if you choose. To do that go to the Tools menu > Create a new form. The blood pressure log sheet template is very comprehensive in that it covers all aspects of a reading schedule or arrangement. Or, I find it easier to use a form to enter the data. The graph at the top of the log will automatically update as you enter your readings. This is a monthly log, allowing for up to 35 readings. One worksheet, the Blood Pressure Data, is used for typing in daily blood pressure measurements. You can manually enter the data on the Blood Pressure Charts tab. Blood Pressure Log Download Download 63.50 KB 4444 downloads Use this log to keep track of your blood pressure readings and monitor your progress in improving your blood pressure levels. This health tracker contains two worksheets that each has specific functions. You'll want to make a copy of this before doing anything so it isn't shared with the world.
Here's one that I made for myself a while back:
0 kommentar(er)
