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.