Weight loss calculation: how to use stones and lbs

B

Beemer

I have made a chart showing weight loss over specified time. As an
Excel novice I convert stones and lbs, to lbs only, before entering
the data. How can I directly enter stones and lbs in the cells so that
the chart will show stones and lbs on the axis?

Beemer
 
B

Bernard Liengme

Rather than converting to pounds, enter your weight as, for example, 8 2/14
with a space between the 8 (8 stone) and the 2/14 (2 lbs)
You may need to format the axis of your chart with custom format # ??/14
 
B

Beemer

Rather than converting to pounds, enter your weight as, for example, 8 2/14
with a space between the 8 (8 stone) and the 2/14 (2 lbs)
You may need to format the axis of your chart with custom format # ??/14
Click to expand...
Bernard,

Thank you.

Beemer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I convert Imperial lbs to Stones and lbs in the same cell? 1
A few problems involving LOOKUP and SUMPRODUCT... 1
How do i format a number into stones, pounds and ounces, please? 5
Stones and Lbs 13
Formula for Converting Kilos to Stones 3
how can i use imperial units eg stones and pounds 2
Weight convertor 3
Extracting specific data from a cell 5

Top