Color coding in line chart

[Anonymous]

Hi, I have a scenario where i am showing week on week Sales in line chart. I want to change the color of line chart symbol as per the below thing: if current week sales amount is less than prev week sales amount then current week sales symbol should be red..else green. same goes for other weeks, i.e. if prev week sales amount is less than prev to prev week sales amount, then prev week symbol should be red else green.

I am hoping an early reply as this is an urgent requirement.

Thanks

[ogautier62]

Hi

May be try to use two expression

One with sales< the other> with two different colors

[Anonymous]

Hi,

You can use PEEK function to get the value of prior week and compare with current week. Then use this in Expression --> Background Color.

Hope this helps.

Thanks

[Frank_Hartmann]

like this?

[ogautier62]

is this what you want ?

it seems good I didn't think at that