Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am looking at coloring on a line chat, where everything above a variable amount is red, and below that green. The amount is a target amount which depends on selecting made in the chart, so it may be as low as a hundred thousand or may run into billions. I have looked at thread 116265 but it is not helping much as the amounts can change with selections. In short I need it to be Green where Target is reached or exceeded and Red when now reached. I do have two chart on top of each other, one with the Actual amount with data points and a dotted line with the Target amount, but now just need the coloring above and below the line
On expression + sign click >> there will be option of Background colour.
On there write expression
if(sum(Sales)>vTarget,red(),Green())
You can write with other conditions too.
follow this thread
Change the Color of Bar depending Upon a condition not on Value
Sujeet
That just changes the line color, not the color Above and below the line. Can you have a look at this for me.