Line Graph

M

Mike

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
 
S

Shane Devenshire

Hi,

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