The data points will not connect in a line chart due to missing data in
between. I see a thread where you can solve this problem by selecting the
interpolation option in Tools menu Options Chart tab. But I can not find
this Chart tab options under Excel option in Excel 2007. Could someone
please tell me how to deal with this problem in Excel 2007? Thank you very
much.

turen