weight Stones and Lbs

[Guest]

Hi there I'm trying to create a chart that will show weight loss progress but I'm having trouble. I need to display stone and Lbs in the y column I need it to count to 14lbs before going up a stone, at the moment it only counts to 10 befroe going to the next stone. Help me please

Thank

 

[Peo Sjoblom]

How do you count the lbs?

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Hi there I'm trying to create a chart that will show weight loss progress

but I'm having trouble. I need to display stone and Lbs in the y column I
need it to count to 14lbs before going up a stone, at the moment it only
counts to 10 befroe going to the next stone. Help me please.

 

[Peo Sjoblom]

What decides how to go from 10 to 9 stones? Is there a formula involved or
what?
Can you show how the source data looks like (no attachments) like in

Y axis

data1
data2
etc..

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

I want to display st and lbs on the y axsis, so I can plot weight every

week. At the moment to go from 10 to 9 stone takes only 10 lbs but I want
it to take 14lb. So if the Mrs loses 8lbs for eg there would still be 6lbs
not 2lbs to get to the next whole. I hope that makes a little more sence.

 

[Ed Ferrero]

Hi richard,

If cell B6 contains the weight in lb then this formula will show stones and
pounds.

=IF(INT(B6/14)=0, MOD(B6,14) & " lb",INT(B6/14) & " st " & MOD(B6,14) & "
lb")

Hi there I'm trying to create a chart that will show weight loss progress

but I'm having trouble. I need to display stone and Lbs in the y column I
need it to count to 14lbs before going up a stone, at the moment it only
counts to 10 befroe going to the next stone. Help me please.

 

[CLR]

=A1/14 and format as Custom, # ??/14 will display "10 9/14" for 149 pounds


Vaya con Dios,
Chuck, CABGx3

Hi there I'm trying to create a chart that will show weight loss progress

but I'm having trouble. I need to display stone and Lbs in the y column I
need it to count to 14lbs before going up a stone, at the moment it only
counts to 10 befroe going to the next stone. Help me please.