Gauge Chart Numaric Values

[#1]

I have a requirement like in gauge chart i have to mention the values of numeric in 2K(form)

for example 200000-should display as 2K.I placed thousand symbol in number tab but its not working

[jyothish8807]

Hi,

You can try like this in your expression:

=Dual(sum(Sales)/1000 &'K',Sum(Sales)/1000))

Regards

KC

[tresesco]

Change your expression to something like:

Num(YourExistingExpression/1000, '$ #,##0.00K;$ -#,##0.00K')

[#4]

Its working but not completely because my requirement is 98.5K

[jyothish8807]

Hi Yeshu,

You can set it to decimal place as 1 in number tab.

Hope it helps.

Regards

KC