As per title really.
I'm setting up a weight loss chart for me old dear (and me ) and want to set the scale on a chart but doesn't want to play.

Scale example:

Maximum = 16
Minimum = 10
Major Unit = 1
Minor = 0.1

How can I set this so it'll accept 12.13 as 12st 13lb for example.

Is this do-able?

Ta in advance

Ian

 

Nobody?
My problem is, as it stands, if you chart a change from say 14.1 to 13.11 it drops loads due to not understanding the scale.

Any ideas peeps?

Cheers,

Ian

 

dont know if this is any help, you may find formulas within you can paste into your own spread.

http://www.geocities.com/wendylose/weight-loss.xls

this was found by typing "weight loss.xls" into google.

 

Thanks mj - I've seen that one before but I really wanted to create one which would use stones/lbs rather than just lbs. Doesn't seem as easy as I thought though...

 

it may be worth buying some new bathroom scales and using the metric system!

 

lol, always an option!