DTINVN Posted September 24, 2019 Report Share Posted September 24, 2019 Have a chart with currency labels. The values are large and so when I use labels, the values overflow the bar and clutter the graph. I would prefer to reformat the label to reduce the display size by changing the label format. Son instead of : $3,256,876 --> $3.3M I have found some javascript to adjust the absolute value but not sure how and where to apply it. https://stackoverflow.com/questions/36734201/how-to-convert-numbers-to-million-in-javascript Quote Link to comment Share on other sites More sharing options...
0 JolliBeng Posted September 26, 2019 Report Share Posted September 26, 2019 H @DTINVN, If I understand you correctly, you want to reduce the display size of your label or some sort of rounding off the record value. That can be configured under the 'Configure Chart Options' of your DataPage. You can refer to this screenshot: If this does not help, I suggest that you provide detailed information of what are you trying to achieve. ~JolliBeng Quote Link to comment Share on other sites More sharing options...
0 DTINVN Posted September 30, 2019 Author Report Share Posted September 30, 2019 On 9/26/2019 at 2:18 PM, JolliBeng said: H @DTINVN, If I understand you correctly, you want to reduce the display size of your label or some sort of rounding off the record value. That can be configured under the 'Configure Chart Options' of your DataPage. You can refer to this screenshot: If this does not help, I suggest that you provide detailed information of what are you trying to achieve. ~JolliBeng Hi, Thanks for the reply and followup. That configuration allows me to adjust the size of a number after the decimal point. It doesn't allow me to adjust the presented significant number format for large numbers. So, to illustrate in an example, if I have a number: 1,234,567.89102 - I can adjust the format to present. --> 1,234,567 (Eliminating the decimal numbers) But I can't set the number of significant digits so I can have the number presented as a rounded value. 1,234,567.89102 --> 1.2M Quote Link to comment Share on other sites More sharing options...
0 kpcollier Posted September 30, 2019 Report Share Posted September 30, 2019 You may be able to format these by using JS. I found this Stack Overflow link that is similar to this issue. The accepted answer may work, but the answer below it looks like it will cover all bases. Quote Link to comment Share on other sites More sharing options...
Question
DTINVN
Have a chart with currency labels. The values are large and so when I use labels, the values overflow the bar and clutter the graph.
I would prefer to reformat the label to reduce the display size by changing the label format. Son instead of :
$3,256,876 --> $3.3M
I have found some javascript to adjust the absolute value but not sure how and where to apply it.
https://stackoverflow.com/questions/36734201/how-to-convert-numbers-to-million-in-javascript
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.