Hi,

With the chart selected choose Tools, Options, Chart and set Plot empty
cells as to Interpolated.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mike" wrote:

In Excel 2000, how do I connect points in a line graph if I am missing
intervening data. For example if the x axis is 1,2,3,4,5,6 and I have data
at only 1,3,5,6, how do I connect these points.
Thanks