How to put multiple colors in single bar in a bar chart ? Like Sales 100-200 should be in Red,sales above 200 should be in Green
Can you explain a bit more about what you are trying to achieve?
Thanks for your reply , I am trying to create a bar chart with country and sales . i am trying to color the graph depending up on the sales .for example (sales between 100-200 must be in red and sales above the 200 must be in green with in the same bar )
Set to below in Background colour definition of sales expression
if(sales >200, Green(),Red())
No!!!! it's not workiing .i had tried before. what i need is it must be colored with in the same bar
hi anbu cheliyan thanks for your reply ,
Here in year 2012 i have sales near to 300 and my requirement is in 2012 graph must be in red and green as condition stated earlier .Condition is sales <100 must be in red and sales>100 should be green ).