Forum Discussion
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...
Hi ..
This is definitely not the best solution, but give a try. Change it to column chart and add a conditional column that have the values (Above limit, below limit, ...) and use it as legend as the picture below. Below 1 is black and above 1 is green.
Cheers,
Alaeddin
Hello, I like this idea, but how did you add the conditions?