Also let me know if I can make any improvements for this Dynamic Dashboard Template. Please let me know what you think about this download in the comments and let me know if you want me to build a similar template for Excel 2003. Won’t you join me in getting more fit and healthy as well as seeing you accomplishing your goals with a really cool Personal Excel Dashboard? Body mass index is defined as the individual’s body weight divided by the square of his or her height.” It was invented between 18 by the Belgian polymath Adolphe Quetelet during the course of developing “social physics”. BMI does not actually measure the percentage of body fat. Presently this chart displays weight in Pounds but it could be modified for the Metric Weight System as well.Īs per Wikipedia – “The body mass index ( BMI), or Quetelet index, is a heuristic proxy for human body fat based on an individual’s weight and height. Finally, you can put in your height and it calculates your target BMI Weight Range and plots that on the Dashboard Chart as well. That makes this a Dynamic Dashboard.Īlso, you can enter in your target Weight Range and a band for this target will be plotted on the chart along with your weight. The Dashboard was setup using Excel 2007 and you can track your weight by date and a graph of your progress will automatically be created as you enter new data. Below is the Free Template Download for this Excel Dashboard for Weight Loss. Now I can use an Excel Dashboard Template and Chart file to track my weight and plot it against my target weight range and my BMI target weight range (Body Mass Index). Use these password logs in your favorite planner or binder. In this ever expanding universe, so is my belt. These password logs come in 25 different styles and they’re free to print and use for personal use only.