A BMI Chart or Body Mass Index Chart can be a useful tool for visualizing the ranges for underweight, healthy weight, overweight, and obesity based on a person's height. The simplicity of the BMI formula has made it extremely popular as an initial diagnosing tool for determining a person's healthy body weight. The formula does have its shortcomings because it does not take into account age, frame size, gender, or muscularity.


Advertisement

There are other formulas besides the BMI that are used for determining ideal weight. Our Ideal Weight Chart includes some additional formulas, but keep in mind that "ideal" weight can be highly subjective, and formulas are usually just approximations. Also check out our Weight Loss Charts.


BMI Chart

View BMI Chart full size
Body Mass Index Table

View Body Mass Index Table full size

Download the BMI Charts in PDF format.

How to Reference Our BMI Chart

You may include the GIF image of our Body Mass Index Chart on your website or blog, but you must reference this page by including a hyperlink and citation in the image caption like the following:

- BMI Chart created by Vertex42.com. Used with permission.

Advertisement

BMI Chart and Calculator

for Excel
BMI Calculator Screenshot
Download
Version: Excel 2003 or later

Template Details

License: Personal Use
View Agreement
(not for distribution or resale)
Support
Visit Support Page

 

"No installation, no macros - just a simple spreadsheet" - by


Advertisement

Description

This spreadsheet was used to create the BMI charts listed above (using quite a few special tricks which may delight the Excel enthusiast). It also contains a BMI Calculator and provides tables listing the weight status categories.

The BMI Formula

BMI is defined as a person's weight divided by the square of a person's height, using the metric units kg/m^2.

  • Metric Units: BMI = Weight[kg] / ( Height[m] x Height[m] )
  • English Units: 703 x Weight[lb] / ( Height[in] x Height[in] )

BMI Chart for Children

BMI is calculated the same way for children as for adults, but the criteria for determining a "normal" weight is different. Instead of specific BMI thresholds, a BMI percentile is used to compare to other children of the same age and gender. Just as there are Weight-for-Age, Height-for-Age, and Head Circumference-for-Age growth charts, there are also BMI-for-Age charts.

Download the BMI-for-Age Chart for Boys from cdc.gov.

Download the BMI-for-Age Chart for Girls from cdc.gov.

For children, the weight status category (underweight, healthy weight, overweight, and obese) is defined based on the BMI percentile (less than the 5th percentile, 5th to less than the 85th, 85th to less than the 95th, and equal to or greater than 95th, respectively). See BMI for Children and Teens on the cdc.gov website for the official information.

References

Disclaimer: This body mass index chart spreadsheet, the images, and the information on this page are for illustrative and educational purposes only. Use only as a guide.

Like This Template?

Become a Fan

       
Master Excel - Spreadsheet Tips Workbook