Excel Weight Loss Chart
In order to use the above Excel Weight Loss Chart Template, simply enter your height and, if required, your target weight, into cells I2 and I3 of the spreadsheet. The spreadsheet will automatically display the recommended healthy weight range for your height.
Enter the start date and your initial weight into cells B25 and C25, in the bottom half of the screen. Every time you weigh yourself, enter the date and your weight into this table, below the previous entry. Your progress will automatically be displayed in the chart on the top left of the spreadsheet, and summarized in the table on the top right of the spreadsheet.
The BMI and weight loss calculations are mainly performed using the simple Excel operators, +, -, * and /
However, the following functions are also used in the spreadsheet :
|IF function||Checks if the data has been entered by the user, and if so, displays the calculated BMI, etc.|
|ROUND function||Rounds the calculated BMI to one decimal place.|