Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using the background color property to assign colors to known values, but there are dozens of possibilities and i only want to fix the color for a few of them. The result is that all other values just show up as white.
Background Color property:
if([Name]='Tom',green(),
if([Name]='Bob',blue(),
))
All the other values for Name just show up as white, i just want the default or random colors to be used.
Any ideas?
Thanks
Hi Tom,
try this:
Delete the comma at the End. It says, if the condition are not true, use nothing. That is why your other Names are white.
if([Name]='Tom',green(),
if([Name]='Bob',blue()
))
If you like not only one color for the other valure. Set in the color tab in the chart setting the checkbox "multicolor".
Works fine for me.