Here's what I would do. I'd calculate the values in the worksheet in stones,

so that for example 14 stone 12 pounds is 14.857143. I would set up the axis

scale so the major unit is 1 (stoner) and the minor unit is

0.0714285714285714 (i.e., 1/14). This gives 14 divisions between each stone.

If you want to show labels with stones and pounds, I don't think you can do

anything besides constructing the labels using text manipulation

functions.For example, if your weight in decimal stones is in A1, use this

in B1:

=INT(A1)&" stone "&ROUND((A1-INT(A1))*14)&" pounds"

If your weight is in pounds in A2, use this in B2:

=INT(A2/14)&" stone "&(A2-14*INT(A2/14))&" pounds"

If you want axis labels with mixed units, create your axis using stones as

your units, then make a dummy axis with an extra XY series, choose X and Y

so you get a data point where you want each label, and use data labels to

show these text (non-numeric) labels. See the tutorials here:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
http://peltiertech.com/Excel/Charts/ArbGridLabel.html
- Jon