2 Replies Latest reply: Jul 11, 2014 5:24 AM by Ronnie Tok RSS

    Formating the Chart's figures by K or Million

      Hi, how do we control the numbers to present as thousands (K) or Millions (M) in a chart? I tried to do that in the chart properties under the numbers options, but couldn't figure out.

       

      Image below was the original figures:

      Capture.JPG

       

      Image below is the result AFTER I put in the Million Symbol, hoping the figures in the chart shrinks down by 6 digits, but it remains same. In fact, it would be great if the label can present as 0.9M or -5.7M or 16M or -6.3M, all rounded by 1 decimal place. Possible?

       

      Capture1.JPG

      Capture2.JPG