Excel 2007 - Interpolate

  • Thread starter Thread starter Joe
  • Start date Start date
J

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
 
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
 
Thanks, Andy.




Andy Pope said:
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
Click to expand...
 
Back
Top