Chart Axis label Colour
I have a chart on a report that shows value of sales on the Y Axis. The value can be a positive or negative amount. I want the Label colour for the Y Axis to show negative amounts in Red and Positive in black.
My problem is i can not seem to find the correct syntax within the expression.
eg if i was doing the same thing to based on a field i would use IIF(Fields!FieldName.value <0, "RED"< "BLACK"). How do i write the expression to say if the Y Axis label shows less than zero to make the colour Red?
Can any one help me on this? Let me know if you need any more info and i can post what you need.
Thanks in advance