Weight loss calculation: how to use stones and lbs

  • Thread starter Thread starter Beemer
  • Start date Start date
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
 
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
 
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
how do i use excel to calculate weight (as in stone and lbs)? 6
A few problems involving LOOKUP and SUMPRODUCT... 1
How do a kg to stone convertion in excel 4
How do i format a number into stones, pounds and ounces, please? 5
weight Stones and Lbs 4
Stones and Lbs 13
Formula for Converting Kilos to Stones 3

Back
Top