I want to make a weightloss chart in excel, its needs to be in stones and lbs then when I enter my weight a week later it will show the loss or if I have put on, anyone know what formulas I need to use?
TIA
I want to make a weightloss chart in excel, its needs to be in stones and lbs then when I enter my weight a week later it will show the loss or if I have put on, anyone know what formulas I need to use?
TIA
Hi louise2613,
You can use variance (difference method)... i.e., current weight minus previous weight = if result is +ve you have put on and if -ve you have reduced...
Also, you can show columns by days where you will enter your weight per week which can be shown in a simple column graph chart. - just select the data and inset - > chart-> column type
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
See if this workbook helps.
Enter the date in Column A, your stones in Column B, and pounds in Column C
Columns G:H can be hidden using the grouping button below the formula bar.
Last edited by Marcol; 04-13-2012 at 04:10 AM. Reason: Added C/F and Validation to Workbook
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks