Graph data in 32nds

[Jayzlak]

Does anyone know how to graph data in Excel in 32nds. I can convert decimal data into 32nds but cannot graph it. The problem is that whilst a number may move from 100.31 (where this means 100 and 31 32nds) to 101.00 and this represents a single 32nd movement Excel only reads it in decimals and interprets it as a move of 0.61. Needless to say this gives a very bizarely shaped graph!

 

[SydneyGeek]

You need to store the number as the correct decimal (100.96875 for 100 31/32) but you can format it to display as 100 31/32. Format | Cells | Number. Select Fraction. Choose the second option (2 figures) and you'll be OK. Excel has built-in formats down to 16ths, but 32nds miss out...

Denis