Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I've got a formula for stones and pounds - how do I get an excel .
Hello,
I've got a column that displays a series of weights in stones & pounds (both in the one cell). How do I get a chart to recognise and display in the same format? Regards, mikelenno |
#2
|
|||
|
|||
What is the format of the cells with stone & pounds
It is best to enter such values a 10 3/14 and format the cells with # ??/14 best wishes from one who is INT(275,14) stone & MOD(250,14) lbs -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mikelenno" wrote in message ... Hello, I've got a column that displays a series of weights in stones & pounds (both in the one cell). How do I get a chart to recognise and display in the same format? Regards, mikelenno |
#3
|
|||
|
|||
Actually Bernard, I lied (sort of). I'm also trying to include ounzes. My
not-very-succinct-method so far includes 3 columns for stones/pounds/ounzes to record weight once per week. I convert the 3 figures to give an overall weight in decimal so 12st/3lb/8oz becomes 178.5lbs. I then enter =INT(F3/14)&" st "&MOD(F3,14)&" lb" in a new column referencing the cell with 178.5 to give a cell with 12st 10.5lb. When I create a chart using a series from the new column I can't get the Y axis to display the increments as stones & pounds. "Bernard Liengme" wrote: What is the format of the cells with stone & pounds It is best to enter such values a 10 3/14 and format the cells with # ??/14 best wishes from one who is INT(275,14) stone & MOD(250,14) lbs -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mikelenno" wrote in message ... Hello, I've got a column that displays a series of weights in stones & pounds (both in the one cell). How do I get a chart to recognise and display in the same format? Regards, mikelenno |
#4
|
|||
|
|||
Y values must be numeric.
Suggest you plot with the decimal values and make a column with "st & lbs" with intervals like 10 st 7 lbs, 11st 0 lbs ... and use Rob Bovey's XY Chart Labeler, a free add-in: http://www.appspro.com/utilities/utilities.asp to label the y-axis best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mikelenno" wrote in message ... Actually Bernard, I lied (sort of). I'm also trying to include ounzes. My not-very-succinct-method so far includes 3 columns for stones/pounds/ounzes to record weight once per week. I convert the 3 figures to give an overall weight in decimal so 12st/3lb/8oz becomes 178.5lbs. I then enter =INT(F3/14)&" st "&MOD(F3,14)&" lb" in a new column referencing the cell with 178.5 to give a cell with 12st 10.5lb. When I create a chart using a series from the new column I can't get the Y axis to display the increments as stones & pounds. "Bernard Liengme" wrote: What is the format of the cells with stone & pounds It is best to enter such values a 10 3/14 and format the cells with # ??/14 best wishes from one who is INT(275,14) stone & MOD(250,14) lbs -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mikelenno" wrote in message ... Hello, I've got a column that displays a series of weights in stones & pounds (both in the one cell). How do I get a chart to recognise and display in the same format? Regards, mikelenno |
#5
|
|||
|
|||
Thank you Bernard, the chart labeler makes it a lot easier (got it from
http://www.appspro.com/Utilities/ChartLabeler.htm). Regards, mikelenno "Bernard Liengme" wrote: Y values must be numeric. Suggest you plot with the decimal values and make a column with "st & lbs" with intervals like 10 st 7 lbs, 11st 0 lbs ... and use Rob Bovey's XY Chart Labeler, a free add-in: http://www.appspro.com/utilities/utilities.asp to label the y-axis best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mikelenno" wrote in message ... Actually Bernard, I lied (sort of). I'm also trying to include ounzes. My not-very-succinct-method so far includes 3 columns for stones/pounds/ounzes to record weight once per week. I convert the 3 figures to give an overall weight in decimal so 12st/3lb/8oz becomes 178.5lbs. I then enter =INT(F3/14)&" st "&MOD(F3,14)&" lb" in a new column referencing the cell with 178.5 to give a cell with 12st 10.5lb. When I create a chart using a series from the new column I can't get the Y axis to display the increments as stones & pounds. "Bernard Liengme" wrote: What is the format of the cells with stone & pounds It is best to enter such values a 10 3/14 and format the cells with # ??/14 best wishes from one who is INT(275,14) stone & MOD(250,14) lbs -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mikelenno" wrote in message ... Hello, I've got a column that displays a series of weights in stones & pounds (both in the one cell). How do I get a chart to recognise and display in the same format? Regards, mikelenno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|