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
Format for Y-axis labels
Format for Y-axis labels
- Attachments
-
- Y-Axis label format.png (7.9 KiB) Viewed 1163 times
-
- Posts: 6344
- Joined: Tue Mar 20, 2018 5:34 am
Re: Format for Y-axis labels
Hello,
You can add a Calculated column with YourValue/1000 expression and use it in the Chart as value.
Thank you.
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
Hello,
Thank you for your reply. It worked!
Why dint it strike me, it was simple math. Anyways thank you.
Regards,
Zalak
Thank you for your reply. It worked!
Why dint it strike me, it was simple math. Anyways thank you.
Regards,
Zalak
-
- Posts: 6344
- Joined: Tue Mar 20, 2018 5:34 am
Re: Format for Y-axis labels
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.