At any time though, your graph will show ups and downs because of changes in fluid balance, differences in fluid intake from day to day, level of physical activity, and weight of undigested food. The beginning of a weight loss effort is when weight graphing is most fun, a good time to start the habit. List successive weights up and down from there, one pound per line, higher weights at the top.Įach day, go up the line above that day until you are on the same horizontal line as your weight that day, and make a dot. Connect the dots with a solid line. The example below shows someone who started graphing on the 10th of the month at 178 lbs, weighed 178.5 on the 11th, 177 on the 12th, 177 on the 13th, 177.5 on the 14th, 177 on the 15th, 176 on the 16th, etc. Write in your first weight next to the third line from the top. The left vertical line will show a range of your weights. The bottom horizontal line shows the days of the month. Most of us are lighter immediately after voiding when we get up in the morning. Weigh at the same time under the same conditions every day. Don't worry if your scale shows a weight different from other scales. Get a good scale. Get on and off it at least three times to see that it gives a consistent reading. Put it on a level, hard surface at home. Graph, both during the weight loss phase and for long-term weight maintenance. Instructions on proper weighing and how to track your weight on your weight Prefer to weigh only once per week there is evidence that weighing daily isīest, but the most important thing is that you weigh yourself consistentlyĪnd at least weekly, even if you think your weight will be up. On your weight graph, regardless of which graph you're using. Some people Now, weigh yourself consistently, preferably every day, and record each weight In PDF format and instructions on how to keep a weight graph are Phase, you will want to use the long-term phase graph. If you've lost weight and are ready to enter the weight maintenance Weight (versus maintaining weight), you will want to use the weight loss phase WeĪre providing you with two weight graph options. Technique is to keep a visual record of your weight.īy printing one of our blank weight graphs below (click on the image). Your weight if you can't see where it's going. * If you wish, you may move Data Retrieved 1 table to other sheet so that only the Data Entered table and the chart are visible in the current sheet.Can't drive a car if you can't see where you're going. You can't control * If you wish, you may hide column C (and column D) in Data Entered table. Table definitions are as follows (only showing the first several rows). Where the sheet before filterings is as follows: The sample sheet after applying necessary filterings: Note that we need to use scatter chart in order to handle possible skipped dates correctly. This chart will only use the visible data and thus be automatically updated reflecting the change in source. Scatter Chart 1 is sourced from Data Retrieved 1 table. In Data Retrieved 1 table, set A2 to the earliest date in Data Entered table and retrieve values for each date from the date in A2 to the last date in Data Entered table and filter the rows by value so that only the rows with value >0 will be shown. This way the table can be of fixed visible size and the top row will be always the row for today. In Data Entered table, set A2 to a future date, that would be one year ahead although here it is for brevity's sake, and create rows for every date from beginning to the date in A2 and filter the rows by condition(s) on date to show only the recent 14 days. In this scheme I'd create master data table (Data Entered) for storing data and a retrieved data table (Data Retrieved 1) for creating chart as shown below. I'd separate data model and view and keep data model as simple as possible. This may not be exactly what you're looking for but here's a setup I'd use for such data entry and viewing. Also, the weight has to move one row at a time to be in the right row at the right date. Now the other way round, it might be difficult, because the table expands down, but the most current date should be on top. So I hide every cell which didn't have content at all. And filter, which only showed the cells where the formula had added something. And I could enter my weight.īasically, I had a formula which added the date to another cell, if the date was today. I had it working "upside down", so that the most current date was on the very buttom, and the table expanded each day. In the end, I want to enter a weight each day, and display the table in a chart. I want to have a fixed row, so it stays in position, the design and everything stays as well, but the content can move.Īlso, I want my table to expand each day, one row at a time, moving the date as shown. I have a problem designing my weight tracking table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |