Line Graph

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
Hi,

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