Hi,

Select the chart and then within the Chart Tools tab
Design Data group Select Data Hidden and Empty cells.
Connect data points with line.

Cheers
Andy


Joe wrote:
Hi

How can I interpolate 2 poins in a Line Chart?

In older versions of Excel this was so easy (Tools - Options - Graph - Plot
Empty Cells As -- Interpolate.

Thanks for your help.

Joe



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info