Want to change chart data range from Kg to stones

That's very close to what I'm after, but I researched how to input pounds, stones and points of a pound for a while, that's why I'm using the concatenate formula in column G.
Using your formula 13 stone 10.5 pounds (closer to 14 stone) shows as 13.105 stones (closer to 13 stone).

I've tried adding a new column (H) and used your formula so your numbers show right next to column G stones, pounds and points of pounds and you can see the difference.