Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a line chart and a bar chart in which I want to use the same expression to color.
Below is the expression and a screen shot of the two charts.
Is there a reason that they pie chart colors wouldn't work?
IF([Code] = '91'
,red()
,IF ([Code] = '83'
,blue()
,If(
= '84'
,yellow()
,green()
)
)
)
Try this you have some extra comma may be please check this now
IF( [Code] = 91,red(),
IF( [Code] = 83,blue(),
If(
= 84,yellow(),green() )))
That did not work. I also tried putting the values inside single quotes and that did not work either.
in Color by Expression,
Pick(wildmatch([Code],'91','83','84','85'),
red(),
blue(),
yellow(),
green()
)
or
Pick(wildmatch(
,91,83,84,85),
red(),
blue(),
yellow(),
green()
)
Expression seeem correct,
did you tried with RGB values instead of red,green,yellow? try once
Expression looks OK.
It works form me with red, green,yellow and blue functions. However does not work with RGB values.
Neither of these worked. I tried RGB values and those did not work either.
What version are you using?
3.4 SR 4
Can u please share with me a "test app" containing only these 2 charts?