Andy Pope has instructions for a conditional line chart:

http://www.andypope.info/charts/conditionalline.htm


ReadyToLearn wrote:
My boss wants a data line in my chart be green when abouve goal and red when
below goal. I do not think it is possable, but I thought I would check out
here first.


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