This chart displays a line that
changes colour depending on whether it is above or below a control line.
It is based on a xy-scatter chart, it does require the use of some vba
code to update the dummy series used.
The download
contains a example and brief notes on functions and data layout.