Hi,

You need to calculate that value using a formula

Assuming the NA value is in cell B4 this will tell you the mid Y value

=B3+((B5-B3)/2)

Cheers
Andy

Ben wrote:
When chart data contains #N/A between 2 data points there is a feature in
Excel that interpolates the data in the middle. This is very useful but is
there a way of getting hold of that interpolated data. I mean the actual
numbers. It would save me a lot of time having to calculate them myself.
Thank you

--

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