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. Or, I find it easier to use a form to enter the data. You can manually enter the data on the Blood Pressure Charts tab. 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)
