Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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))
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))
you're a genius swuehl! thank you!!