Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to change the format pattern in the bar graph dynamically.
e.g. if values are displaying in the range of Million doller then, want to diaplay value on the bar as $ 100M,$ 200M etc.
if the values are in the range of Thousand doller, then i want to diaplay value on the bar as $ 200K, $ 200K etc.
how to achieve this?
Hi,
You can use the following expression:
If(SUM(Value) >= 1000000,
Num(SUM(Value), '#.##0 M'),
Num(SUM(Value), '#.##0 K')
)
Regards.
Hi,
I am not sure if you refer to this, but you can check Number tab inside Chart Properties and set values for Symbol, Thousand Symbol, Million Symbol...
Thank u for concern...
medina.. i've given all the settings in the Nuber tab of Chart properties already.
like in Symbol- $
Thousand - $K
Million - $M
Billion- $B
but this add the corresponding symbol on the y-axis,
my requirement is to show such symbol on independent bars of graph.
Magv, i'm actually looking for the same as suggested by you..
but i'm not getting that where should i put this condition.
because Format Pattern option under Number tab does not allow to use expressions.
Some editing in Magv idea:
If(SUM(Value) >= 1000000,
Num(SUM(Value)/1000000, '#.##0 M'),
Num(SUM(Value)/1000, '#.##0 K')
)
Regards,
Surya
Just add the symbol you want in the format pattern input box. this will display the symbol infromt of every number in the chart