Excel Quickie...

Reply Subscribe

Thread Tools

Search this Thread

02 July 2002, 12:01 PM

Trotty

Scooby Regular

Thread Starter

Join Date: Feb 2002

Posts: 179

Likes: 0

Received 0 Likes on 0 Posts

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

Reply Like

08 July 2002, 08:01 AM

Trotty

Scooby Regular

Thread Starter

Join Date: Feb 2002

Posts: 179

Likes: 0

Received 0 Likes on 0 Posts

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

Reply Like

08 July 2002, 09:53 AM

Scooby Regular

Join Date: Apr 2002

Location: The poliotical wing of Chip Sengravy.

Posts: 6,129

Likes: 0

Received 0 Likes on 0 Posts

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.

Reply Like

08 July 2002, 10:31 AM

Trotty

Scooby Regular

Thread Starter

Join Date: Feb 2002

Posts: 179

Likes: 0

Received 0 Likes on 0 Posts

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...

Reply Like