Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to set one of the segments in my stacked bar chart to orange, but I do not see a function named orange(). The expression I am using to change the background color of the segments is:
if([Cost Quartile]='25th', Green(), if([Cost Quartile]='26th - 50th', Yellow(), if([Cost Quartile]='51st - 75th', blue(),if([Cost Quartile]='Above 75th', red()))))
This statement works, except that I want the section that is currently blue to be orange. How do I do that?
Thanks in advance!
Hi sspangler8 Try:
=
if([Cost Quartile]='25th', Green(), if([Cost Quartile]='26th - 50th',Yellow(), if([Cost Quartile]='51st - 75th', RGB(255,128,0),if([Cost Quartile]='Above 75th', red()))))
Instead of Blue(), use RGB(255,128,0)
Hi sspangler8 Try:
=
if([Cost Quartile]='25th', Green(), if([Cost Quartile]='26th - 50th',Yellow(), if([Cost Quartile]='51st - 75th', RGB(255,128,0),if([Cost Quartile]='Above 75th', red()))))
Instead of Blue(), use RGB(255,128,0)
That worked perfectly. Thanks for your help!