AJP Excel Information

Conditional line chart

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.