Conditional Formatting on Line Chart?? 1

[sconti11]

I ma building some reports that contain both Line Charts as well as 100% Stacked Bar Charts.

So my question is, can I apply conditional formatting to the lines and bars, so that when the value falls under a benchmark value it turns red.

I have not found how this can be done yet....any insight will be helpful.

 

[RiverGuy]

On the series, you can change the color of the Fill or Border. You can use an expression like: =iif(SUM(Fields!SomeField.Value) < 100, "Red", "#00000000").

 

[sconti11]

Excellent!....it looks so easy...I was not looking in the right place....but that is why I am still a newbie!

Thanks!