Conditional Formatting on a Bar Chart

[Andrew Tom]

Hey, I hope you can help me with this...

I have a bar chart with two values, the target value and the actual value. What I need to do is get the bars with the actual value, that are more than 3% off from the target, to light up in a different color from the rest of them.

I do hope that is clear enough. The target data are in C2-C17 and the actual values are in D2-D17, if that helps.


I tried Peltier's site and his graphs but alas, I think it went a little over my head. I think my problem is somewhere with the 3% difference that I need to get in there. How do I work it in the function?

[Bryan Hessey]

Hey, I hope you can help me with this...

I have a bar chart with two values, the target value and the actual value. What I need to do is get the bars with the actual value, that are more than 3% off from the target, to light up in a different color from the rest of them.

I do hope that is clear enough. The target data are in C2-C17 and the actual values are in D2-D17, if that helps.


I tried Peltier's site and his graphs but alas, I think it went a little over my head. I think my problem is somewhere with the 3% difference that I need to get in there. How do I work it in the function?

Hi,

I think you need to split the actuals into two sets (two Series) via an If statement, thus (something like) E2:E17 woud be actuals within 3% and F2:F17 the remainder, the two series could then be coloured as required.

hth
---