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)?
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)?
On a Line or an XY chart?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"klc6778" <[email protected]> wrote in message
news:[email protected]...
>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)?
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" <[email protected]> wrote in message
> news:[email protected]...
> >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)?
>
>
>
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" <[email protected]> wrote in message
>>news:[email protected]...
>>
>>>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)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks