Re: Excel Chart

For a graphic solution that relies on piece-wise linear interpolation,
check the Excel | Add-Ins | 'Interactive Chart' add-in available from
my site.

For non-graphical solutions that include 'line/curve of best fit' use
LINEST to get the equation of best fit and compute the x/y values from
there.

To duplicate (at least as closely as possible) XL's smooth curve, check
the google.com archive of the XL NGs for code based on cubic spline fit
posted by Dave Braden.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <016901c3ad56$7827c1d0$a501280a@phx.gbl>,
anonymous@discussions.microsoft.com says...
> 0 0
> 2 0.221
> 4 0.532
> 6 0.814
> 8 1.25
>
>