Page 1 of 1

Format for Y-axis labels

Posted: Mon Jul 23, 2018 6:57 am
by zalak
Hello,

How to display values in thousands for Y-axis labels.
Example: for value "1.400.000 (CHF)" or "300.000 (CHF)", the y-axis should show "1.400 (TCHF)" or "300 (TCHF)". (see the screen shot)

I tried Format "C" but it does not work correctly. What to write in Format textbox to show lables like this.

Thanks & Regards,
Zalak

Re: Format for Y-axis labels

Posted: Tue Jul 24, 2018 11:05 pm
by Lech Kulikowski
Hello,

You can add a Calculated column with YourValue/1000 expression and use it in the Chart as value.

Thank you.

Re: Format for Y-axis labels

Posted: Wed Jul 25, 2018 9:46 am
by zalak
Hello,

Thank you for your reply. It worked!
Why dint it strike me, it was simple math. Anyways thank you.

Regards,
Zalak

Re: Format for Y-axis labels

Posted: Thu Jul 26, 2018 11:54 am
by Lech Kulikowski
Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.