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

  • Thread starter Thread starter Excel Charts
  • Start date Start date
E

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.
 
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)
 
Back
Top