Gauge Chart

[nihhalmca]

Hi All,

I want to display value (10,500.50 in thousands) in Gauge chart.

However Gauge chart shows value as '10.500.50'

My Requirement : display ',' instead of '.' after '10' (as thousand separator).

Thanks,

Regards,

NiHhal.

[sundarakumar]

Go no number tab and give comma in thousand seperator

-Sundar

[sunilkumarqv]

Hi,

On chart properties  number  tab make Format Pattern format like this #,###0  Hope you get the solution

[jagan]

Hi,

Try like this

=Num(Num(Replace(Left('10.500.50', Len('10.500.50') -3), '.', ',')) + Num(Right('10.500.50', 2)/100), '#,###.#0')

Regards,

Jagan.

[jagan]

Hi,

Or simply this

=Num(Num#(Replace('10.500.50','.', ''), '#,###')/100, '#,###.#0')

Regards,

jagan.

[#6]

If you are using LED you won't get comma

[nihhalmca]

Thanks for reply Sundarakumar.

I tried this way but not working

NiHhal.

[nihhalmca]

Thanks for writing

But not working

NiHhal.

[nihhalmca]

Hi Jagan, thanks for writing

Please let me know where can i paste this script ex: number tab or expression tab.

NiHhal.

[sundarakumar]

Hi Nihhal,

if the Right part is ur problem, then it cannot be shown as comma.. better go for Left side representation..

-Sundar