Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Graph data in 32nds

  1. #1
    New Member
    Join Date
    May 2004
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Graph data in 32nds

    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!

  2. #2
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Graph data in 32nds

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •