Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format in stones & pounds and then present on chart
I am trying to create a chart to track weight in stones & pounds over a given
time period. I have already looked at other posts on this but none of them cover how the y axis on the chart can have 14 minor grid lines representing the pounds between the stones grid lines, e.g. 14 stone 12 pounds on the 12 minor grid line between 12 & 13 stone. Can anyone please help? -- Regards Pete |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to format in stones & pounds and then present on chart
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 he http://peltiertech.com/Excel/Charts/ArbitraryAxis.html http://peltiertech.com/Excel/Charts/ArbGridLabel.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Pete Harris" wrote in message ... I am trying to create a chart to track weight in stones & pounds over a given time period. I have already looked at other posts on this but none of them cover how the y axis on the chart can have 14 minor grid lines representing the pounds between the stones grid lines, e.g. 14 stone 12 pounds on the 12 minor grid line between 12 & 13 stone. Can anyone please help? -- Regards Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert kilograms to stones AND pounds | Excel Discussion (Misc queries) | |||
How do I format cells to accept stones and pounds? | Excel Discussion (Misc queries) | |||
how can I put weights in stones and pounds into an excel spreadshe | Excel Discussion (Misc queries) | |||
how can i use imperial units eg stones and pounds | Excel Discussion (Misc queries) | |||
I've got a formula for stones and pounds - how do I get an excel . | Charts and Charting in Excel |