If it is a "LINE" chart, then your x-y values are ignored in favor of
1,2,3, ... (though Excel will use your values as labels to further
confuse the issue).
You probably intended what is done by an "X-Y (Scatter)", which appears
to use a 4-point Bezier curve for a smoothed fit.
http://groups.google.com/group/micro...6e73b9504082f?
Unfortunately, the address where Brian Murphy posted the algorithm is no
longer valid. Cubic splines will often approximate the smoothed Excel
curve, and David Braden posted an algorithm for cubic splines in these
newsgroups, which should be accessible via Google archives.
Jerry
klc6778 wrote:
> It is a line chart with x-y axies....I'm not sure if that answers your
> question...
>
> "Bernard Liengme" wrote:
>
>
>>On a Line or an XY chart?
>>--
>>Bernard V Liengme
>>www.stfx.ca/people/bliengme
>>remove caps from email
>>
>>"klc6778" <(E-Mail Removed)> wrote in message
>>news:FA711FAD-0AC7-4644-B987-(E-Mail Removed)...
>>
>>>I created a line chart in Excel and I wanted to find out if there was a way
>>>to find out the value on any particular point on the line (not one of the
>>>values I entered to create the line, but one in between)?
Similar Threads
