Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
How do I make the data labels show $19.8 M, $18.9 M, and $15.5 M? I can get them to say $19M, $18M, and $15M, but can't figure out how to add the decimal.
Thanks!
Hi,
This is what I used:
Hope this helps.
Thanks
Hi,
one solution might be also:
=Dual(Num(Sum(Value)/Pow(10,3*Div(Log10(Sum(Value)),3)),'$#,##0.0')&' '&Pick(Div(Log10(Sum(Value)),3),'K','M','B','T'),Sum(Value))
hope this helps
regards
Marco