Fix color of stacked bar

[ninnartx]

Hi folks,

I'm trying to fix the color of my stacked bar chart but the problem is that I have 2 date fields (Actual Doc Date, and Contract Signed Date).

I'm graphing it by Contract Signed Date and have Actual Doc Date as a list box. You'll see that the color is fixed when no year is selected from the "Actual Doc Date" field. The colors change when I select a year from the "Actual Doc Date" field.

Is there a way to fix this? I've attached a sample file.

Thanks a lot !

[swuehl · Accepted solution]

Use as background color attribute expression

=pick( match(Only({<DocDate=>}Type), 'A','B', 'C','D', 'E'), rgb(70,178,157),rgb(240,202,77),rgb(227,123,64),rgb(222,91,73),rgb(200,200,200))

[ninnartx]

you're a genius swuehl! thank you!!