How to format chart axis values to thousand(K), million(M) ?

Ravi asked on March 21, 2019

Hi Team,
I’m a licensed user.
How should we format pivot-chart axis-label values from numbers to thousand(K), million(M) etc., ?
Examples:

  • $1000.00 to $1K
  • $50,000.00 to $50K
  • $100,000.00 to $100K
  • $1000,000.00 to $1M
  • $1000,000,000.00 to $1B

Note:
We have also represented this customization via snapshot. Please get it.

Attachments:
AxisValuesToK&M.png

2 answers

Public
Tanya Gryshko Flexmonster March 22, 2019

Hello, Ravi,

Thank you for writing to us.

Chart axis values can be formatted with the help of afterchartdraw event. Please check out the following demo: https://jsfiddle.net/flexmonster/qsp0hr37/.

Hope it helps.

Regards,
Tanya

Public
Ravi March 30, 2019

Hi Tanya,
Thanks for your support.
 
This fix is working fine but due to this, the space issue is arising.

We have clearly explained this issue in the below ticket, please check it.
https://www.flexmonster.com/question/how-to-adjust-chart-axis-label-and-value-spaces/

Please login or Register to Submit Answer