Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sometimes you'll want to display millions in a shorter format. For instance, I may want $23,685,325 to display as $23.6M in my chart. In order to do that, in your Expressions tab, you'll need to divide your number by 1M and then go to the Number tab, choose your expression, choose Money as Number Format Settings, and in the Format Pattern box, enter this custom format: $#.#M
Thanks!
$23,685,325 /1000000
expression divided /1000000 // as 1 M$=1000000$
go to number in chart properties select fieldname ->fixed to 2-> in text write $ before
apply
hope this helps