Thanks, Andy.




"Andy Pope" escreveu na mensagem
...
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