Hi, I am having trouble changing my data set's colour. I can change colour of data if it is just > or < than a certain number but not if i wanted to have a certain colour between two values (eg. >250<300). If anyone has any advice it would be greatly appreciated. Thank you.
Tony
4 answers
Hi Tony,
It sounds like you need to write an IF statement with as many variations as you'd like colours, for example:
IF [SUM] >1 AND [SUM] <100 THEN "Green"
ELSE IF [SUM] >=101 AND [SUM] <500THEN "Orange"
ELSE "Red"
END
Then drag this field onto your colours shelf to assign colours to it, note that naming the bins 'green', 'orange' and 'red' does not give them these colours, you have to do this step, so they can be any colour.
Hope that helps,
Ben
