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

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.

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

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)



"Excel Charts" <Excel wrote in message
...
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.

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

Here's an illustrated explanation of a conditional chart:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob Phillips" wrote in message
...
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)



"Excel Charts" <Excel wrote in message
...
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.