Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I defined the background colors of one of my expressions in my chart as follows:
If([Pareto Class] = 'C', LightRed(), If([Pareto Class] = 'B', LightBlue()))
Now I wonder if I could adjust the color by the following values:
Hue: 140
Sat: 240
Lum: 163
Red: 91
Green: 173
Blue: 255
This would really help me as I´ve a color blind colleague and we agreed on specifc colors that he can see.
Best regards,
Carolin
Hi,
Yes you can convert it using RGB(). Do you want to use the colors you have mentioned instead of LightRed() and LightBlue() respectively then might be something like this would help:
If([Pareto Class] = 'C', RGB(140,240,163), If([Pareto Class] = 'B', RGB(91,173,255)))
use rgb function:
ex:
If([Pareto Class] = 'C', rgb(91,173,255),red())
Hope this helps
Hi,
Create a inline table
load * Inline
[
Red,Green,Blue
91,173,255
];
and use this value in RGB( ) function
If([Pareto Class] = 'C',RGB(Red,Green,Blue), red())
You can create a Variables for this also.
Thanks & Regards
Hi,
Yes you can convert it using RGB(). Do you want to use the colors you have mentioned instead of LightRed() and LightBlue() respectively then might be something like this would help:
If([Pareto Class] = 'C', RGB(140,240,163), If([Pareto Class] = 'B', RGB(91,173,255)))
Thank you, this worked
Hi,
Other wise write some thing like this
load * Inline
[
Red,Green,Blue,Hue,Sat,Lum
91,173,255,140,240,163
];
and use this value in RGB( ) function
If([Pareto Class] = 'C', RGB(Red,Green,Blue), If([Pareto Class] = 'B', RGB(Hue,Sat,Lum) )
Thanks & Regards