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
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
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.
