Jon Peltier has instructions for conditional charts:

http://www.peltiertech.com/Excel/Cha...html#CondChart


B wrote:
Does Excel allow you to use conditional formatting in charts?
I have a bar chart that I am locking the y-axis at specific values. I would
like to change the color of any bars that are graphing outside the locked
y-axis.

Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html