|
Subject:
|
Chart Axis label Colour
|
|
Posted By:
|
dmunro
|
Post Date:
|
9/12/2006 8:49:09 AM
|
Hello
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
Dave Munro
|
|
Reply By:
|
Itsa
|
Reply Date:
|
9/28/2006 3:30:08 PM
|
=IIF(Fields!FieldName.value < 0, "RED", "BLACK")
lookout for typo's
|
|
