Excel 2007 - Interpolate

[Joe]

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]

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]

Thanks, Andy.

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