Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Line chart coloring

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

2 Replies
sujeetsingh
Master III
Master III

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

Not applicable
Author

Sujeet

That just changes the line color, not the color Above and below the line. Can you have a look at this for me.