Conditional formatting excel chart

[ganeshm]

hi...

I would like to apply conditional formatting for excel chart. I am bit confused as how to apply it for 5 factors mentioned in the chart.

Which cell has to be taken to apply conditional format.

Sheet is attached for your perusal.


Regards,
ganeshm


Thread Moved

 

[bobhc]

A stab in the dark says you want to use the project KPI's, but you do not say what CF you are trying to achieve.
Static CF, Dynamic, what information do you want to be in the chart.







.

There are countless ways to achieve what we don't know you want!


.

 

[ganeshm]

Dear Sir,

Apologies...

Target Actual
1000 700
10 4
60 50
0% 1
0% 2

From the above table:

1. if the "TARGET" and "ACTUAL" is same then as per the first chart, bar needs to display green.

2. if the "ACTUAL" is below the "TARGET" is same then as per the first chart, bar needs to display yellow.

3. if the "ACTUAL" is above the "TARGET" is same then as per the first chart, bar needs to display red.

regards,
ganeshm

 

[Somendra Misra]

Hi,

See the attached file with chart on Sheet1.

Regards,

 

[ganeshm]

thank you

 

[Somendra Misra]

Welcome back.

Regards,