Excel Weight Loss Chart

Excel Weight Loss Chart Template

Excel Weight Loss Chart / Tracker

Versions: Excel 2003 and later
Description: Allows you to record and track your weight over several periods and plots this on a chart, alongside your target weight. Also includes a BMI calculator that tells you the healthy weight range for your height (based on BMI).

Download Now



Using the Excel Weight Loss Chart Template

In order to use the above Excel Weight Loss Chart Template to track your weight, 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 (based on BMI).

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, add the new date and your new weight to the table. Your progress will automatically be displayed in the spreadsheet chart, and summarized in the table on the top right of the spreadsheet.


Functions Used in the Weight Loss Chart Template

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 Used to check if the data has been entered by the user, and if so, displays the calculated BMI, etc.
ROUND function Used to round the calculated BMI to one decimal place.