Gauge Chart - Comma not decimal point for thousands

[#1]

Morning all,

I've tried a few different ways to try and get the gauge chart to show the number in it's correct format, e.g. 1,284,613 rather than 1.284.613

Is this possible?

Thanks,

Simon

[Gysbert_Wassenaar]

You can change the ThousandSep and DecimalSep variable in the script

SET ThousandSep=',';

SET DecimalSep='.';

Or you can set the Format Pattern for the expression on the Number tab. Or you can use the num function to specify a format pattern: num( myexpression, '#,##0', '.', ',')

[#3]

Thank you, I've tried those. Is it just that this chart can't produce commas?

[jonathandienst]

Hi

Perhaps a number format has been set for this chart. Check Properties | Number and change the format if necessary.

Jonathan

[Gysbert_Wassenaar]

The LED display doesn't support comma's. It can only display dots.

[#6]

Thanks G, that's what I was starting to suspect!

[#7 · Accepted solution]

The best way is in fact to use a text object and have the freedom within there.