Chart question

[#1]

Hi,

I have a bar chart where I want to set the colours to red or greeen.  Red if the 'follow up year' is <2014 and Green if >=2014.

Then the same for the month ie; if it's Feb in 2014 I want Jan to be red and the other months green.

Hope that makes sense, look forward to you advice!

[#2]

Hi Sara

use the background colour to set

if (year=2014, red(), green())

same for month but you should better set a variable with your last month-year (feb-2014 under date format 01/02/2014)  and compare to $(var)

best regards

Chris

[#3]

I can't seem to be able to change it in the colour tab, does this need to be done in the script??

[#4]

Hi Sara

the background to modify is in tab "Expression"

Result gives something like this

best regards

Chris

[jonathandienst]

Hi

On the charts Properties | Expressions tab, click the + sign next to the expression and enter the colour expression in the background colour option.The field Year must have a single possible value for each value of the dimensions.

HTH

Jonathan

[rustyfishbones]

Hi Sara,

you add the IF Statement here

[#7]

[Anonymous]

Following on from Chris's answer, you need to click on the little + next to the expression in the expressions tab, then choose Background Colour

[amit_saini]

Hi Sara

You need to give condition in Background Color option :

[#10]

Finally it's working!!!!  However, my 'others' column is red too and I want this grey.  Do I need to add another expression??

Thank you.