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

posted on March 21st, 2019

Answered

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/

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

2 answers

Please login or Register to Submit Answer