Background Color Chart

[#1]

Can anyone help me to solve this problem

I am trying to color the bars on values

If current year values < previous year then make it red else green. It will be applied only on year 2011,2012,2013 as 2010 will be the base year

Many thanks for the help

[#2 · Accepted solution]

HI

please check this maybe help you

[israrkhan]

Hi Sunny,

on your expression tab>> click on expression plus sign to expand the expression,

and put the expression like this if(sale < Previous(sale),Red(),Green()) on Background Color property.