Mini Bar Chart - Can you Rag Colour??

[#1]

Hi All

Can you RAG colour a Mini Bar Chart?

Also if you can - Can the Rag be based on differing Target values per Row?

i.e.

Row 1 target> 2=Green, Red,

Row 2  >1500=Green, Red.

I havent found a way of Rag the rows at all yet and am needing tofind how to do this ASAP

Many Thanks In Advance

Jo

[avinashelite]

got to expression tab in the chart properties> click on the + mark on  the expression >click on the background color

here if(sign(sum(amount)=-1,RED(),GREEN())

[#3]

Hi Thankyou for your reply

This isnt working for me they are all coming back as Green- its as if its assessing the overall RAG for the expression but not per month in the mini chart for the individual row data

Can you post a working example please?

[avinashelite]

Sorry, I was think in the actual bar chart . Your trying it in the min chart ok, can you post you app will check