![]() Note: Here, I converted the lb unit to kg and cm unit to m. So, we are going to use a formula that will convert the units too.The basic formula for BMI (Body Mass Index) is: BMI = weight(kg)/ height(meters)^2.Here, we will use an Excel formula for calculating BMI and then will apply the Conditional Formatting. Also, I have added some Chart Elements.īMI (Body Mass Index) helps you understand if your weight is healthy for your height. From Custom Combination, choose the Chart Type for Measured Weight as Stacked Area and set the Chart Type for Target Weight as Line > press OK.īelow, I have attached the chart.Then, you will get the Insert Chart window.Select the whole dataset > go to the Insert tab > select the Recommended Charts.Let’s learn the simple steps to create your own chart. Whether you’re losing a little weight or a lot, making an Excel chart can keep you motivated. Format the chart with titles, then save the workbook for regular updates. Then change the chart type to make it clear and understandable. Inserting a Weight Loss Chart in ExcelĬreating a weight loss chart involves inserting an Excel chart. Lastly, the “st” and “lbs” strings are joined with their corresponding values using the Ampersand ( &) operator.ģ.The ROUND function rounds the above value to the nearest integer.The number argument is CONVERT((D6-E6)),”kg”,”lbm”, and the divisor argument is 14. The MOD function gives the remainder of the division.Then, the INT function returns only the integer value.The D6-E6 is the number argument, next “kg” is the from_unit argument, and lastly, “lbm” is the to_unit argument. The CONVERT function uses these 3 arguments. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |