ASE Home Page Products Download Purchase Support About ASE
ChartDirector General
 Forum HomeForum Home   SearchSearch

Message ListMessage List     Post MessagePost Message

  how to set the negative sign before the currency symbol in the axis
Posted by Moses on Jan-02-2024 15:12
| Reply | Monitor
Attachments:
Hi,

I used the format string: "${value|2,.}" to format the string for the vertical axis, for the negative value, it will show the negative sign after the currency symbol, which looks like "$-1,000.00". Now there is a request to show the negative sign before the currency symbol, which looks like "-$1,000.00" (please note the Excel shows it this way).
How can I set the format string to show it in this way?
C1.PNG
C2.PNG

  Re: how to set the negative sign before the currency symbol in the axis
Posted by Peter Kwan on Jan-02-2024 18:07
| Reply | Monitor
Hi Moses,

You may use "{value|2,.-$}". See the section "Number Formatting" in the following page:

https://www.advsofteng.com/doc/cdcpp.htm#paramsub.htm

Best Regards
Peter Kwan

  Re: how to set the negative sign before the currency symbol in the axis
Posted by Moses on Jan-03-2024 11:12
| Reply | Monitor
Thanks, it's very helpful.