Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Setting a Stacked Bar Graph Segment to Orange

Hi,

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!

1 Solution

Accepted Solutions
lorenwood
Contributor III
Contributor III

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)


View solution in original post

2 Replies
lorenwood
Contributor III
Contributor III

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)


Not applicable
Author

That worked perfectly. Thanks for your help!