I want to create a stock chart - open/high/low/close - to which I can add one or more lines based on additional data that I have derived.

Does anyone know if this is possible in Excel 2007? So far, I've attempted to combine the OHLC stock chart with a line chart, and it tells me that these are incompatible.

Thanks.