Tak a look at this and see if it helps

http://www.peltiertech.com/Excel/Cha...nalChart1.html


"David" wrote in message
...
How can I have a bar chart (cash flow) change color based on the value of
a
point -- either positive or negative?