Data units - change to lbs

S

Serena

How do I change the data units, as I my data is in stones and lbs so my data units need to be from 1-14 instead of 1-10. How do I change this so that it is reflected in graphs

Thank you
 
A

Andy B

Hi

I would suggest having a calculated cell that adjusts your lbs to be a
decimal part of stones. Therefore 12 stone and 7 lbs would be represented as
12.5 (as 7 pounds is 0.5 stone). It depends on how your data is
entered/stored as to how to implement this, though.

--
Andy.


Serena said:
How do I change the data units, as I my data is in stones and lbs so my
Click to expand...
data units need to be from 1-14 instead of 1-10. How do I change this so
that it is reflected in graphs?
 
Top