How do i calculate different conditions in the rows of the table.

[#1]

I have a table , for eg:

Name Sales Revenues Status(Traffic lights)

A        100      200        (if sales> revenues - green) -----> a condition for traffic light

B         30        30         (if sales<revenues- yellow) ------> a diff condition....

How do i acheive the same???

Its a table with almost 15 Names and has differnent condition for each Status calculation.

[alexandros17]

Click on the of the expression, you can use background or text color to display different colours but obviously you have to write conditions for each expression

[qv_testing]

Hi Sneha,

Goto chart properties ---->      Click the taggole(+) button----->

Background color  OR  Text Color you can write condition like

if(sales>revenus, green(),

  if(sales<revenues, yellow(), Red())

[Colin-Albert]

Have a look at the Visual Cues tab in Chart Properties.

This allows you to set the criteria for each expression.

[ashfaq_haseeb]

Like this.

Regards

ASHFAQ

[#6]

But how do i write different conditions for each row and assign the colors for the same?

[ashfaq_haseeb]

Did you check my file?

Regards

ASHFAQ

[#8]

Hi,

You can use Color Mix Wizard for assigning colors for each row.

Color Mix Wizard is present in edit expression dialog box - file menu.

You can give an expression and upper and lower limits to get the background color for each row.

[ashfaq_haseeb]

Hi,

You will not see file when you read this from inbox.

Open this thread in new window you will see all attachments.

Hope it helps

Regards

ASHFAQ

[#10]

I have a different condition for each row....

For eg :

in 1 row if i use green for sales>revenue

for the next row the conditon maybe sales <revenue

and next row sales = revenue....

these condition vary for each row(almost 15 rows)  and , i need to calculate '0' or '1' for the condition and assign a traffic light for the same.