Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anybody know if there's a way to make all negative numbers in parenthesis and give them a red color for the whole document, instead of manually doing it for every chart? In other words, can I do this in the script? Thank you!
Hi,
To give color to values is not possible I suppose. Especially when you work with aggregation in charts.
Regards,
Andrei
For parenthesis you can go to document properties (Ctrl + Alt + D) and go to Number tab and drag on all the field names and use give it whatever format you want to give it. For instance $#,##0.00;($#,##0.00) (Negative Number dollar number will be with parenthesis)
Hope this helps.
Best,
S