Forum Discussion

ashish_soni's avatar
ashish_soni
Frequent Visitor
9 years ago

line chart - conditional color variation

Hi, I have to draw a single line chart which has different colors for values above an upper limit, a second color for values between the lower and upper limits and third color for values below lower...
Need Help
Show and Tell
nickmishko's avatar
nickmishko
Icon for Advocate I rankAdvocate I
9 years ago

Hello, I like this idea, but how did you add the conditions?

alaeddin14's avatar
alaeddin14
Icon for Helper I rankHelper I
9 years ago

hi there .. 

 

Just add a new column to your dataset with a simple if statment. Let's say your threshold is 1, then it should be something like: 

New column = if(column > 1 , "High" , "Low")

Then put this new column in the legend so the the bars will be colored according to the value if it's higher or lower than the threshold. 

 

Cheers,

Alaeddin