I have a chart that presently has two groupings on the x-axis: Year & Qtr. I'd like the Year labels to be one color, and the Qtr labels to be a different color. (All year labels should be Black, all Qtr labels should be Blue). I can see that an expression can be written to handle this dynamically, but I'm banging my head trying to figure it out...
Any help?
Thanks in advance,
Pete
1. Right click the field and select properties.
2. Click the point labels tab.
3. Click the label style button.
4. In the color expression, enter something like this:
=IIf(Fields!Year.Value = 1900, "Black", "Black")
Do the same for the Qtr field.
=IIf(Fields!Qtr.Value = " ", "Blue", "Blue")
The expressions may not be 100% accurate, but if you play around with this, you should get what you want.
No comments:
Post a Comment