Weight chart

[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

Thanks

 

[Jon Peltier]

Richard -

Having trouble with the chart, or with the weight loss? (Sorry!)

If you put the weight in pounds in column A, starting in cell A2, put
this formula in B2 to get stone

=INT(A2)/14

And this in C2 to get pounds

=A2-B2*14

How do you intend to use this dual measurement system in the chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jon Peltier]

I don't know if this is what you're after. You can display the numbers
on the axis with a custom number format. First, make sure the weight is
in the worksheet as decimal fractions of stone. Double click the axis,
and on the number tab, click on Custom in the left list, and enter this:

# ??/14

in the box at the right. At my current weight of 200 lb, I'm 14.28571
stone, or 14 4/14 stone.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______