Graphing Problems With Excel 2003

[ExcelIlliterate]

Hi, first time posting, so I'm not sure how much information I need to place here. I'm trying to create a graph with two line: One is a target, just a straight horizontal line that goes from one end of the graph to the other, the other line is one of various points (goes up and down along the axis). What I want to do with this graph is make the portion of the other line that goes below the horizontal target line a different color from the portion above it. I know how to make the line a different color from point to point, but the target line cuts the data line in half. If anyone could help me with this, I would be forever grateful.

Thanks in advance, and if you need more information just let me know. If you want to see the graph you can also let me know. Sorry if this isn't enough information, but I don't know a whole lot about Excel formulas and am afraid I would only confuse those who may help if I tried to describe it.

 

[Jon Peltier]

He he, no, he's just got to try a little harder, pull out a few hairs....

 

[dcardno]

he's just got to try a little harder, pull out a few hairs....

What's the point if you don't pull out the occasional clump??

See Woody's Lounge for a solution...