Go for height weight chart templates which can be. Graphchart for age and height in excel hi. You can print it or you can also change the layout and the look of this chart using excel chart menu. I have six children to compare. You can see the sample picture below. Bmi weight kg height m 2.
In such cases a simple height. You can see the bold black line with your babys name as its legend that will change based on your data input. Wlb 110 506 hin 60 women. Weight for age and body mass index are two growth charts used to assess teen weight. First find your height in inches using the left most column. It will calculate you bmi body mass index of the moment and track it as the days go.
Listed below are the formulas we used to calculate weight in pounds wlb given height in inches hin. You want to lose weight or just track your weight. A weight between the 5th and 95th percentile is considered within the healthy or normal range. Wlb 1001 506 hin 60 robinson formula. Bmi formula wlb bmi hin2 703 devine formula men. Before erasing those samples you can switch the worksheet into height and weight chart worksheet.
There you will find the maximum weight allowed for your height in your age group. Enter the start date and your initial weight into cells b25 and c25 in the bottom half of the screen. The spreadsheet will automatically display the recommended healthy weight range for your height based on bmi. Then right next to it youll see the minimum weight allowed. It is also very useful if. 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.
Multiple the weight in pounds by 045359237 to get weight in kilograms. Then use this great template to track your weight set target and add commentsit can be used as a weight loss template or diet excel sheet. How do i plot a chart graph of height cm vs age date value. Choose height weight chart templates which allow you to incorporate your data in a tabular form. To find you maximum weight go to the column corresponding to your age group. The approach used here is to first convert height in inches and feet to meters and weight in pounds to kilograms then use the standard metric formula for bmi.
A 115 pound 13 year old girl at the same height has a bmi equal to 225 which falls at the 85th percentile and is considered normal weight. This makes it easy to collect height and weight in commonly used units in the united states and also show the metric amounts used in the calculation. If you are 18 years old you will look in the 17 20 age group column. If you want an ideal weight calculator you will need a template that suits the purpose. Male height and weight standards. Columns and rows would.
I want to compare them at the same age ie when they were all five and on a separate chart to show their height relative to each other that is their height on the same date. Weight tracking chart and table template.
Gallery of Height Weight Chart Excel
