Change column color in chart when column value is over/under goal

[Excel Charts]

No use of VBA or macros expected. It is believed to be Excel chart feature.
Any ideas on how to change column colors (Red/Green) if value exceeds or
meets the preset goal.
Eg. if goal is 4% - anything at or above 4 should show green and under 4
should be red.

 

[Bob Phillips]

Assuming your data is in A2:A20

B2: =IF(A2>=4,A2,NA())
C2: =IF(A2<4,A2,NA())

copy B2:C2 down, add some labels to B1:C1, then chart B1:C20.

This will give you two series, one for the aboves, one for the rest.

Select each data series, right click, choose format, and set the colour as
required.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jon Peltier]

Here's an illustrated explanation of a conditional chart:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon