Helighting and delighting Colors in conditional columns charts

[Anonymous]

Hi All,

Greetings

i am facing one issue in the  chart objects .

let"s us  assume i have straight table and block Chart in my QVW file.now after creating chart and straight table i need to helight particular using Conditional based and remaining Columns needs to be delighted.that i perform this colours Condition on Calculated Columns.please check Attached QVW file along With Screen Shot .

i need finally Out Put Like attached Screen Shot.and If it is not possible can you please suggest alternatives?

Regards,

Bobby

[Anonymous]

go to the chart properties->expression tab->expand the expression properties by clicking on plus sing and in the background color just write the expression for conditional coloring.

for example

  if(sum(sales)>=50,Green(),if(sum(sales)<50 and sum(sales)>=35, Yellow(), red()))

I hope this will help you...!!

Regards,

Sandip Satbhai